Data Encryption

Has anyone had any experience using data encryption tools that are part of the database layer? E.g. Oracle Transparent Data Encryption or other tools that are similar?

OriginalPostID-234436

  Discussion posts and replies are publicly visible

Parents
  • Hi Richard
    One way of achieving this is following:

    1. As a first step dump all your legacy data in the new system database.
    2. Have an utility process in place that will pull your data from the new system database (which you need to store them as encrypted) - this process will then encrypt your data using a!encryptedtext field component wrapped in a rule that will save your encrypted value in your inputs which you can then use them to store them in the database. (If you are on 16.2 you can use a!writetodatastore component directly to write the encrypted text to respective tables in database- else you would need to take the encrypted values in your utility process and then write to database).

    Ideally you can have one interface for every table you wa to write to make sure all your encryption are done.

    Hope this helps !
Reply
  • Hi Richard
    One way of achieving this is following:

    1. As a first step dump all your legacy data in the new system database.
    2. Have an utility process in place that will pull your data from the new system database (which you need to store them as encrypted) - this process will then encrypt your data using a!encryptedtext field component wrapped in a rule that will save your encrypted value in your inputs which you can then use them to store them in the database. (If you are on 16.2 you can use a!writetodatastore component directly to write the encrypted text to respective tables in database- else you would need to take the encrypted values in your utility process and then write to database).

    Ideally you can have one interface for every table you wa to write to make sure all your encryption are done.

    Hope this helps !
Children
No Data