Key Features

Added

• Introduced Workspaces as way to partition resources within Sync.
  • Resources (connections, jobs, and transformations) are now contained in a single workspace. They cannot be shared across workspaces.
  • Added the ability to create, rename and delete workspaces.
  • Added the ability to move resources from one workspace to another.
  • Added the ability to import and export workspaces from one Sync instance to another.
  • When starting Sync for the first time, the ‘default’ workspace is created and all current resources are moved into it.
• Added the Enhanced CDC job type for the IBM Informix and DB2 LUW sources.
• Added Oracle as a ReverseETL source.
• Added Hubspot, Zoho CRM, and Kintone as ReverseETL destinations.
• Added the ‘Pause/Resume’ operations for tasks to allow skipping tasks when executing a job.
• Added the ‘Table Name Suffix’ Job Option.
• Added support for saving an email address for users.

Changed

• Updated UI/UX for Workspaces.
  • Added a top-nav bar and included links to Settings, Logs and Documentation pages.
  • Added History tabs to Jobs and Transformation pages.
• Updated current custom role policies to only apply to the ‘default’ workspace.
• Improved the ‘Add Task’ modal
  • Added the ability to easily differentiate between tables and views
  • Enabled searching for a table across multiple schemas
  • Fixed an issue where updating the search would un-select previous tables
• Updated the documentation for Sync Cloud by removing pages that only applied to on-premise installations.
• Updated PostgreSQL CDC by supporting the truncate command.
• Updated Migration to support exporting multiple resources.
• Updated Clone to support cloning a resource into a different workspace
• Updated dbt Cloud Settings modal to support US multi-tenant accounts. Replaced the Region setting with the Base URL setting.
• Improved the ‘System Health Alerts’ by adding more control over when alerts are sent for high resource usage.
• Improved performance for Databricks and Redshift destinations
  • The Redshift destination requires that InsertMode is set to S3Staging.
• The SAP HANA and SAP Gateway connector have been moved to premium.
• The default value for SnapshotSize is now 1000000.
• The UseSourceSchemaInMerge job option now defaults to true.
• Updated the ‘Execute Job’ snippet for post-job events.
  • Note: All previous scripts must update the op to api.rsc/executeJob. The previous method of using .\api\executeJob.rsb has been deprecated.
• Removed the LOCK TABLE requirement for Oracle Enhanced CDC jobs.

Fixed

• Fixed an issue where ‘Edit Destination’ was disabled for tasks in Enhanced CDC jobs.
• Fixed an issue where the Command Timeout was ignored if set at that task level.
• Fixed an issue where the status for Enhanced CDC jobs was not displayed correctly in clustered environments.
• Fixed an issue where changing the job name while importing would cause tasks to disappear.
• Fixed an issue where the Oracle (Native) connector did not support special characters for users.
• Fixed an issue where the scheduler was not suspended when Sync ran out of disk space.
• Fixed an issue where the application logs would fill up with permission errors when the session expired.
• Fixed an issue with DROP TABLE when using SAP HANA as a destination.
• Fixed an issue where Oracle Enhanced CDC jobs may miss changed records when first starting the job.
• Fixed an issue where you could not switch from hard to soft delete without dropping the table.
• Fixed an issue where the sync.exe.config file would be overwritten on update.
• Fixed an issue where the logfile could contain sensitive connection properties when using Snowflake destination.