Skip to content

IBM InfoSphere: Configure ODBC Access to MS SQL 2008

January 6, 2016

This post explains how to configure the bundle DataDirect IQ ODBC driver to connect to Microsoft SQL Server 2008 data sources.

Environment

  • IBM InfoSphere DataStage 11.5
  • IBM IAX 7.1
  • MS SQL 2008

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:

    MyMSSQLDb=DataDirect SQL Server Wire Protocol Driver
    

    3.2 Create a new Data Source entry as follow:

    [MyMSSQLDb]
    Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss00.so
    Description=DataDirect SQL Server Wire Protocol driver
    Database=MyMSSQLDb
    Address=myServer,1433
    QuotedId=No
    AnsiNPW=No
    
  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

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: