topic Load encripted data in a cube in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/load-encripted-data-in-a-cube/m-p/7357203#M1541508 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an oracle database source with a field encripted with DBMS-CRYPTO.DES</P><P>I need to move this data to a cube. The data have to remain encrypted and IT people cannot see this data.</P><P></P><P>However, I don't know how to do it.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Do you have any solution?</P><P></P><P>Kind regards,</P><P>Kim</P></BODY></HTML> Fri, 15 Oct 2010 13:35:38 GMT Former Member 2010-10-15T13:35:38Z Load encripted data in a cube https://community.sap.com/t5/application-development-and-automation-discussions/load-encripted-data-in-a-cube/m-p/7357203#M1541508 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an oracle database source with a field encripted with DBMS-CRYPTO.DES</P><P>I need to move this data to a cube. The data have to remain encrypted and IT people cannot see this data.</P><P></P><P>However, I don't know how to do it.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Do you have any solution?</P><P></P><P>Kind regards,</P><P>Kim</P></BODY></HTML> Fri, 15 Oct 2010 13:35:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/load-encripted-data-in-a-cube/m-p/7357203#M1541508 Former Member 2010-10-15T13:35:38Z Re: Load encripted data in a cube https://community.sap.com/t5/application-development-and-automation-discussions/load-encripted-data-in-a-cube/m-p/7357204#M1541509 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Thu, 25 Nov 2010 09:49:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/load-encripted-data-in-a-cube/m-p/7357204#M1541509 Former Member 2010-11-25T09:49:54Z