Database Interface Designer overview

The Database Interface Designer is used to import metadata about queries, tables, and stored procedures for data stored in relational databases. It is also used to identify characteristics of those objects to meet mapping and execution requirements such as update keys and database triggers.

The Database Interface Designer is used to:

• specify the databases to use for a source or target
• define query statements
• automatically generate type trees for queries or tables

After defining database queries or tables in the Database Interface Designer, define your map in the Map Designer where, in map cards, you can specify an input source as either a query or a stored procedure and an output target as either a table or a stored procedure.

Database connectivity is supported under the control of Relational Database Management Systems (RDBMS).

The adapters provide the option of using a driver to connect to the platform of your choice so that you can automatically create type trees for database queries and tables. The adapters also provide a test environment on the PC for maps using data stored in a database.

You can also install adapters on additional systems to provide remote database connectivity, such as with ODBC, Oracle, Sybase, or DB2®, on operating systems such as HP-UX, Sun Solaris, AIX®, and so on.

Non-Windows adapters do not require the Database Interface Designer if you plan to only use mtsmaker without a database/query file (MDQ) to generate each type tree. For information about using mtsmaker, see the Resource Adapters documentation.