Skip to content

IBM InfoSphere DataStage: Configure ODBC Access to SAP IQ 16.0

January 5, 2016

This post explains how to configure the bundle DataDirect IQ ODBC driver to connect to SAP IQ 16 data sources.

Environment

  • IBM InfoSphere DataStage 11.5
  • IBM IAX 7.1
  • SAP IQ 16.0 SP08

How to Configure

  1. Go to the directory $DSHOME.
  2. Optional: Make a backup if the .odbc.ini
  3. Edit the .odbc.ini file as follow:

    3.1 On the section [ODBC Data Sources] add:

    MySAPIqDb=DataDirect Sybase IQ Wire Protocol
    

    3.2 Create a new Data Source entry as follow:

    [MySAPIqDb]
    Driver=/datastage/IBM/InformationServer/Server/branded_odbc/lib/VMsyiq00.so
    Description=DataDirect Sybase IQ Wire Protocol Driver
    ApplicationUsingThreads=1
    ArraySize=50
    CursorCacheSize=1
    Database= MySAPIQDb   # replace by the name of your database
    DefaultLongDataBuffLen=1024
    EnableDescribeParam=0
    EnableQuotedIdentifiers=0
    MaxPoolSize=100
    MinPoolSize=0
    NetworkAddress=MySQOIQServer,2638  # replace by your server,port
    OptimizePrepare=1
    PacketSize=0
    RaiseErrorPositionBehavior=0
    
  4. Add the new DS to teh uvodbc.config file on $DSHOME (and/or in every project directory).
    DBMSTYPE = ODBC
    

How to Test

See IBM InfoSphere DataStage: Test OBDC Connectivity

References

IBM Knowledge Center. Specifying data source names in the uvodbc.config file. Retrieved from https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.productization.iisinfsv.install.doc/topics/wsisinst_uvodbc_config_File.html

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: