Database Interface Designer

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

Use the Database Interface Designer to:

• Specify the databases to use for a source or target, along with the user IDs and passwords required for the connection.
• Define query statements.
• Automatically generate schemas for queries, stored procedures, input and output parameters, or tables.
• Define tables for which any inserts, updates, or deletions would trigger maps using the Launcher.

If connectivity to the database server is not available from the development platform, the mtsmaker utility is provided to execute on the server platform. This utility creates a script file that can be transferred to the development environment to generate the schemas.