Key Features

• PostgreSQL now supports the Change Data Capture job type. CDC from PostgreSQL utilizes the logical replication slot configured in you source database to read Write-Ahead-Logs. More information on how to configure Logical Replication can be found here

Sync Application

Added

• Users can now select which Jobs to export when migrating. Sync will also export the required Connections, Tasks, and Events associated with the Job.
• Exporting Jobs will also include the last run status for each Job/Task.
• Added that ability to archive logfiles instead of deleting them. Logs can be archived to another folder on disk or uploaded to Amazon S3.
• The command timeout is now configurable for Transformations. Default is 300 seconds.
• Embedded Jetty WebServer now supports JNDI Connections

Changed

• The CACHE Statement now support standard Replicate Options in the Query. As an example

  CACHE [DestinationTable] WITH AutoTruncateStrings='True' SELECT * FROM [Table]
  

• Google Cloud destination connections have been migrated to MySQL or PostgreSQL connection type. Existing connections will be unaffected.
• All Connection types that were previously in the Professional or Enterprise tier have been moved into the Standard tier. The current Standard and Starter tiered connection types are unchanged.
• Add Tables now lets you choose a schema. Only applies to source connection types that support multiple schemas (SQL Server, PostgreSQL, etc.)
• When the source table includes a schema, Add Tables will build out the full replicate command with the Select statement. Should mitigate some confusion when both source and destination schemas are being used.
• Replace empty logfile column values with ‘N/A’. This mostly affects transformations that use connectors that can’t generate logs.

Source and Destination Connectors

Added

• Added support for the UUID datatype in Azure Synapse
• Added support for the BigNumeric datatype in Google BigQuery
• Added support for CustomSchemas for NetSuite connections.

Changed

• Changed some Hubspot primary keys from type int to type long to avoid overflow errors. This change was added starting with Hubspot connector version 21.8076. Tables created with a previous version of the connector will require running the Job/Tasks with Drop Table enabled to recreate the destination tables with the correct datatype.

Sync API

Added

• Added the WaitForResults parameter to ExecuteJob endpoint. This parameter controls whether Sync will wait for the Job to complete and return the results of the run.

Changed

• Deprecate the Async parameter from the ExecuteJob endpoint.