Hi All,
I just want to read encrypted data from a table using oracle stage ,but i am not able to do that.Can anyone tell me how to do that in datastage? or Is it possible to read an encrypted data from the table using any of the stages?
Comments appreciated
Reading Encrypted Data
Moderators: chulett, rschirm, roy
Well Yes and No. You will have to run that stored proc./utility and capture the output and read it.
I am not exactly sure how its done in Oracle. I have heard that oracle uses some stored procs. do get this done. So you are looking at STP stage and outstreaming it to a file.
I know in sql server 2005 they use EncryptByKey() function or the DecryptByKey() function to encrypt or to decrypt data in the column that contains the sensitive data. Try talking to your DBA. Maybe he will be able to direct you in the right direction. You can even google your quest. Let us know what you find.
How is this for a start.
I am not exactly sure how its done in Oracle. I have heard that oracle uses some stored procs. do get this done. So you are looking at STP stage and outstreaming it to a file.
I know in sql server 2005 they use EncryptByKey() function or the DecryptByKey() function to encrypt or to decrypt data in the column that contains the sensitive data. Try talking to your DBA. Maybe he will be able to direct you in the right direction. You can even google your quest. Let us know what you find.
How is this for a start.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 15
- Joined: Tue Nov 21, 2006 3:45 am
- Location: WhiteField, Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage is not a codebreaker. It can only do what any other database client can do - issue SQL that includes appropriate SQL functions for performing particular tasks, and receive the results of such SQL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.