JDBC V2 Connector

Back Next

Create a target table at runtime

You can use an existing target or create a target in a mapping. If you choose to create the target, the agent creates the target when you run the task.

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.

For the target type, choose

Single Object

Parameter

Specify the target object or parameter.

To specify a target object, perform the following tasks:

Click

Select

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

To create a target object at runtime, select

Create New at Runtime

Enter the name of the target table that you want to create name in the

Object Name

field.

In the Path
field, specify the target table name and schema in the following format:

<Schema-Name>/<TableType>

, where the mandatory value for TableType is TABLE.

For example, private/TABLE

In the example, the table is created in the schema named "private" in the database server. If you do not specify a value for the path, the Secure Agent considers the schema name you specified in the connection. If you did not specify a schema name in the connection, the Secure Agent creates the table in the default schema.

Click

Specify the advanced properties for the target, if required.

JDBC V2 targets in mappings

Rules and guidelines for creating a target at runtime

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal