DSXchange

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.

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

So do you have any suggestion of the problem?

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?

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.

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.