API/Python/Open-Source Solutions

Expand all | Collapse all

Agile data masking to the encrypted Oracle database

Jump to Best Answer
  • 1.  Agile data masking to the encrypted Oracle database

    Posted 01-21-2015 03:01:00 AM
    How to mask the encrypted Oracle database with Agile data masking ?
    The encrypted database might be decrypted before masking...


    #Tip


  • 2.  RE: Agile data masking to the encrypted Oracle database

    Posted 01-21-2015 04:53:00 PM
    Heungjae that is a great question! I'm reaching out to our developers to get an answer for you!


  • 3.  RE: Agile data masking to the encrypted Oracle database

    Posted 01-22-2015 01:22:00 PM
    Heungjae,

    Masking is accomplished through an Extract-Transform-Load process. We read from the table(s) to be masked, modify the data in memory on the masking engine, and then update the data in the database. Thus, the data at rest is not decrypted. We use the same methods to access the data as any application would, specifically SQL over a JDBC connection.

    Thank you for your question,

    Michael


  • 4.  RE: Agile data masking to the encrypted Oracle database

    Posted 01-22-2015 11:28:00 PM
    Thanks, How to interface when using the column level encryption API not TDE ?


  • 5.  RE: Agile data masking to the encrypted Oracle database

    Posted 01-28-2015 05:16:00 AM
    Masking the encrypted database would be depend on how the encryption is applied.
    Need more kindly answer.


  • 6.  RE: Agile data masking to the encrypted Oracle database

    Posted 01-30-2015 06:31:00 PM
    Hi Heungjae, can you you send a link to the "Column Level Encryption API" you are referring to? As Michael said, masking works at the user level. As long as the user you supply has permissions to read and write to the column, it will work.


  • 7.  RE: Agile data masking to the encrypted Oracle database

    Posted 02-03-2015 08:45:00 AM
    Hello, DBMS_CRYTPO is sample encrypttion API in Oracle http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_crypto.htm#i1004146


  • 8.  RE: Agile data masking to the encrypted Oracle database
    Best Answer

    Posted 02-10-2015 04:39:00 AM
    The use of DBMS_CRYPTO is managed by the application, so it's not something that Agile Masking can handle out of the box. Depending on how it's used, Agile Masking could potentially be customized to handle data encrypted by DBMS_CRYPTO.

    TDE works because the encryption/decryption process is transparent to the application/user.