Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
91
Chapter 5 - Database Sources and
Targets
This chapter explains how to use the Map Designer to configure a map having a
database source or target. For detailed information about using the Map Designer
and defining sources and targets in input and output cards, refer to the Map
Designer Reference Guide.
Using a Database as a Source
After you have used the Database Interface Designer to define a query for a
database, you can use that query as an input source.
Note You can use either a standard SQL SELECT query or a query using a stored
procedure. For specific information about using stored procedures, refer to
Chapter 8 - Using Stored Procedures.
To use a database query as a source
1 Define the database using the Database Interface Designer.
2 Define a query to extract data from the database.
3 Generate a type tree for the query.
4 Use the Map Designer to create a map with an input card referencing the query.
Defining a Database Source in the Map Designer
When you generate the type tree from a query, one of the types in the tree is a
group representing the results from executing the query (for example, DBSelect).
Select this type as the input card type when defining an input card for the
executable map.
After you have defined the query and have generated the type tree, using a
database as an input is very similar to using a file as input.
Using the Map Designer, specify Database as the GET > Source setting in the
input card and supply the name of the .mdq file containing the definition of the
database and query you want to use. Refer to the following procedure and
example.