Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
72
Chapter 4 - Database Type Trees
Use the Database Interface Designer or mtsmaker to generate a type tree to be used
in a map. You can also define your own type tree using the Type Designer. However,
for the database adapters to correctly process your database data, your type tree
must conform to the format described in this chapter. For information about using
mtsmaker to generate type trees, refer to the Resource Adapters Reference Guide.
Note Although you can manually create a type tree for a table or a query using the
Type Designer, it is not recommended.
The following examples represent type trees generated by the Database Interface
Designer from two queries (one SELECT and one calls a stored procedure), a
table, a stored procedure, and a message queue.