Versions Compared

Version Old Version 4 New Version Current
Changes made by

Jenni Wallin

Chee Hove Teng

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Setting

Description

UDR Type

Type of UDR to populate the target database table.

Database

Profile defining the database that the agent is supposed to connect and forward data to. The list is populated each time the configuration dialog is opened. For further information about database profile setup, see Database Profile(4.3).

Note

Note!

When you change the Database profile or update the content of the database. Click the Refresh button to update the information that is displayed in the Target tab.

The Database forwarding agent does not support Fast Connection Failover (FCF) used when using an Oracle RAC enabled database for the database agent.

Use Default Database Schema

Select this check box to use the default database schema for the chosen database and user.

Note

Note!

This is not applicable for all database types. Use Default Database Schema is available for selection only when accessing Oracle databases.

Tables within the default schema will be listed without schema prefix. 

Access Type

Determines if the insertion of data is to be performed directly into the target table, or via a stored procedure.

  • Direct - Insertion of data is performed directly.

  • Stored Procedure - Insertion of data is performed via a stored procedure.

Table Name or SP Name

Depending on the selected Access Type, the target database table name, or the stored procedure name, is selected. The list is populated each time a new Database or Access Type is selected.

For further information and an example of a working table, see Working Table in Tables and Stored Procedures(4.3). For further information about the stored procedure, see Database Forwarding Target Stored Procedure in Tables and Stored Procedures(4.3).

Note

Note!

For Oracle the default schema is omitted; the name of a table or SP that belongs to the current database user appears without the schema prefix.

Transaction ID Column

Name of the column in the selected table, or the parameter from the selected stored procedure, which is used for the Transaction ID Column. The list is populated each time a Table Name or SP Name is selected.

The column must be of the data type number, with support at least twelve digits.

Cleanup SP

If the selected Access Typeis Stored Procedure, the agent does not automatically clean up the target table, in case of a workflow abortion (Cancel Batch). If that is the case, the customer must supply a stored procedure that manages the clean up.

For further information and an example of a Cleanup Stored Procedure, see Cleanup Stored Procedure in Tables and Stored Procedures(4.3).

SP Target Table

Name of the target table for the stored procedure. This field is only enabled if the >Access Type is Stored Procedure.

If this agent is chained with a Database collection agent in another workflow, both agents need to be aware of the mutual table. In the collection agent, a table to collect from is always selected. However, in the forwarding agent, it is possible to select the update of the table to be done via a stored procedure. If that is the case, the target table for the stored procedure must be selected here. For further information, see Pending Transaction Table in Inter-Workflow Communication, Using Database Agents(4.3).

Note

Note!

The correct name of the SP Target Table  must be selected, or else a Database collection agent will be able to collect pending data that is not supposed to be collected. This may cause data duplication.

Run SP

If enabled, this option causes a user defined stored procedure to be called when the forwarding process terminates. It will then receive the transaction ID for the forwarded rows as input.

This option is used for transaction safety when the table is read from another system, to ensure no temporary rows are read. Rows are classified as temporary until End Batch is reached. In case of a crash before End Batch is reached, the workflow needs to be restarted for the temporary rows to be expunged.

...