Data Transformation Engine Resource Adapter Reference Guide

Resource Adapters Reference Guide

Chapter 5 - Database-specific

Adapter Information

This chapter discusses the database-specific adapter information. The use and

operation of these adapters is covered in each database-specific adapter reference

guide and help file.

Overview

Using the Database Interface Designer with the database adapters, data stored in

a database under the control of a Relational Database Management System

(RDBMS) can be easily identified, defined, and accessed as the source or target

for a map.

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 the specifications for accessing each database in the Database

Interface Designer, define your map in the Map Designer where, in map cards,

you can specify a query or stored procedure as an input source or a table or a

stored procedure as an output target.

The Database Interface Designer is installed as part of the Design Studio, along

with all of the Windows-based database adapters. These Windows-based adapters

provide connectivity to databases residing on your local PC and on other platforms

so that you can automatically create type trees for those queries and tables. The

adapters installed as part of your Design Studio provide a test environment for

maps that access the database.

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 Chapter 6 -

Generating Type Trees Using mtsmaker.