SAP Knowledge Base Article - Public

2685620 - Is Windows AD authentication supported for connections to SQL Databases in SAP Analytics Cloud (SAC) & SAP Digital Boardroom?

Symptom

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

    Currently only Basic Authentication with Username and Password for SQL Databases is supported in SAP Analytics Cloud

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 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 , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0