Solved

What is the recommended method to add a column to a replicated table recording when the data was synced by CData?

  • 24 March 2023
  • 1 reply
  • 45 views

Badge

What is the recommended method to add a column to a replicated table recording when the data was synced by CData? Is there a built-in feature or a custom query?

icon

Best answer by Maha 24 March 2023, 14:35

View original

1 reply

Badge

Using the Pre-Job event script, found under ‘Events’ in the Job settings, environment variables can be added to the job execution. The following example creates a currentTimeStamp variable with the current timestamp and pushes out the item with that value to the Job:

To reference the environment variable you create, surround the env.attribute with curly braces {}.

For more information about Events, please see the following Sync documentation: CData Sync - Events | 22.0.8481 

Reply