PostgreSQL Connector

Overview

Used for OneTrust Data Discovery, the PostgreSQL connector connects to PostgreSQL databases and can be used to scan file system information directly from SQL systems.

Pod Residency

rdbms-scanner

Connection Method

JDBC URL

Supported Scan Actions

Scan Type

Description

Catalog

Only the meta data in the database like details of schema, table, or column are scanned.

Catalog & Scan

Scans both metadata and data under the tables and returns the appropriate labels.

Credentials and System Permissions

OneTrust recommends to adhere to your organization's security and infrastructure policy and include system engineer resources or other qualified subject matter experts to set up credentials on data sources. For specific instructions for how to enable these credentials, refer to your data source's implementation documentation, knowledge base and/or support resources.

  • Requires PostgreSQL Native User Authentication

  • User requires read-only access to databases which are scanned.

Sample JSON

JSON 
{
    "connectionUrl": "jdbc:postgresql://<HOST>:<PORT>/<DB_NAME>",	
    "user": "your_user",	
    "password": "your_password"
}

Entra ID JSON

JSON 
{
    "connectionUrl": "jdbc:postgresql://<Host>:<Port>/<DB_NAME>?user=<ENTRA ID>&password=<Access-Token>",
    ... // other postgres properties
}

Scan Profile Support

Note:

For additional details on scan profile configuration and management, see Setting Up Scan Profiles.

Limits

  1. Limit number of schemas per database

  2. Limit number of tables per schema

  3. Limit number of rows per table

Wildcard

Wildcards are not supported for column inclusion or exclusion.

  • Example: *Name* will not work to include/exclude both firstName and lastName columns

  • Instead, you must specify the exact column names separated by commas (e.g. firstName,lastName).

Important:

Columns Excluded in the Data Dictionary

When a column is excluded, it is still cataloged by the Data Dictionary. This means:

  • Basic metadata for the column is retrieved.

  • During extraction, the actual column content is skipped based on the configuration.

Include/Exclude Path Configuration Fields

  • Schema

  • Table

  • Column

Collected Objects & Fields

Objects

Fields

Databases

  • Name

  • Filed Type (Columns)

  • Owner

  • Product Version

  • Product Name

  • Product Family

Tables

  • Name

  • Comment

Columns

  • Name

  • Column Index (Order)

  • Comment

  • Nullable (T/F)

  • Size Estimate

  • Comment

Keys

  • Primary Key Name

  • Primary Key Columns

  • Foreign Key Name

  • Foreign Key Columns