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:
Select the Sybase target object in which you need to load the data.
Use a filter if you want 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.
