I need to set up a data connection from Qlik Sense Enerprise on Windows to SAP BW/4HANA.
Unfortunately, I'm a complete SAP nooby and somewhat overwhelmed with all the different terminology and options being thrown around. So please correct me if I'm wrong.
From what I understand the SAP BW Connector is my best option to access data and queries from SAP BW/4HANA. Then there is the SAP ODP Connector. Does it also work with BW/4HANA?
With this, each execution appends records to the ExcelReloadHistory.qvd, including a timestamp so you can track the evolution of the lineage over time.
TempReloadAuditData: NoConcatenate LOAD _ReloadExecutionConcurrencyKey as 'ExcelConcurrencyKey', ReloadID as 'ExcelReloadID', _AuditReloadKey RESIDENT Reloads;
LEFT JOIN (TempReloadAuditData) LOAD _AuditReloadKey, FileType as 'ExcelReloadFileType', FileName as 'ExcelReloadFileName', DataConnectionID RESIDENT AuditReloadLineage WHERE FileType = 'xlsx' or FileType = 'xlsm';
// Append the records to the historical QVD CONCATENATE (ExcelHistory) LOAD *, Now() as RecordTimestamp RESIDENT TempReloadAuditData;
// Store the full history into a QVD file STORE ExcelHistory INTO ExcelReloadHistory.qvd (qvd);
// Drop temporary table to clean up DROP TABLE TempReloadAuditData;
I am not 100% sure but SAP connectors have a license cost. May be you can Ask to Qlik Customer service and they will guide you, due to (I believe) is an extra paid service.
I apologize in advance if I am mistaken.
You can do a work a round making ie. a daily copy of SAP data base to a data base that you can connect by odbc or REST connections, depending on the structure that you have on the company.
