> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# March 2022 (21.0.8097)

> Release notes for CData Sync March 2022 (build 21.0.8097).

## 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 in [Configure Logical Replication](../../connections/sources/postgresql-source#configure-logical-replication).

## 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:

```sql theme={null}
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.