March 2022

Version 22.0.8425


March 2022

Version 22.0.8425


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.