March 2022

Version 23.4.8843

Version 23.4.8843

Key Features

PostgreSQL now supports the Change Data Capture (CDC) job type. CDC from PostgreSQL uses the logical replication slot that is configured in your source database to read Write-Ahead-Logs. More information about how to configure Logical Replication can be found here.

Users can now select which jobs to export when they migrate jobs. Sync also exports the required connections, tasks, and events that are associated with the job.
Exporting jobs also includes the last run status for each job/task.
The ability to archive logfiles instead of deleting them was added. You can archive logs to another folder on disk or upload them to Amazon S3.
The command time-out is now configurable for transformations. The default time-out value is 300 seconds.
The embedded Jetty web server now supports JNDI connections.

The CACHE statement now supports standard replication options in the query, as shown in this example:
```
CACHE [DestinationTable] WITH AutoTruncateStrings='True' SELECT * FROM [Table]
```
Google Cloud destination connections were migrated to MySQL or PostgreSQL connection type. Existing connections are unaffected.
All connection types that were previously in the Professional or Enterprise tier were moved into the Standard tier. The current Standard and Starter tiered connection types are unchanged.
The Add Tables functionality now lets you choose a schema. This option applies only to source connection types that support multiple schemas (SQL Server, PostgreSQL, and so on).
When the source table includes a schema, Add Tables builds out the full REPLICATE command with the SELECT statement. This change should mitigate some confusion when you use both source and destination schemas.
Replace empty log-file column values with N/A. This change mostly affects transformations that use connectors that cannot generate logs.

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 that are created with a previous version of the connector require running the job/tasks with the DROP TABLE enabled to re-create the destination tables with the correct data type.

Added the WaitForResults parameter to the ExecuteJob endpoint. This parameter controls whether Sync waits for the job to complete and returns the results of the run.