Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Replicate - SAP HANA - Replication of tables without Primary Keys

RobertoP
Contributor III
Contributor III

Replicate - SAP HANA - Replication of tables without Primary Keys

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.

5 Comments
sidneyb
Contributor III
Contributor III

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
Former Employee
Former Employee

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

Status changed to: Open - On Roadmap
Shelley_Brennan
Former Employee
Former Employee

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)

Status changed to: Delivered
sidneyb
Contributor III
Contributor III

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
Former Employee
Former Employee

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