Load encripted data in a cube

[Former Member]

Hi,

I have an oracle database source with a field encripted with DBMS-CRYPTO.DES

I need to move this data to a cube. The data have to remain encrypted and IT people cannot see this data.

However, I don't know how to do it.

One possibility is move the data encrypted to the cube. The problem is that the source DB is Oracle and our BIW system is SQL Server. So, I cannot just move the data because SQL Server will not be able to decrypt in the future. As far as I have seen.

Another possibilty is to decrypt the data from Oracle and encrypt again in the cube. However, I don't know if SAPBIW can do that hidding the encryption key to decrypt the Oracle data.

Do you have any solution?

Kind regards,

Kim

[Former Member]

the only solution I have found is to move data from Oracle to SQL Server, decrypt and then encrypt again. It's neither easy, nei