March 2022

Version 24.3.9110


March 2022

Version 24.3.9110


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.

CData Sync Application

Added

  • 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.

Changed

  • 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.

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 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.

CData Sync API

Added

  • 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.

Changed

  • Deprecated the Async parameter from the ExecuteJob endpoint.