Database Interface Designer configuration

The Database Interface Designer must be configured prior to use.

After defining database query files and database table connectivity in the Database Interface Designer, define your map in the Map Designer. 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.

The Database Interface Designer is used to support business processes that read from and write to databases under control of a Relational Database Management System (RDBMS). The Database Interface Designer provides runtime database connectivity to the Transformation Server. This connectivity is supported with database-specific adapters or open database connectivity (ODBC). ODBC is a programming interface that enables programs to access data in database management systems that use structured query language (SQL) as a data access standard.

The Database Interface Designer:

• Provides connectivity to existing resources.
• Integrates multiple resources.
• Provides transactional control when resources support transactions.
• Combines transformation capabilities and resource connectivity.

All database access is transactional for resources that support transactions.