3579806 - Exporting Data Connection to OData Services fails with the error "Unable to connect to datasource. Check the connection details and user credentials, and then try again." in SAP Analytics Cloud (SAC)

• While creating an OData service connection for data export from SAC to BW or BW/4HANA by the basic authentication, an error message is displayed: "Unable to connect to datasource. Check the connection details and user credentials, and then try again."
• The import BW connection pointing to the same BW system can be saved successfully.
• The detailed error in the HAR file is as below
  • "message": "Unable to connect to datasource. Check the connection details and user credentials, and then try again.",
        "stack": "",
        "errorDetails": [
            {
                "messageId": "AUTHENTICATION_ERROR",
                "message": "Unable to connect to datasource. Check the connection details and user credentials, and then try again.",
                "bUIMessage": false,
                "bWarning": false,
                "customData": "Basic authentication returns status code: 400 response body: Unable to extract request URI: URI must contain a port: <saml URL> (If this is using a shared connection without credentials, please enter the credentials by running a data import using such connection)",
                "status": 401
            }
        ],
        "status": 500,
        "bUIMessage": false,
        "bWarning": false
    }

SAP Analytics Cloud

1. Create an Exporting Data Connection to OData Services as per https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/df2c80a3c35d4213b12053bc0885443e.html

The SAML2 configuration is enabled for this ICF service /sap/opu/odata/sap/RSBPC_ODATA_EXPORT_SRV.

Please follow the solution of KBA 2577263 - SAML2.0: How to disable SAML 2.0 authentication for a particular ICF service in AS ABAP.

KBA 3220729 - Checkpoints: Import and Export Job for SAP Analytics Cloud (SAC) Data to BW or BW/4HANA via an OData Service

SAP Analytics Cloud, BW, BW/4HANA, BW4HANA, oDATA, export connection, authentication error, saml2=disabled, SAC tenant, RSBPC_ODATA_EXPORT_SRV, RSBPC_ODATA_EXPORT_SRV0001, SSO, SAML2, SAML, Basic authentication returns status code: 400 response body: Unable to extract request URI: URI must contain a port, Unable to connect to datasource. Check the connection details and user credentials, and then try again , KBA , EPM-BPC-NW , NetWeaver Version , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , BC-SEC-LGN-SML , SAML 2.0 for ABAP , Problem