Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Defining a Database
Database Interface Designer Reference Guide
37
Setting Description
Data Source
Database
Interface
Designer
Note Both this and the Runtime settings are
platform-specific setting. On other
platforms, you may have different setting.
Again, refer to the platform-specific
adapter reference guide or the context-
sensitive help for more setting-specific
information.
This is the name of the data source used to
access database information for design-time
(pre-production or testing) purposes.
Runtime This is the name of the data source used to
access database information for run-time (map
execution) purposes.
Security
User ID This is the user ID used to access the database. If
you do not know this information, contact your
database administrator. There is no default value.
Password This is the password used to access the
database. If you do not know this information,
contact your database administrator. There is no
default value.
To define a database
1 From the Navigator, select Databases under the .mdq file.
2 From the Database menu, select New.
or
Right-click the Databases object in the Navigator and select New.
The Database Definition window appears.
3 Enter information for the remaining settings as desired.
4 Click OK.
The new database name appears in the Navigator next to the database icon
(
).