Encryption

srimitta · Post by **srimitta** » Wed May 30, 2007 5:49 pm

Hi All,

Anybody have any idea whether we can use DS 7.5.1a Oracle plug-in's to load encrypted data into Oracle 10G r2 database tables.

we are looking at field level encryption (feild data types are of Numeric and decimal).

Thanks
srimitta

chulett · Post by **chulett** » Wed May 30, 2007 6:28 pm

The data is coming to you 'encrypted' or do you need to perform the encryption during the load? If you don't need to do the encryption or any kind of decryption during the processing, I don't see why it couldn't be treated like any other 'data' - simply stored and retrieved from the database.

Would need more specifics to give a more coherent answer.

srimitta · Post by **srimitta** » Thu May 31, 2007 1:45 pm

Sorry for delay response.

1). We are validating decripted data in DS and after validation again we are encrypting and loading data.

2). We are just loading encrypted data from source.

Here what I am trying to know is whether DS Oracle plug-in's allow encrypted data into Number and Decimal data type feilds.

Thanks
srimitta

chulett · Post by **chulett** » Thu May 31, 2007 1:59 pm

I don't believe that would be a 'DS Oracle plug-in' thing, but a general Oracle question - does Oracle allow it. I don't think so but have never had any reason to encrypt anything other than string data.

Have you talked to your DBA?

srimitta · Post by **srimitta** » Thu May 31, 2007 3:29 pm

I checked with DBA, encrypted data is going into those feilds with varchar2 data types.

And varchar2 is srting data type we shouldn't have a problem :D .

Hey Thanks.
srimitta