Skip to main content
SUBMITTED

Move ODX Data Transfer Incremental Setting to Jobs

Related products:TimeXtender Data Integration
  • September 29, 2023
  • 1 reply
  • 27 views

bas.hopstaken
TimeXtender Xpert
Forum|alt.badge.img+5

In the current version, you can enable/disable incremental load in the Transfer task. If you like to schedule an incremental load on weekdays and a full load in the weekends for example. You need to recreate the data transfer task. And when you need to add tables to the transfer task, you need to do it twice (for incremental and full data transfer).

Unfortunately it is not possible to copy/clone ODX tasks, so it can be a lot of work to recreate a transfer task.

It would be way easier if the incremental enable/disable option is moved to jobs. This makes it possible to create an incremental and a full load job. Both jobs are connected to the ODX same transfer task. 

1 reply

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • September 29, 2023

Hi @bas.hopstaken ,

it would probably also be good to have the option for turning on/off incremental ODX extraction for sources that are set up to be on-demand, as those don't need to have explicit tasks and therefore have no way of controlling incremental load.