DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
gsbrown



Group memberships:
Premium Members

Joined: 23 Sep 2002
Posts: 127
Location: USA
Points: 1615

Post Posted: Thu Feb 16, 2017 8:59 am Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Additional info: How to connect DataStage to Cloud DashDB instance?
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

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3553
Location: Australia, Melbourne
Points: 27593

Post Posted: Tue Feb 21, 2017 9:51 pm Reply with quote    Back to top    

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/knowledgecenter/en/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.cloud.doc/topics/t_connecting_ds_cloud_to_dashDB.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.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
Rate this response:  
Not yet rated
gsbrown



Group memberships:
Premium Members

Joined: 23 Sep 2002
Posts: 127
Location: USA
Points: 1615

Post Posted: Wed Feb 22, 2017 8:48 am Reply with quote    Back to top    

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:
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:
jdbc:db2://<hostname>:<port>/<databasename>
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours