Fetch CDS View through oData with Qlik November 2022 Patch 3
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 !!
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.
