Skip to main content

For a REST endpoint we need to load incremental, how can I set up incremental columns in ODX and pass this values in the RSD file?

Hi Gaspard

There is not an specific guide for this exact thing, but there are some options regarding dates that can be used.
Create an dynamic date range filter

When you have this range that automatically changes, you can just set up incremental load on the table the RSD file generates and it will add just the new rows. Be sure the field you set up the rule on gets updated with a newer date/number if there is changes, otherwise it will not be added by the rule.

The official CData guide also have some suggestions, but I have not used it yet.
https://cdn.cdata.com/help/DWF/ado/pg_customschemaselect.htm#process-select-where-on-the-server

Try it out.


Reply