Suggest an Idea

[RobertoP]

Want to see the potential of adding replication support for tables where the database table may not have a primary key, but the application will have a key defined on the table. Examples would be tables like ACDOCA, which is a key table commonly requested for financial reporting and analytics.

[sidneyb]

Interested in this feature as well since huge and wide HANA tables (10+ billions of records) typically don't have primary key or unique indexes to avoid performance issues.
Also, this feature needs to work with the trigger-based approach for HANA source endpoint.

[Shelley_Brennan]

We are planning to support this with upcoming log-based approach for SAP HANA, as opposed to trigger-based.

[Shelley_Brennan]

For tables that do not have a primary key in HANA sources, there are two options:

1. Using the SAP Extractor source endpoint

2. Using the log-based CDC option in the SAP HANA source endpoint (available with the May 2021 release)

[sidneyb]

Thank you for your response.

- on SAP Extractor source endpoint our team is still trying to make it work and working with Qlik support team for a while already. 

- on the log-based CDC it still does not work with CommVault, our company already asked for that improvement. Any idea when that feature will be available?

[Shelley_Brennan]

Support for CommVault with log-based CDC is still a longer-term roadmap item and I don't have a timeline at this point.