Post reply

Using DES3

  • April 3, 2015 at 1:51 pm

    #302729

    How do I tell SQL Server what key to use for DES3 decryption? I want to encrypt in Oracle and after ETL to SQL Server, be able to decrypt but keep a column's value encrypted in Oracle, SSIS and SQL side - only decrypting on the SQL Server side when needing to use the value.

    Thanks for any info -

  • April 4, 2015 at 10:32 am

    #1788746

    Michael Gerholdt (4/3/2015)

    How do I tell SQL Server what key to use for DES3 decryption? I want to encrypt in Oracle and after ETL to SQL Server, be able to decrypt but keep a column's value encrypted in Oracle, SSIS and SQL side - only decrypting on the SQL Server side when needing to use the value.

    Thanks for any info -

    Quick thought, on Enterprise Edition this can be done using the Extendible Key Management which supports externally created keys, on other editions you would have to use an third party key manager which supports your edition of SQL Server.

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply