- 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
- 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
- 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 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 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.
- 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.
- Deprecate the Async parameter from the ExecuteJob endpoint.