Skip to content

IBM InfoSphere DataStage: Connect to Oracle Data Sources Using Oracle InstanClient

January 25, 2016

This post explains how to configure IBM InfoSphere DataStage to connect to Oracle data sources using Oracle instanClient.

Environment

  • IBM IAX 7.1
  • Oracle instanClient 11.2.0.4.0
  • IBM InfoSphere DataStage 11.5

Prerequisites

Install and Configure Oracle InstanClient 11.2 on AIX

Procedure

  1. Add or modify the following environment variable in the dsenv file
    export ORACLE_HOME=//instantclient_11_2
    export TNS_ADMIN=$ORACLE_HOME
    export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
    
  2. Restart the DataStage engine and agents.

Useful Resource

IBM Knowledge Center, IBM InfoSphere Information Server, Setting the library path environment variable in the dsenv file

Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: