DashDB Cloud ODBC Configuration

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gsbrown
Premium Member
Premium Member
Posts: 148
Joined: Mon Sep 23, 2002 1:00 pm
Location: USA

DashDB Cloud ODBC Configuration

Post by gsbrown »

Looking for someone who can show me through personal experience how they configured DataStage 9.1 to connect to a Cloud DashDB instance? I'm following their documentation but having issues or some things aren't specifically clear. For example, I've got the DashDB Linux driver installed, but there are no instructions for odbc.ini setup. Would appreciate learning what others have done, thank you!
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

If it's a cloud based DashDB the documentation suggests connecting via a JDBC Connector, just use the DataStage on Cloud instructions as it should work in your environment: https://www.ibm.com/support/knowledgece ... ashDB.html

If it's a local DashDB try the DB2 Connector or ODBC Connector and set it up as a DB2 database as DashDB is supposed to support all recent DB2 drivers.
gsbrown
Premium Member
Premium Member
Posts: 148
Joined: Mon Sep 23, 2002 1:00 pm
Location: USA

Post by gsbrown »

Nice! The JDBC option works for us and we're on SUSE Linux 11 w/ IIS 9.1
I'll leave some notes here in case it helps anyone else searching on this.

1. Installed the IBM DasbDB driver connection software found within the "Downloads" section from the IBM DashDB Cloud Bluemix page
(ie. ibm_data_server_driver_package_linuxx64_v11.1.tar)

2. Create file "$DSHOME/DSEngine/isjdbc.config" with these lines. CLASSPATH will be wherever you installed drivers. CLASS_NAMES I'm assuming is the same for everybody.

Code: Select all

CLASSPATH=/opt/downloads/dsdriver/java/db2jcc4.jar
CLASS_NAMES=com.ibm.db2.jcc.DB2Driver
3. In a DataStage job, the JDBC connector URL should look like this using your own <hostname>, <port>, <databasename> found on the "Connect" tab of your IBM DasbDB Cloud Bluemix page.

Code: Select all

jdbc:db2://<hostname>:<port>/<databasename>
Post Reply