Masking data in a relational database

You can use Optim™ Designer to define a data privacy policy to mask sensitive relational data.

To mask data in a relational database:
  1. Define a data source connection to a relational database, as described in Defining a database connection.
  2. Define a physical data model based on reverse engineering from a database, as described in Physical data models based on reverse engineering.
  3. Define an Optim logical data model, as described in Transforming a physical data model to an Optim logical data model.
  4. Define a data access plan, as described in Using data access plans.
  5. Define a selection policy, as described in Working with a selection policy.
  6. Define a privacy policy, as described in Using data privacy policies.

    After you define a privacy policy, you can mask data by using the Optim logical data model with a data management service.