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



Joined: 16 Aug 2007
Posts: 428
Location: Manali
Points: 4205

Post Posted: Mon May 18, 2015 8:57 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Additional info: Data profiling on source systems with advanced security
Hi Experts,

I would like to ask one question regarding information analyzer.

Can we use Information Analyzer 9.1.2 to do data profiling on oracle source databases that have Advanced Security/encryption applied to them?

If yes, do we need to do any configuration on information server(AIX) to do this?

Kindly let me know. Thank you.

_________________
Arvind
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54519
Location: Sydney, Australia
Points: 295643

Post Posted: Tue May 19, 2015 2:17 am Reply with quote    Back to top    

Theoretically, Information Analyzer works just like any other Oracle client - you have to have the appropriate roles and, if you do, then you can effect queries against the tables. It's that simple. ...

_________________
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
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2859
Location: USA
Points: 21745

Post Posted: Tue May 19, 2015 8:56 am Reply with quote    Back to top    

We have used DataStage and IA against Oracle with the advanced security, where we require network traffic from Oracle clients to be encrypted. In this scenario, the Oracle client can be configured to support encryption, whereas the bundled ODBC drivers do not support the encryption. Perhaps a newer ODBC driver does or will support it. It just means you must use the Oracle Connector stage and Oracle client connection instead of ODBC, which is better anyway.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
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