Key Features

Added

• Connections now have the option to use the CData OAuth Callback URL. You should use this option when the client requires a TLS-redirect URL.
• A logging module was added to each connection. Set the logfile verbosity to generate logs whenever CData Sync uses the connection (Test Connection, Add Tasks, and so on).
• A search bar for connections is available now when you create a job or transformation.
• You can now adjust the order of tasks within a job.
• The Cross-Platform Edition now supports LDAP authentication
• The Cross-Platform Edition now supports the ability to deploy Sync in IIS
• Sync now supports the ability to import settings from CData Sync 2019.

Changed

• Sync no longer restarts when you update connectors. You can now use a connector immediately after you update it.
• The oauthsettings.txt files are now deprecated. OAuth tokens have been moved the application database in the sync_tokens table.
• Connections to dbt Cloud now support multiple regions. The API Key setting was renamed Token, and that setting now supports personal access tokens (PAT) and service tokens.
• The post-job event now includes the full job status (including each individual task status). For details, see Post-Job Event
• The STATUS column on the Connection page now includes details about when the connection was tested last.
• The CSV destination now creates subfolders if they are missing in the root directory.
• You can save proxy settings now when Sync is unlicensed.
• When you set up a new reverse ETL job flow, clicking the back button now clears the previous selection and error messages.
• The SharepointOAuth Auth scheme now hides the Connect button because that button is not needed.
• The Deletion Behavior property is now hidden for Load from Folder jobs.

Fixed

• Fixed an issue where the Custom Schema tab was available for connections that do not support it.
• Fixed an issue where the Task details took a long time to load when using Oracle as a source.
• Fixed an issue where the Destination Table drop-down list is not be visible in certain situations.
• Fixed an issue where the connections-details page for multiple API profiles were blank.
• Fixed an issue where renaming a job did not validate the characters in the name.
• Fixed an issue where Sync did not let the user set Replicate Start Date as the task level unless it was set already at the job level.
• Fixed an issue where you could choose an incremental check column for all sources, even when no such column was available.
• Fixed an issue where you could save a value of Undefined for baseurl.
• Fixed an issue where Sync ignored precision when a Timestamp column was created in Microsoft SQL Server.