Search

PostgreSQL Connector

PostgreSQL Connector

Back Next

PostgreSQL targets in mappings

PostgreSQL targets in mappings

For PostgreSQL target connections used in

mapping

tasks, you can configure advanced target properties in the

Targets

page of the Mapping Task wizard.

You can configure the following advanced target properties:

Property	Description
Update Mode	Specifies the mode to write data to PostgreSQL target. You can specify the following modes: Update As Update. Updates all rows flagged for update if the entries exist. Update Else Insert. Updates all rows flagged for update if the entries exist in the target. If the entries do not exist, the Secure Agent inserts the entries.
Override Target Query	An SQL statement to override the default update query that the Secure Agent generates for the update operation.
Schema Name	Overrides the schema name of the target object.
Target Table Name	Overrides the default PostgreSQL target table name.
Pre-SQL	The pre-SQL commands to run a query before you write data to PostgreSQL. You can partially parameterize pre-SQL with values specified in a parameter file.
Post-SQL	The post-SQL commands to run a query after you write data to PostgreSQL. You can partially parameterize post-SQL with values specified in a parameter file.
Truncate Target	The Secure Agent truncates the target before writing the data.
Enable target bulk load	Performs bulk upload when you configure an insert operation to write to PostgreSQL. Select this option to improve the performance of inserting data in bulk to PostgreSQL. Default is unselected. When you enable the target bulk mode to insert data to PostgreSQL, error files are not generated for rejected records.
Batch size	The number of rows that the Secure Agent writes in a single batch to PostgreSQL. Specify a batch size value that is greater than zero. Applicable if you select the Enable target bulk load option.
Reject File Directory	The directory that stores the rejected files. Specify the directory where you want to store the rejected files.
Reject File Name	Name of the rejected file that is stored in the reject file directory.
Forward Rejected Rows	Not applicable.

PostgreSQL objects in mapping tasks

Rules and guidelines for error files

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.