Data Transformation Engine Services Guide

Chapter 22 – NonStop SQL/MP, NonStop SQL/MX, and ODBC Adapters
128
Interface Designer
1. Create an ODBC Data Source.
• For NonStop SQL/MX and ODBC adapters, create a data source by using the
NonStop ODBC/MX 1.8 Driver in the Window’s ODBC Data Source
Administrator.
• For NonStop SQL/MP adapter, create a data source using the Attunity Connect
Driver in the Window’s ODBC Data Source Administrator.
2. Use Database Interface Designer to create type trees.
• Create a database query file (.mdq).
• Create a database definition using the ODBC Data Source created in step 1.
• Generate the type tree for a query or table in a NonStop SQL/MP, NonStop
SQL/MX, or ODBC-compliant Relational Database Management System.
Note: The recommended method for generating type trees for NonStop SQL/MX is
by using the Database Interface Designer on Windows through an ODBC connection.
Using NonStop SQL/MP, NonStop SQL/MX,
and ODBC Adapters in a Map
Adapter commands can be specified either in:
• Source of input card
• Target of output card
With or without a .mdq file
• Use the Map Designer to specify Database as the value for the Source setting.
• Use the GET > Source > Command setting in the Map Designer to enter the
database adapter-specific commands for a source.
• Use the PUT > Target > Command setting in the Map Designer to enter the
database adapter-specific commands for a target.
A source can be overridden by using the Input Source Override – Database execution
command (-ID) by using a RUN function or on the command line.
A target can be overridden by using the Output Target Override – Database execution
command (-OD) using a RUN function or on the command line.