HI @JTapio 

Typically you would be getting a message indicating that ‘Settings are not editable’ for most tables when we have already predefined the Incremental Check Columns of these tables to apply the Incremental Replication logic. 

However, with some of our sources, including Elasticsearch, for most of the tables in the Tasks that you have created it is unlikely for them to support a default IncrementalCheckColumn due to the nature of Elasticsearch as a source. One way to resolve that is by defining an IncrementalCheckColumn by following the steps here:

https://www.cdata.com/kb/entries/sync-incremental-config.rst 

In case the task’s settings still appear as not editable or that column is not listed in the UI, you can change it by writing a custom query as in the following syntax:

REPLICATE eTABLENAME] WITH IncrementalCheckColumns = 'SomeDateColumn' SELECT * FROM LTABLENAME] WHERE ... 

If the above suggestion does not resolve your issue, kindly submit a support ticket here and make sure to provide screenshots and other relevant details about the issue so that our support team can further assist you.

We have been using ElasticSearch data source already couple of years and incremental replication has worked fine. Like I wrote I can get it working by writing “WITH IncrementalCheckColums” directly to the query, but something has changed in the new version, because I cannot do it any more using GUI

Hi @JTapio 

I am not sure what exactly has changed but it would be helpful if you could provide a screenshot of the previous working configuration. In the meantime, another possible workaround is to add the ‘IncrementalCheckColumn=DateField’ in the AdditionalOperations in the Advanced tab in the Task as in the following example:

Also, I would suggest you reach out at [email protected] and submit a support ticket here with the details of the issue and the relevant screenshots so that one of our support agents from the Sync team can further assist you.