PostgreSQL Manual Inputs

PostgreSQL, Greenplum, Redshift, Yellowbrick, Amazon RDS, or Amazon Aurora for PostgreSQL and PL/pgSQL

This page explains the specific structure and files accepted by this scanner. See Manta Flow Usage: Preparing Scanner Inputs for additional methods how to provide these inputs via Process Manager or Orchestration API. Check Ingest Source Support how to use Manta Agent to obtain input files from a remote machine or Git.

By default, Manta Flow extracts DDL scripts from configured PostgreSQL, Greenplum, Yellowbrick, Redshift, Amazon RDS, or Amazon Aurora for PostgreSQL servers and then analyzes the data flows in them. It is also possible to analyze the data flows in the PostgreSQL PL/pgSQL scripts, Greenplum scripts, Yellowbrick scripts, Redshift scripts, Amazon RDS, or Amazon Aurora for PostgreSQL scripts that work with the configured server.

• Copy the PostgreSQL, Greenplum, Yellowbrick, Redshift, Amazon RDS, or Amazon Aurora for PostgreSQL PL/pgSQL scripts to the <MANTA_DIR_HOME>/input/postgresql/${postgresql.dictionary.id}[/database_name[/schema_name]] folder, where postgresql.dictionary.id is the identification of the server (if not changed in the configuration) and database_name and schema_name are optional directory structures that give IBM Automatic Data Lineage information about the default database and schema for any unqualified references to database objects used in the scripts. Learn more about unqualified object references.