Set up the scripts for running CData Sync on the location from which you want to run the scripts. This can be a different location that the CData Sync server.
Follow these steps to make it possible for the SQL connector scripts to make use of CData Sync.
Enable the API access option for the user account that will be used to run the scripts, to enable the user to use the API to trigger jobs.
Note down the Authentication token. See the illustration below.
Add the IP addresses of the developers who should be running CData Sync to the list of Trusted IP Addresses in CData Sync. See the CData Sync documentation on Admin API setttings.
Perform the steps below on the machine that should run SQL connector scripts.
Go to the system’s Environment variables.
Make sure that this machine can execute
On the production environment, the scripts will be executed on the same machine as where CData Sync is installed. For the development setup, the scripts will run on each developer's workstation.
Updated 6 months ago