Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 30, 2022 6:29:44 AM
May 30, 2022 6:29:44 AM
This is an attempt to provide more details on how the Trigger based CDC method works for SAP HANA source end points.
When we work with SAP HANA source endpoint, we have two options (Advanced tab):
Log Based CDC is the recommended approach and it reads the data from Online Logs/Backup Logs or combination of both giving preference to Backup logs. But in some cases this can be non-beneficial if the redo log size is huge (depending on the DB size and number of tables) and Replicate task do not have most of the tables from DB. In these scenarios sorter operation in Replicate has to read and store all data from redo before it can figure out the required data and process those.
To avoid this drawback we have the other method which is Trigger based CDC and it focuses only on the tables mentioned in the task and doesn't consider everything else that happens in the Database.
This is how it works:
User guide which provides details on the required permissions to enable the option: Permissions
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.
How to use "Log Based CDC" when the SAP hoster is using the SAP-“Backint interface”.
As far as I know, this means that access to the log files is not possible.
Does Qlik already have a solution for this problem, as this type of backup creation is currently "state of the art"?
So the only solution is probably to use the redo logs - although this is not recommended for a productive SAP system.
Please check our documentation on the different ways to work with an SAP source endpoint. Some use the log files, some do not:
Adding and managing source endpoints | Qlik Replicate Help
Thanks,
Dana
Hi @Dana_Baldwin
sorry but that's not helpful.
I wouldn't ask if I don't have to use the log-based cdc (for example S4-Hana table ACDOCA).
Is it possible to address this problem do the development team?
This backup procedure will prevent many customers from using log-based cdc, which means that Replicate will lose its unique selling point. It should therefore be in Qlik's interest to analyze this.
Hello @WalterSchmidt
If you have identified a feature you're interested in seeing in our products, our Ideation section is the best way to address our product teams directly. The suggestions brought there by our customers are reviewed by our product managers and we appreciate any feedback sent to us this way.
You also have the possibility of raising the question in our Qlik Replicate forum, where our active engineers and your knowledgeable Qlik peers can help you with more specific use cases and questions; and, of course, we're always here to assist you more directly through Support (you can start chatting with us to create a case in the bottom right corner of this screen).
All the best,
Sonja