Data Transformation Engine Introduction to the Design Studio

Introduction to the Design Studio

Chapter 5 - Database Interface

Designer

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.

Overview

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 run-time database

connectivity to the Mercator 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.