Data Transformation Engine Introduction to the Design Studio

Introduction to the Design Studio
53
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.