When a new DRS Connector stage is added to the server or
parallel canvas, you must specify the connection information for the
database that the stage connects to at run time.
About this task
When the job starts, the stage connects to the specified
database by using the specified database credentials. As the job runs,
the stage reads data rows from the database or writes data rows to
it, depending on whether output or input links are defined for the
stage, respectively.
Procedure
- Select the relevant database type from the Connector drop-down
list.
- Select the relevant database client version. For
example, if an Oracle database type is selected, and an Oracle 11g
version is installed on the InfoSphere®
DataStage® Server
engine machine, the Variant value must be set to 11. If the Oracle
10g client is installed, the Variant value must be set to 10. Some
database types have only one variant. If you specified job parameter
for the database type property, then you can select the variant for
all supported database types, because the actual selection of database
type to use at runtime is done at a later point.
- Set the Connection string property
value. This value identifies the specific database that you want to
connect to. The database client environment needs to be set up properly
to resolve this value and to connect to the corresponding database
server.
- Set the Username property to the
value that identifies the user name for authentication and authorization
with the database.
- Set the Password property to the
password value of the specified user name. The password is displayed
and stored by the stage in encrypted form.
- Optional: You can set the environment variables
by using the Administrator Client, to appear as default variant values
for respective connector as follows: CC_DRSCONNECTOR_DEFAULT_CONNECTION_VARIANT_IBM__DB2VARIANT,
for the Db2 connector, CC_DRSCONNECTOR_DEFAULT_CONNECTION_VARIANT_ORACLEVARIANT,
for the Oracle connector, and CC_DRSCONNECTOR_DEFAULT_CONNECTION_VARIANT_ODBCVARIANT,
for the ODBC connector.
Make sure that all parameters are specified
in capital letters.
Note: These values are effective only when
the connector stage editor is opened for the first time.