What's new?
This section describes the new and enhanced features in Replicate November 2023.
Customers should also review the Replicate release notes in Qlik Community for information about the following:
- Migration and upgrade
- End of life/support features
- Newly supported OS platforms, databases, and third-party software versions.
- Resolved issues
- Known issues
Endpoint enhancements introduced in Replicate November 2023 service release 1
This section describes enhancements to existing endpoints in Replicate November 2023 service release 1.
Databricks Lakehouse (Delta) and Databricks (Cloud Storage) - Support for OAuth authentication
The ability to set OAuth as the authentication type has been added to the General tab in the endpoint settings.
Using Databricks Lakehouse (Delta) as a target
Using Databricks (Cloud Storage) as a target
New endpoints and endpoint enhancements introduced in Replicate November 2023 initial release
This section describes new endpoints and enhancements to existing endpoints.
New Google Cloud SQL for SQL Server source endpoint
This version introduces support for replicating data from Google Cloud SQL for SQL Server to any supported target.
Using Google Cloud SQL for SQL Server as a source
New Confluent Cloud target endpoint
This version introduces support for replicating data from any supported source to Confluent Cloud.
Using Confluent Cloud as a target
Kafka target - Support for certificate + username and password authentication
A new Certificate + Username and password authentication option was added to the Schema Registry Connection Properties in the General tab. This option is only available when the Publish data schemas to Confluent Schema Registry option is selected.
Setting general connection properties
PostgreSQL-based sources - Data type mapping change
A new Map BOOLEAN to Replicate BOOLEAN data type (instead of STRING (5)) option was added to the Advanced tab. Clear this option if you want BOOLEAN columns to be mapped to the Replicate STRING (5) data type.
MySQL-based targets - Support for connecting via SSL
SSL connection settings have been added to the Security section in the General tab.
Changes to Amazon Redshift data type mapping
In previous versions, the Replicate BOOLEAN data type was mapped to VARCHAR(1) in Amazon Redshift. Starting from this version, it will be mapped to BOOLEAN.
Changes to Amazon MSK topicMapping property values
The Amazon MSK target endpoint dialog allows users to choose whether data should be written to a Specific topic or to a Separate topic for each table. When exporting a task, these options are represented as topicMapping values in the exported JSON file. Prior to Replicate November 2023, the values corresponding to the UI options were Specifictopic and separatetopicforeachtable. From Replicate November 2023, these values have been changed to SPECIFIC and TOPIC_PER_TABLE respectively. Therefore, when importing a task with an Amazon MSK target endpoint that was exported from a previous version, you need to update the JSON file with the new values before importing the task.
Snowflake targets (Google, AWS, and Azure) - Support for OAuth authentication
The ability to set OAuth as the Authentication type has been added to the Snowflake Access section in the General tab.
Amazon S3 and Amazon Redshift Targets - IAM Roles Anywhere Support
-
Amazon Redshift Target: The ability to select IAM Roles Anywhere as the Access type has been added to the Amazon S3 Staging section in the General tab.
-
Amazon S3 Target: The ability to select IAM Roles Anywhere as an Access option has been added to the Amazon S3 Storage section in the General tab.
Google BigQuery target
Starting from this version, customers no longer need to install the Google Cloud SDK.
Support for "Trigger-based CDC" mode when using SAP HANA as a SAP Application (DB) backend
The SAP Application (DB) endpoint now supports SAP HANA as a backend configured to work in "Trigger-based CDC" mode. In previous versions, only "Log-based CDC" mode was supported.