Key Features

Added

• Added the Delta Parquet file format that is used to create Delta Lake instances in the following destinations:
  • Amazon S3
  • Azure Blob Storage
  • Azure Data Lake Storage
  • Google Cloud Storage
• Enabled the installation of a custom JDBC connector as a source connection.
• Added new reverse ETL destinations:
  • Salesforce Pardot
  • Salesforce Marketing Cloud
  • Sage Intacct
  • Veeva Vault
• Added new enhanced CDC sources:
  • DB2 for i (native)
  • MySQL
• Added support for hard deletes in CDC and enhanced CDC jobs.
• Added support for the Transformation Library in enhanced CDC jobs.
• Added support for complex SQL query operations (for example, joins or unions) in REPLICATE queries.
• Extended support for the REPLICATE_LASTMODTIME() function for more complex queries.
• Added the Append Only History Mode option.
• Added the ability for users to map identity provider (IDP) groups to Sync roles when they use Just-in-Time (JIT) provisioning.
• Improved write performance for the following destinations:
  • Amazon S3
  • Azure Blob Storage
  • Azure Data Lake Storage
  • Google Cloud Storage
• Added the ability to edit connection names in the UI.
• Added the ability to view and edit schema details for custom schemas, including the API connector.

Changed

• Updated the embedded Jetty web server to version 12.0.17 for improved security and performance.
• Updated the Java Runtime Environment (JRE) to address security vulnerabilities and improve overall system security.
• Enhanced security measures addressing various vulnerabilities in core components.
• Updated the Toast notification positioning to the bottom right corner for better user experience.
• Enhanced validation for enhanced CDC sources to prevent configuration errors.
• Improved the JIT Provisioning component in the UI for easier configuration.
• Optimized the Jobs page performance, especially with large numbers of jobs.

Fixed

• Fixed an issue where jobs were not properly removed from the queue after completion in a clustered environment.
• Fixed an issue where the CDC engine status was hidden when job names were too long.
• Fixed a performance issue with the SyncAll job type that caused slow execution.
• Fixed an issue where Sync sent job emails before job completion.
• Fixed an issue where an error that occurred during the GetOAuthAccessToken procedure produced an extra log file.
• Fixed an issue where refreshing the Add Task dialog box did not clear the metadata cache when you use an OAuth connection.
• Fixed an issue where the CommandTimeout property was ignored when you create transformations via API.
• Fixed an issue where SYNONYM table types were incorrectly returned as TABLE in Oracle.
• Fixed an issue where you could not create users without providing a password.