Database Interface Designer

Edit online

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

Use the Database Interface Designer to:

Specify the databases to use for a source or target.
Define query statements.
Automatically generate type trees for queries or tables.