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.
How to connect Azure DB from DataStage 9.1
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.