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.