SAP Knowledge Base Article - Public

2685620 - Which authentication types are supported for Import Data Connections to SQL Databases in SAP Analytics Cloud (SAC) & SAP Digital Boardroom?

Symptom

  • Are authentication types other than Username and Password authentication, supported for Import Data Connections to SQL Databases?

  • Is Windows AD / Kerberos authentication supported for Import Connections from SAP Analytics Cloud to SQL Databases such as Microsoft SQL Server 2014?

Environment

  • SAP Analytics Cloud 2018.15.0
  • Microsoft SQL Server 2014

Reproducing the Issue

  1. Log in to SAP Analytics Cloud
  2. Click the Menu icon - Connections
  3. Click the '+' icon > 'Import Data Connections' > 'SQL Databases'
  4. Observe that only Username and Password authentication is available

Cause

This issue is currently by design, and only Username and Password authentication is available for Import Connections to SQL Databases. For more information regarding Import Data Connections to SQL Databases, please visit the guide below;

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/0d5ffbb6951b45778c1a90ffd0114f04.html

Resolution

Please create an enhancement request at influence.sap.com (https://influence.sap.com/sap/ino/#/campaign/884) so that the Development team can look into this as a future feature implementation for a later version of SAP Analytics Cloud.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0