Key Features

Added

• Added SAML 2.0 integration for Single Sign-On authentication. This update includes Just-in-Time (JIT) user provisioning to create users automatically from SAML claims.
• Added support for two-factor authentication (2FA) for Sync user accounts.
• Added the Change Data Capture job type for the SAP ERP source.
• Added the Microsoft OneLake Mirroring destination for Microsoft Fabric integration.
• Added the NetSuite SuiteAnalytics source.
• Added support for tables without primary keys in Change Data Capture and Enhanced CDC job types. Sync now creates a _cdatasync_id hash column for row identification.
• Added support for parallel processing in SQL transformations.
• Added the Refresh Table job option for all job types. This option forces a full table refresh while it maintains incremental status for subsequent runs.
• Added the SkipSnapshot job option for Reverse ETL jobs.
• Added the ability to switch easily between connector versions from the UI.

Changed

• Improved and enhanced write performance for multiple destinations, including Google BigQuery and Azure Synapse.
  • Change the default mode for RowTransferType to Copy Into for all destinations that support that mode. The mode automatically reverts to JDBCBatch for destinations that do not support Copy Into.
• Multiple enhancements in the UI/UX:
  • Added support for resizing columns for multiple tables (jobs, transformations, and connections).
  • Improved the formatting of numbers throughout the UI.
  • Improved the Add Task dialog box to better support the loading of a large number of tables.
  • Improved load times of the Jobs and Connection pages.
• Improved the OpenID Connect experience.
  • Streamlined UI settings for better connectivity.
  • Added Just-in-Time (JIT) user provisioning support.
  • Enhanced the documentation for Microsoft Entra and Okta identity providers.
• Updated clustering to support the queuing of jobs that are executed from the API or UI.
• The SnapshotSize job option now defaults to 1,000,000 for better performance with large datasets.
• Improved error messages for invalid properties in Additional Options.
• Increased the default value for SnapshotSize to 1,000,000 for Change Data Capture jobs.
• Updated Load Folder jobs to support REPLICATE queries. This behavior enables the LoadFolder job type to take advantage of transformations and SQL functions.

Fixed

• Fixed an issue where columns did not appear in Enhanced CDC jobs in certain scenarios.
• Fixed an issue where Sync did not properly report the error messages when it ran DBT transformations.
• Fixed Japanese-character URL encoding issues in job names across various UI components.
• Fixed an issue where Sync did not use the correct schema for certain Snowflake queries.
• Fixed an issue where the Drop Table option did not delete all files when Sync replicated to Azure Blob with the FilePerBatch property set to true.
• Fixed an issue where Sync could not load Oracle dependencies in Sync Cloud.
• Fixed an issue where Sync sent license-expiration messages once every minute instead of once every day.