JDBC Connector

Back Next

Synchronization example

Synchronization
example

You need to synchronize event data and venue data between an Informix database and Sybase to create an event catalog. In Informix, you have an event object and a venue object. You need to read from these related Informix objects before writing to Sybase. For the initial data load, configure a

synchronization

task to insert data to Sybase. For incremental updates, schedule a

synchronization

task to upsert data to Sybase.

Create JDBC_IC connections to connect to the Informix database and Sybase database. Configure a

synchronization

task to use the insert operation.

Select the Informix objects you want to use, and the predefined relationship displays.

The following image shows the event object and the venue object added as source objects:

You can view the added source objects in the Source transformation.

Select the Sybase target object in which you need to load the data.

You can view the selected target object in the Target transformation.

Use a filter if you want to filter the incoming source records.

You can view the configured filter condition used to filter the incoming source records.

Map the fields that you want to insert.

Save and run the task for the initial data load.

You can synchronize the data incrementally after the initial data migration. Create a

synchronization

task that uses the upsert operation with the same Informix source and the same Sybase target. To upsert data that has changed since the last

synchronization

, configure a simple data filter that uses the $LastRunTime or $LastRunDate variable.

Save the task and configure it to run on a schedule so the data remains synchronized.

Rename Saved Search

Table of Contents

JDBC Connector

JDBC Connector

Synchronization example

Synchronization example

Synchronization
example