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. From the navigation pane, go to Data Insights.

    The Data Insights page appears.

  2. Under Risk Analysis, click Sensitive data governance.

    The Sensitive data governance page appears.

  3. Under Quick start, click Database.

    The Quick start page appears.

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

  5. Click Next.

    The Add database page appears.

  6. On the Select database tab, select the check box next to the database server you want to add.

    Tip

    If you do not see the server that you want to analyze, in the upper-right corner of the page, click Synchronize or Refresh inventory.

  7. Click Next.

  8. In Display name, enter a name for the server.

  9. From the Country name list, select the country where the server is located.

  10. From the Instance list, select the database instance.

  11. If you are using a proxy, from the Proxy client list, select the proxy.

  12. 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 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.

Creating a Data Classification Plan

Loading...