Understanding the MDQ XML format

The database/query (MDQ) file is a configuration file that is used by IBM Transformation Extender when accessing databases using database adapters. Some of the information contained within an MDQ file could include the following:

• database logical names (to distinguish among settings for the databases defined in this file)
• database adapter types
• database connection parameters
• user names and passwords
• information about tables
• queries and stored procedures accessed by the adapters
• primary keys for the tables (used for the database updates)
• event trigger information for the Launcher