SAP Knowledge Base Article - Public

3259107 - Import Data Connection to SQL does not prompt for User Credentials in SAP Analytics Cloud

Symptom

After creating an Import Data Connection to SQL, without sharing credentials, when another user attempts to consume this Connection, eg. when creating a Model, the User is not prompted for datasource credentials and the following error is shown;

"Unable to connect to data source. Check your connection details then try again."

Environment

  • SAP Analytics Cloud Wave 2022.15.x
  • Import Data Connection to SQL (Amazon Redshift)

Reproducing the Issue

  1. Log in to SAP Analytics Cloud with User A
  2. Navigate to Connections
  3. Create an Import Data Connection to SQL and disable the "Share these credentials when sharing this connection" checkbox
  4. Log in to User B
  5. Click Modeler > Create New > From a datasource
  6. Select SQL Databases
  7. Select the recently created connection, created by User A
  8. Observe no prompt screen to enter credentials is shown, and the error is shown

Cause

This issue is currently under investigation by the Development team

Resolution

This issue is currently under investigation by the Development team

See Also

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

Keywords

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.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://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  , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0