Loading...

Adding Database Data Sources to a Project

Applies To: Microsoft SQL Server and Oracle

You can add database data sources to a project. After a data source is crawled, the personally identifiable information (PII) (entities) defined in the data classification plan associated with the project is discovered in the data source.

Important: The first 50 non-null rows in a column are crawled and analyzed. When you review the PII found in a database data source, it is representative of the types of PII in the database. It is not an exhaustive list of all PII in the database.

Before You Begin

  • A database agent must be installed.

    Note: To use an Oracle database as a data source, the credentials that you use to access the server must be a user name and password. OS authentication (/) is not supported.

  • The Data Analysis Toolkit package must be installed on each database client or on the proxy.

    Note: If you use Oracle wallets, the Data Analysis Toolkit package must be installed on each database client.

  • Gather the following information:
    • The country where the server is located
    • The name of the database instance
    • If you are using a proxy, the name of the proxy client. The proxy client must have the Data Analysis Toolkit package installed.

Procedure

  1. Open Sensitive data analysis as follows:
    1. From the navigation pane, expand Solutions, and then click Activate.

      The Activate page appears.

    2. Under Apps, click Sensitive data analysis.

      The Sensitive data analysis page appears.

  2. Under Quick start, click Database.

    The Quick start page appears.

  3. On the Project tab, under Select project, from the Project list, select a project.
  4. Click Next.

    The Add database page appears.

  5. In the Select database step, select the check box next to the database you want to add.

    Tip: To refine the list, you can perform the following actions:

    • Select one or more facets to the left of the list.
    • Perform a keyword search.
    • Control pagination with the controls at the bottom of the table.
  6. Click Next.
  7. In Display name, enter a name for the server.
  8. From the Country name list, select the country where the server is located.
  9. From the Instance list, select the database instance.
  10. If you are using a proxy, from the Proxy client list, select the proxy.
  11. Click Save.

    The database appears in the Data sources table, and a data collection job runs to crawl and to analyze the data in the data source.

What to Do Next

After creating a project and defining data sources, you can create requests to manage user requests to export or to delete data that contains personally identifiable information (PII). For more information, see Adding a Request in Request Manager.

Tip: After you add the data source to the project, a data collection job runs to crawl and to analyze the data in the data source. If at a later time you want to update the data collected from the data source, you can run a data collection job from the data source details page. For more information, see Collecting Data from Data Sources.

Related Topics

Creating Data Classification Plans

Last modified: 1/22/2019 5:15:57 PM