Step name

Name of the step.

Note: This name has to be unique in a single transformation.

Connection

Name of the database connection on which the target table resides.

Note: The password of this database connection is not used, see below in the "#Set up authentication" section! Since PDI-1901 is fixed in 3.2.3, the username of the connection is used and added to the -U parameter, otherwise the logged in user acount would be taken.

Target schema

The name of the Schema for the table to write data to. This is important for data sources that allow for table names with dots '.' in it.

Target table

Name of the target table.

psql path

Full path to the psql utility.

Load action

Insert, Truncate. Insert inserts, truncate first truncates the table.

Note: Don't use 'Truncate' when you are running the transformation clustered or multiple step copies! In this case, truncate the table before the transformation starts, for example in a job.

Fields to load

This table contains a list of fields to load data from, properties include:

• Table field: Table field to be loaded in the PostgreSQL table;
• Stream field: Field to be taken from the incoming rows;
• Date mask: Either "Pass through, "Date" or "DateTime", determines how date/timestamps will be loaded in PostgreSQL.