Fetch CDS View through oData with Qlik November 2022 Patch 3

philippeb — Tue, 05 May 2026 09:51:35 GMT

Dear All,

I tried without success to connect to s/4 environnement through oData with standard odata connector in Qlik November 2022 Patch 3. Any one have success with this ?

I try successfull to connect through Edge + Soap UI but anyway never from QLIK !!

URL : /sap/opu/odata/sap/API_BILLING_DOCUMENT_SRV/A_BillingDocument/?$top=100&$format=json&sap-client=200

Thank you for your support

Regards

Philippe

Re: Fetch CDS View through oData with Qlik November 2022 Patch 3

Greg_Taffer — Tue, 05 May 2026 19:34:01 GMT

This can be acheived using these steps:

1. Mandatory Configuration Requirements

Use HTTPS: Qlik OData connectors often require strict SSL/TLS. If the connector reports errors, ensure the URL starts with https:// and is valid.
Authentication Method: SAP S/4HANA usually requires Basic authentication or NTLM. When testing, verify that the user ID has appropriate authorizations (type 'Communications Data') in SAP.
Accept Header: Try setting the Accept header to application/json or application/atom+xml. Some users found that leaving it blank causes 403 Forbidden errors.
CSRF Token Handling: SAP requires a X-CSRF-Token for POST/PUT requests. Ensure the connector is properly configured to fetch the token first, or use GET for metadata/data loads.

2. Troubleshooting Steps

Test Outside Qlik: Test the OData service URL in a web browser or tool like Postman or Excel/Power Query to confirm that the service, authentication, and firewall allow the connection.
Increase Paging: If the load fails on large tables, ensure pagination is turned on.
Limit Initial Load: Use $top=100 or the "Max Results" setting to test if the connection works with a smaller dataset.

Be mindful of:

3. Known Issues & Patches

Update PostgreSQL: Ensure the PostgreSQL database, which manages the Qlik repository, is properly updated for November 2022. Upgrades can fail if the PostgreSQL backend is not updated beforehand.
Connector Bugs: Review the release notes for November 2022 Patch 6, which addressed issues related to login and data loading.

topic Re: Fetch CDS View through oData with Qlik November 2022 Patch 3 in Connectivity & Data Prep

Fetch CDS View through oData with Qlik November 2022 Patch 3

Re: Fetch CDS View through oData with Qlik November 2022 Patch 3