How to connect Azure DB from DataStage 9.1

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Ayan_BK
Participant
Posts: 4
Joined: Wed Aug 15, 2018 7:41 am

How to connect Azure DB from DataStage 9.1

Post by Ayan_BK »

Hi Guys,

Can anyone guide me on how can we connect Azure DB from DataStage 9.1 version.

I have tried to create a JDBC connection and I have added the below class name and class path:

CLASSPATH=/opt/IBM/InformationServer/ASBNode/lib/java/ISsqlserver.jar
CLASS_NAMES=com.ibm.isf.jdbc.sqlserver.SQLServerDriver;

I am using the below JDBC URL for connecting:

jdbc:ibm:sqlserver://SERVER:PORT;database=DATABASE_NAME;user=USER@SERVER;EncryptionMethod=SSL;ValidateServerCertificate=true;CryptoProtocolVersion=TLSv1.2;

But ultimately the connection is failing with the following error:
----------------------------------------
Can not open server "Server Ip" requested by the login. The login failed.


Then I have tried to set up JDBC connection using JDBC 6.4 jar file. But getting below error:
----------------------------------
jvmcfre003 bad major version; class=com/microsoft/sqlserver/jdbc/sqlserverdriver, offset=6

Did anyone established the connection to Azure DB from DataStage 9.1? Please advise.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No need to post it again, I moved it here to this forum.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Ayan_BK
Participant
Posts: 4
Joined: Wed Aug 15, 2018 7:41 am

Post by Ayan_BK »

So do you have any suggestion of the problem?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sorry, if I did I would have done so when I moved it. While we wait to see if anyone has anything to add, have you contacted your official support provider for help?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Have you confirmed that the host name of the server can be resolved to an IP address?

Also I have a vague recollection that TLS v1.2 is not supported.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ayan_BK
Participant
Posts: 4
Joined: Wed Aug 15, 2018 7:41 am

Post by Ayan_BK »

Everyone,

Finally got the solution to connect Azure DB from DataStage 9.1.

You can not setup JDBC connection because DataStage 9.1 runs on Java version 6 but to set up a connectivity to Azure DB, you need Java 7 or higher. Unfortunately DataStage 9.1 will not support Java 7 or higher.

Now coming to ODBC setup. ODBC configuration actually solved the problem.

you will have to use below driver to setup the connection:

/opt/IBM/InformationServer/Server/branded_odbc/lib/VMsqls00.so

Set EncryptionMethod=1.

set ValidateServerCertificate=1, if you set the value as 1 then you will have to configure the trust store. if you need to validate the host certificate, you will need to create a Trust Store to store the host cert, and specify its location/password in the .odbc.ini.

Thank You.
Post Reply