3 Replies Latest reply: Nov 19, 2012 11:50 AM by 571747 RSS

    Masking Data in ODI


      Is there way to mask the data in ODI the developers can see from a given table? My client is worried that once ODI is granted access to a given table anyone would be able to access that table. The table houses unmasked sensitive data that they don't want people to see. Has anyone had to deal with something like this in the past? Could this be handled with security?


      Edited by: user568744 on Nov 19, 2012 8:04 AM
        • 1. Re: Masking Data in ODI
          you can think creating views/materialized views to mask your sensitive columns..in a table..
          • 2. Re: Masking Data in ODI
            The developer would only be able to see data in tables from a development work repository. Ideally, the data within a development environment would be scrubbed of any personal/confidential data, or, better still, be test-generated data which isn't confidential at all.

            In testing/production environments (containing sensitive information) you can utilise execution-only work repositories which only present the user with information relating to the execution of ODI components.
            • 3. Re: Masking Data in ODI

              Thanks for the quick responses....

              I told my client earlier today that data in their dev environments should be scrubbed as part of their post refresh process.

              I'm new to ODI so the Execution-Only work repositories are new to me. :) I will need to read a bit more about it but I should be able to ease their minds a bit.