Loading data from multiple source systems

Using CData Sync, it is possible to load data from multiple different source systems into a single process app. To do that, multiple extraction jobs have to be created, each having a corresponding source connection. Each extraction job has to call the next one in its post-job events, such that all jobs are executed one-by-one. The final job has to do the API call after it has finished. See the illustration below for an overview.

Linking jobs

In CData Sync, to make sure a job calls the next job, go to the Events tab and edit the Post-Job Event section of the first job to add the code displayed below.

<!-- Start Executing different Job -->
<api:set attr="job.JobName"        value="Extraction_job_2"/> 
<api:set attr="job.ExecutionType"  value="Run"/> 
<api:set attr="job.WaitForResults" value="true"/> 
<api:call op="syncExecuteJob" in="job"/>