Data Transformation Engine Introduction to the Design Studio

Chapter 5 - Database Interface Designer Overview
Introduction to the Design Studio
54
Database Adapters
The Mercator database adapters provide the connectivity to the RDBMS for
retrieving input data and routing output data. Database adapters provide the
option of using a driver to connect to the platform of your choice so you can
automatically create type trees for database queries and tables.
The Windows-based database adapters are installed with the Database Interface
Designer as part of the Design Studio. You can also install database adapters on
additional systems to provide remote database connectivity. See the Getting
Started book for details on platform support.
Note Non-Windows database adapters do not require the Database Interface Designer if
you plan to only use mtsmaker without a database/query file (.mdq) to generate
each type tree. For information about using mtsmaker, refer to the Resource
Adapters Reference Guide.