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
Ayan_BK
Participant



Joined: 15 Aug 2018
Posts: 4

Points: 58

Post Posted: Wed Aug 15, 2018 8:20 am Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42985
Location: Denver, CO
Points: 221730

Post Posted: Wed Aug 15, 2018 11:42 am Reply with quote    Back to top    

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

_________________
-craig

Help I'm steppin' into the twilight zone, place is a madhouse, feels like being cold
My beacon's been moved under moon and star, where am I to go now that I've gone too far?
Rate this response:  
Not yet rated
Ayan_BK
Participant



Joined: 15 Aug 2018
Posts: 4

Points: 58

Post Posted: Wed Aug 15, 2018 10:48 pm Reply with quote    Back to top    

So do you have any suggestion of the problem?
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42985
Location: Denver, CO
Points: 221730

Post Posted: Thu Aug 16, 2018 6:23 am Reply with quote    Back to top    

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

Help I'm steppin' into the twilight zone, place is a madhouse, feels like being cold
My beacon's been moved under moon and star, where am I to go now that I've gone too far?
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54524
Location: Sydney, Australia
Points: 295662

Post Posted: Thu Aug 16, 2018 9:40 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Ayan_BK
Participant



Joined: 15 Aug 2018
Posts: 4

Points: 58

Post Posted: Tue Aug 21, 2018 10:48 pm Reply with quote    Back to top    

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.
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