PostgreSQL Integration Requirements
The following are the prerequisites necessary for IBM Automatic Data Lineage to connect to this third-party system, which you may choose to do at your sole discretion. Note that while these are usually sufficient to connect to this third-party system, we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including for their performance.
-
PostgreSQL: version 8.2 or newer (remote)
-
Greenplum: version 4.3 or newer (remote)
-
User having the following rights for each extracted database:
- CONNECT — to connect to the database
-
SELECT on the following tables and views in
pg_catalog
(usually granted implicitly through the Public role):-
pg_database
-
pg_namespace
-
pg_class
-
pg_attribute
-
pg_type
-
pg_proc
-
pg_language
-
pg_description
-
pg_constraint (PostgreSQL only)
-
pg_shdescription (PostgreSQL and Greenplum only)
-
svv_external_schemas (Redshift only)
-
svv_external_tables (Redshift only)
-
svv_external_columns (Redshift only)
-
- USAGE on all analyzed external schemas (Redshift only)
-
Connection parameters:
- Name or IP address of the database
- Port on which the database listens for JDBC connections
- User name
- User password or authentication token if an Amazon RDS or Amazon Aurora for PostgreSQL “Password and IAM database authentication” authentication type is used
-
Database must be accessible via network
-
Amazon RDS or Amazon Aurora for PostgreSQL database authentication type:
-
Password authentication
-
Password and IAM database authentication
-
-
AWS JDBC Driver for PostgreSQL
- The Manta Flow distribution does not contain an AWS JDBC driver that works with the Amazon Aurora for PostgreSQL database. Please download the most recent compatible version of the JDBC driver from the AWS JDBC Driver for PostgreSQL website
(
https://awslabs.github.io/aws-postgresql-jdbc/), and place the new driver file
aws-postgresql-jdbc-<version>.jar
in thecli/scenarios/manta-dataflow-cli/lib-ext
directory.
- The Manta Flow distribution does not contain an AWS JDBC driver that works with the Amazon Aurora for PostgreSQL database. Please download the most recent compatible version of the JDBC driver from the AWS JDBC Driver for PostgreSQL website
(
https://awslabs.github.io/aws-postgresql-jdbc/), and place the new driver file
Known Unsupported Features
Automatic Data Lineage does not support the following PostgreSQL features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.
-
Lineage through dynamically executed code through EXECUTE IMMEDIATE
-
EDB: Code obfuscated via EDB*Wrap utility (see https://www.enterprisedb.com/docs/epas/latest/epas_security_guide/03_edb_wrap/obfuscating_source_code for more details). Users can still pass unobfuscated code as manual input (PostgreSQL Manual Inputs) for lineage analysis