Symptom
- Using REST API to export SAC data to BW/4HANA
- The following error message occurs in SAP HANA Smart Data Access (SDA) to establish a connection to a remote source to get planning data out of SAP Analytics Cloud to the BW/4HANA system:
- SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Could not get tables
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
- Open the SAC Tenant > Administration > App Integration > Add a new OAUTH client
- Setup OAUTH client with Data Export Service
- Take the secret and token details from the configuration
- Creating remote source in HANA with this OAUTH configuration
- Remote source access: Remote source created successfully but cannot get to the connection
Cause
- A configuration issue on the DPAgent side. The OAuth credentials are either expiring or incorrect.
Resolution
- Ensure the OAuth credential is correct and valid.
See Also
KBA 2496051 - How to change "Logging Level" (Trace level) of a Data Provisioning Agent - SAP HANA Smart Data Integration
Keywords
HTTP/1.1 401 Unauthorized{"error":"invalid_client","error_description":"Bad credentials"}, 403 - Forbidden, For more information about why the request was refused, see the server, Invalid odata connection! Getting odata metadata failed because of (403) Forbidden [HTTP/1.1 403 Forbidden] Context: Invalid odata connection! Getting odata metadata failed because of (403) Forbidden [HTTP/1.1 403 Forbidden] , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem