Please be more specific about that. Where and how do you want to do the encryption? On DBMS side using an UDF (something like Select encrypt(c) From T), or on client side? How do you want to do the decryption?
Regards,
Ralf
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for the prompt response and sorry to be more generic.
Actually I want to mask the data as I am creating a test data bed and I cannot export sensitive data from the live database. For eg: Social Security Number is one column in the Customer table - I want to encode/encrypt/mask this column. There is no need to decode/decrypt this data.
Regards
Kamlesh
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I also think that a data filtering feature would be a valuable add-on, so that the user can do data anonymization, or other things like test data aging, for example.
There is currently no direct support for these kind of things. I've opened a feature request ticket. But you can try the following:
- create a UDF that does the masking.
- create a view that applies the UDF:
"create view T_MASKED as Select c1, c2, mask(SSN) as SSN, ... From T"
- open the data model editor and rename table "T" as "T_MASKED".
Jailer will then use the view to read the rows instead of the table.
Alternatively you can import the un-masked data into an empty database, do the masking there and export the data again.
Regards,
Ralf
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
In one of the cases while I export data from a database I want to encrypt data for some of the fields in the database.
Has anybody tried doing this and what are the issues that they have faced?
Hi,
Please be more specific about that. Where and how do you want to do the encryption? On DBMS side using an UDF (something like Select encrypt(c) From T), or on client side? How do you want to do the decryption?
Regards,
Ralf
Hello Ralf
Thanks for the prompt response and sorry to be more generic.
Actually I want to mask the data as I am creating a test data bed and I cannot export sensitive data from the live database. For eg: Social Security Number is one column in the Customer table - I want to encode/encrypt/mask this column. There is no need to decode/decrypt this data.
Regards
Kamlesh
Hi Kamlesh,
I also think that a data filtering feature would be a valuable add-on, so that the user can do data anonymization, or other things like test data aging, for example.
There is currently no direct support for these kind of things. I've opened a feature request ticket. But you can try the following:
- create a UDF that does the masking.
- create a view that applies the UDF:
"create view T_MASKED as Select c1, c2, mask(SSN) as SSN, ... From T"
- open the data model editor and rename table "T" as "T_MASKED".
Jailer will then use the view to read the rows instead of the table.
Alternatively you can import the un-masked data into an empty database, do the masking there and export the data again.
Regards,
Ralf
Hi Kamlesh,
the data filtering feature has been implemented in release 2.9.0.
Regards,
Ralf