Reading Encrypted Data

info_ds · Post by **info_ds** » Tue Nov 21, 2006 8:48 am

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

chulett · Post by **chulett** » Tue Nov 21, 2006 8:52 am

Encrypted how?

DSguru2B · Post by **DSguru2B** » Tue Nov 21, 2006 8:59 am

How was it encrypted? Is it using Oracle stored procedures or other utilities. It need to be decrypted the same way for you to read it. You need to find out how it was encrypted.

chulett · Post by **chulett** » Tue Nov 21, 2006 9:07 am

What he said.

info_ds · Post by **info_ds** » Tue Nov 21, 2006 9:07 am

Hi,
If I find the way it has been encrypted .Is it possible for me to read the data in any of the database stages of DS ?.If yes how can i do that in DS

Thanks in advance

DSguru2B · Post by **DSguru2B** » Tue Nov 21, 2006 9:45 am

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.

chulett · Post by **chulett** » Tue Nov 21, 2006 9:53 am

First, you need to find out how the data was encypted. Not sure how much plainer to make it. Any discussions on how to 'decrypt' it will be driven by that answer. Everything else is just table talk.

StageZilla · Post by **StageZilla** » Tue Nov 21, 2006 10:02 am

Are you sure its encrypted data? It may also mean that you are using the wrong NLS MAP if your data looks like that!
Or else you need to decrypt the data outside of DS in the converse way of encryption.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 21, 2006 11:57 am

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.