Data Transformation Engine ODBC Adapter Reference Guide

ODBC Adapter Reference Guide
10
Chapter 3 - Database Interface
Designer Settings
When you define an ODBC database in the Database Interface Designer, in
addition to the common settings available for all of the database adapters in the
Database Definition dialog box, you need to enter the information specific to
ODBC.
Database Definition Dialog Box
The ODBC adapter-specific settings are described in the following table:
Setting Description
Data Source
Database
Interface
Designer
The data source you defined in your
development PC that is used by the
Database Interface Designer to access
the database information for design-
time purposes
Runtime The data source you defined in your
ODBC database host platform to be used
for access to the database for run-time
(map execution) purposes both from the
Map Designer and a Command Server
Security
User ID The user ID used to connect to the
database
Password The authorization password to connect
to the DB2 subsystem