Oracle Cloud Infrastructure Documentation

Create a Data Discovery Job

The Data Discovery wizard generates a sensitive data model (SDM) when you run a data discovery job. You can perform incremental updates to your sensitive data model while you are creating it in the wizard and after you save it to the Library.

To create a data discovery job by using the Data Discovery wizard:
  1. To launch the Data Discovery wizard, click the Home tab, and then click Data Discovery.
  2. (Optional) If you haven't granted the Data Discovery role on your target database, do the following:
    1. If your target database is a DB system, click Download Privilege Script, download the dscs_privileges.sql script to your local computer, and then run the script on your target database.
    2. If your target database is an Autonomous Database, run the DS_TARGET_UTIL PL/SQL package on your Autonomous Database.
  3. Select a target database, and click Continue.
    If your target database is not listed, click Register and register your target database.
  4. On the Select Sensitive Data Model page, do the following:
    1. Select Create.
    2. Enter a name for your sensitive data model or leave the default name provided by Data Discovery.
    3. Choose whether to collect sample data from the target database and show the samples along with the discovery result.
    4. Select the resource group to which you want the sensitive data model to belong. If needed, you can create a resource group from here.
    5. Click Continue.
  5. On the Select Schemas for Sensitive Data Discovery page, select the schemas that you want Data Discovery to search, and click Continue.
    To select all the schemas at once, select the check box to the left of the Schema Name column title.
  6. (Optional) Move the Expand All slider to the right to view all categories and sensitive types. You can also expand individual check boxes.
  7. Select the categories of sensitive types and/or the individual sensitive types that you want to use to discover sensitive data.
  8. (Optional) Create a sensitive type:
    1. Click Add.
    2. Fill out the Create Sensitive Type dialog box.
    3. Click Save
  9. (Optional) Select the Use non-dictionary referential relationships for sensitive column discovery check box.
  10. When you are ready to start the data discovery job, click Continue.
    • If you need to temporarily stop the data discovery job, click Suspend. Click Resume to continue.
    • If you need to terminate the data discovery job, click Abort.
    When the job is completed successfully, a status of FINISHED is displayed.
  11. Click Continue.
  12. If you enabled the "non-dictionary referential relationships" option, review the sensitive columns discovered with this option, deselect the columns that you do not want to include in your sensitive data model, and click Continue.
  13. On the Sensitive Data Discovery Result page, finalize the sensitive data model (SDM) by doing the following:
    1. Expand all of the results by moving the slider or by expanding certain nodes.
    2. (Optional) Select Schema View to sort the results by schema and table name.
    3. Review the sensitive columns and statistics (number of sensitive columns, estimated data counts, and sample data if you chose to collect sample data).
      If a sensitive column does not have a check box, it means that it has a referential relationship to a discovered sensitive column.
    4. Deselect any sensitive columns that you do not want to include in your SDM.
    5. (Optional) Click Add to add new sensitive columns. In the dialog box, select one or more columns from the schemas, select a sensitive type that describes the selected columns, and click Add to Result.
    6. (Optional) Click Back, modify the selection of sensitive types, and rerun the data discovery job. Review the generated SDM again. Repeat until you feel the SDM is accurate and complete.
  14. To view the Sensitive Data Discovery report for the SDM, click Report; otherwise, click Exit.
  15. (Optional) If you want to mask the sensitive data using the SDM, perform the following steps:
    1. Click Continue to mask the data.
      The Select Target for Data Masking page is displayed.
    2. Select the target database that you want to mask, and click Continue.
      The Masking Policy page is displayed.
    3. Create a masking policy.

      See Also:

      Part 4 in the Create a Data Masking Job topic.