Skip to content

IBM InfoSphere DataStage: Configure SAP Sybase Open Clients to Use Sybase IQBulk Plugin

November 25, 2015

This post describes how to configure IBM InfoSphere DataStage Engine to use SAP Open Client to perform IQ bulk load.

Environment

  • IBM InfoSphere DataStage 11.3
  • IBM IAX 7.1
  • SAP Sybase SDK 15.7

Prerequisites

Download Sybase SDK 15.7 (valid license can be required).

Steps

  1. Install SAP Sybase SDK 15.7
  2. Define the following SYBASE variable in the $DSENGINE/dsenv file:

export SYBASE=\
export $SYBASE/SYBASE_OCS=OCS-15_0

  1. Define the variables for Sybase IQBulk Plugin

export PATH=$SYBASE_OCS/bin:$PATH
export LIBPATH=$SYBASE/$SYBASE_OCS/lib:$SYBASE/$SYBASE_OCS/lib3p:LIBPATH

Testing

  1. source $DSENGINE/dsenv
  2. execute ldd $ISHOME/Server/DSComponents/bin/iqbulk15.so (all the dependencies should resolve successful).
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: