Upgrading from Version 10.4.0 and Later (10.5.6)

Back Next

Step 6. Configure Database Client Environment Variables

Configure database client environment variables on the machines that run the Data Integration Service process.

After you configure the database environment variables, you can test the connection to the database from the database client.

The following table lists the database environment variables you need to set:

Database	Environment Variable Name	Database Utility	Value
Oracle	ORACLE_HOME PATH	sqlplus	Set to: <DatabasePath > Add: <DatabasePath >/bin
IBM DB2	DB2DIR DB2INSTANCE PATH	db2connect	Set to: <DatabasePath > Set to: <DB2InstanceName > Add: <DatabasePath >/bin
Sybase ASE	SYBASE15 SYBASE_ASE SYBASE_OCS PATH	isql	Set to: <DatabasePath >/sybase <version> Set to: ${SYBASE15}/ASE-<version> Set to: ${SYBASE15}/OCS-<version> Add: ${SYBASE_ASE}/bin:${SYBASE_OCS}/bin:$PATH