How to enable SAP HANA CTS Mode support in Qlik Replicate

[Bill_Steinagle]

Qlik Replicate can take advantage of the SAP HANA CTS mode feature. 

CTS mode must be enabled on the SAP HANA Source.

To enable the feature in Qlik Replicate:

1. In the Qlik Replicate console, navigate to your SAP HANA Source Endpoint
2. Open the Advanced tab. open and click on the Advanced Tab. 
   
   
   

   You need to manually drop the current triggers as the new table name with CTS enabled will be attrep_cdc_changes_cts, not attrep_cdc_changes. By default, attrep_cdc_changes_cts is partitioned with default value of 100,000,000 rows. SAP HANA allows maximum 16K partitions. Updating threshold for each partition can impact performance and hence should be thoroughly tested in a Non-Production environment. These steps do not include the migration to CTS Mode  where you can Stop and or Resume the Tasks by enabling this feature.

3. Click More Options
   
   
   
   
4. Input the feature sapHanaCtsMode and click Add
   
   
   
   
5. Set the value to On
   
   
   
   
6. The new settings will take effect when you stop and restart the task from the endpoint.

Environment

Qlik Replicate 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Related Content 

Change CTS Configuration | SAP HANA Help Portal

[meetsriharsha]

Hi @Bill_Steinagle,

What is 'TCS' in the above article statement 'TCS mode must be enabled on the SAP HANA Source.'? 

Did you mean to say 'CTS' ?

Also, did you mean to say 'CTS mode must be enabled on the SAP HANA Source endpoint in Replicate' ?

Do we need to make any changes to the SAP HANA source system (The system which hosts the source SAP HANA database) before using this feature?

[Sonja_Bauernfeind]

Hello @meetsriharsha 

Thank you for your feedback! The TCS vs CTS topic was a spelling error. 

As for your last question: Next to enabling CTS mode, no other settings must be changed.

All the best,
Sonja