Mechanism to encrypt data while extraction

2009-01-22
2012-12-07
  • 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?

     
    • Ralf Wisser
      Ralf Wisser
      2009-01-22

      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

       
    • Ralf Wisser
      Ralf Wisser
      2009-01-23

      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

       
    • Ralf Wisser
      Ralf Wisser
      2009-03-03

      Hi Kamlesh,

      the data filtering feature has been implemented in release 2.9.0.

      Regards,
      Ralf

       


Anonymous


Cancel   Add attachments