SAP Knowledge Base Article - Public

3215228 - Error "Unable to connect to datasource. Click the connection details and user credentials, and then try again" while connecting to S/4HANA import connection by ODATA service in SAC

Symptom

The below error appears while connecting to S/4HANA import connection by ODATA service:

"Unable to connect to datasource. Click the connection details and user credentials and then try again"

Environment

SAP Analytics Cloud (Enterprise).

Reproducing the Issue

  1. Logon to SAC tenant.
  2. Go to Connections -> + > Select a data source -> Acquire Data -> SAP S/4HANA.
  3. In New SAP S/4HANA Connection dialog, fill the information. In Authentication type, select Basic Authentication.
  4. Click Create.
    >> Observe the error:"Unable to connect to datasource. Click the connection details and user credentials and then try again".

Cause

SAML SSO authentication is enabled in S/4HANA, while in SAC, acquired database connection can only accept basic authentication without SAML SSO. 

Resolution

Add "&saml2=disabled" behind the Data Service URL, as the URL example: http(s)://<S/4HANA host>:<port>/?sap-client=xxx&saml2=disabled.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

AUTHENTICATION_ERROR, S/4HANA on prem, S/4HANA OP, import data source, Sac not Connect in S4hana, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence,   , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud 1.0