PostgreSQL Connector

Back Next

Specifying a target

You can use an existing target or create a target to hold the results of a mapping.

To specify the target properties, perform the following tasks:

Select the Target transformation in the mapping.

On the

Incoming Fields

tab, configure field rules to specify the fields to include in the target.

To specify the target, click the

Target

tab.

Select the target connection as PostgreSQL.

For the target type, choose

Single Object

Parameter

Specify the target object or parameter. Click

Select

, choose a target object, and then click

You can select an existing target object or create a new target object at run time and specify the object name.

To select an existing target object, select

Existing

and then select the required target table.

The following image shows the available target tables:

You can view the target objects from the list.

To create a new target at run time, perform the following tasks:

When you choose to create a target at runtime and if the target table does not exist in the target database, the Secure Agent creates the table when you run the task. If a table with the same name already exists in the database, the Secure Agent uses the existing table.

Select

Create New at Runtime

In the

Object Name

field, specify the table name for the PostgreSQL target.

In the

Path

field, specify the schema for the PostgreSQL target.

You must specify the schema in the following format:

<Schema_Name>/<TableType>

, where the TableType is TABLE. For example, if you specify the path as

private/TABLE

, the table is created in the schema named private in PostgreSQL. If you do not specify the path, the Secure Agent considers the schema from the connection properties. If you do not specify the schema in the connection properties, the target table is created in the public schema.

The following image shows the target object properties for the

Create New at Runtime

option: