Data Encryption

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 !

Hi Richard,
Please ignore my above comment. This was intended for one of your other post.
Apologies!

Thanks !

Thanks for the response!

Even though this thread was mean to be about underlying database encryption, the two issues are related. I'm concerned that this approach might be slow if I had a lot of rows in my legacy data.