topic Re: Extract data from CDS view via QLIK in Connectivity & Data Prep

Extract data from CDS view via QLIK

KalyanaSharaff — Wed, 26 Apr 2023 20:09:43 GMT

I am new to Qlik, we are able to extract data from ODP Datasource but we trying to get it from CDS view ( CDC delta enable CDS View), Is there a way that I can extract via Qlik? CDS view doesn't generate any data source but it can be visible in ODQMON for delta.

Re: Extract data from CDS view via QLIK

Chanty4u — Thu, 27 Apr 2023 18:00:47 GMT

Create an OData connection to the SAP system where the CDS view is located. In Qlik Sense, you can use the "SAP OData Connector" to create this connection.

In the Qlik Sense script editor, write a load statement to extract the data from the CDS view using the OData connection. For example:

LIB CONNECT TO 'SAP OData Connection';

LOAD *

FROM [CDS_View_Name]

(odatauri="https://<your-sap-system>/sap/opu/odata/sap/<your-service-name>/", qvCDSMode='delta');

Reload the script to extract the data from the CDS view. By specifying "qvCDSMode='delta'" in the load statement, Qlik Sense will automatically retrieve only the delta changes from the CDS view since the last extraction.

Schedule the script to run at regular intervals to keep the data up-to-date

Re: Extract data from CDS view via QLIK

gs_qlik_nl — Tue, 16 Jan 2024 12:25:26 GMT

I think you mean the Qlik OData Connector? There is no SAP OData Connector as far as I know.