Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
8
Chapter 1 - Introduction
This document provides information about the Database Interface Designer. It
explains the functions and dialog boxes used to utilize your database-specific
adapters when accessing your database as map sources or targets.
Note For information about using specific adapters, refer to the respective reference
guides.
Overview
The Database Interface Designer is used to import metadata about queries,
tables, and stored procedures for data stored in relational databases. It is also
used to identify characteristics of those objects to meet mapping and execution
requirements such as update keys and database triggers.
The Database Interface Designer is used to:
♦ specify the databases to use for a source or target
♦ define query statements
♦ automatically generate type trees for queries or tables
After defining database queries or tables in the Database Interface Designer,
define your map in the Map Designer where, 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.
Database connectivity is supported under the control of Relational Database
Management Systems (RDBMS).
The adapters provide the option of using a driver to connect to the platform of
your choice so that you can automatically create type trees for database queries
and tables. The adapters also provide a test environment on the PC for maps
using data stored in a database.
You can also install adapters on additional systems to provide remote database
connectivity, such as with ODBC, Oracle, Sybase, or DB2, on operating systems
such as HP-UX, Sun Solaris, AIX, and so on.