DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
ASU_ETL_DEV



Group memberships:
Premium Members

Joined: 09 Sep 2008
Posts: 41

Points: 400

Post Posted: Fri Jan 05, 2018 3:01 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Single engine/service; xmeta on Oracle 12c RAC
Hello,
We need to code a set of parallel jobs that connect to a SQL Server source database that has encryption turned on. They gave us CA-signed certificates to install on the DataStage server and client.

We have never configured an encrypted SQL Server connection so we need a bit of step-by-step help.

We know that there are several ODBC wire driver security options that can be configured in odbc.ini, to point to the trust store.
We know that WebSphere has a trust and key store but we do not know whether that is the correct place where to import the certificates or whether an ad hoc trust store needs to be created (and how).

Any insight is greatly appreciated.
Marco

_________________
ASU Developer
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2681
Location: USA
Points: 19904

Post Posted: Mon Jan 08, 2018 10:19 am Reply with quote    Back to top    

I have not done this either but I gather from the documentation that it is supported. I kind of doubt that WebSphere would need to come into play. For step by step instructions, assuming you searched and came up empty, then I would suggest opening a case to work with DataStage Support on this. They probably know how but if they don't then they will contact Progress/DataDirect to get the instructions.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
ASU_ETL_DEV



Group memberships:
Premium Members

Joined: 09 Sep 2008
Posts: 41

Points: 400

Post Posted: Mon Jan 08, 2018 10:41 am Reply with quote    Back to top    

Thanks qt_ky,
We opened a case with IBM Support. They pointed us to the odbc manuals in /branded_odbc but the driver security options' configuration is just one part of the story.
We are waiting for them to explain how to handle the certificates on the Linux server.
Marco

_________________
ASU Developer
Rate this response:  
Not yet rated
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 402
Location: New York City
Points: 4422

Post Posted: Thu Jan 11, 2018 6:43 am Reply with quote    Back to top    

Try the instructions in below link

http://www-01.ibm.com/support/docview.wss?uid=swg21676239

_________________
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
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