Structure Replication

[About]

Usage

Use this window to create a new replication job, or maintain an existing job.
Here you can set up a replication job, define data-structures and replicate these structures to IFS Connect for XML-presentation f.ex.

This is done by generated packages that selects data and creates a message in Connectivity/OutMessageBox. To invoke the packages, one either generates triggers on selected tables, or starts the packages directly from this form.
The packages will select data from structures specified and eventually send a message using a call to PLSQLAP_Server_API.Post_Outbound_BizAPI.

Work-flow

The work-flow for this  function is as follows :

    1. Enter header-info for the job according to field descriptions below.

    2. Define Structures and data related to trigger functionality. Define columns for each structure item.

    3. Generate Packages (RMB) for data replication to Connect.

    4 Generate Triggers  (RMB) on selected tables to invoke the generated package.

    5. Alternatively to previous item, invoke the packages directly from this form. (mode=Manual)

    6. Check log-table or server-processes from RMB-choices.

Activities

Copy Migration Job: Allows you to make a copy of the job. (Header + structure).

Start Packages: You may invoke the Insert/Update package directly. This requires a WHERE-clause on master view in the structure.Packages can be executed both on-line and in batch (started from the ExecutionPlan folder).

Compile Packages: Generates packages according to defined structure.

Compile Triggers: Generates triggers for tables declared in the Structure folder.

Enable Triggers: Generated triggers always have initial status DISABLED. All triggers for a job are enabled from this menu choice.  Changes in header or structure is prohibited as long as triggers are enabled.

Disable Triggers: In order to stop a replication, one can disable all triggers for a job.

Show Scheduled Migration Jobs: From this window, you can view Scheduled Migration Jobs.

Show Log: From this window, you can monitor the log-table, used by jobs started in mode 'Batch'.