SAP Knowledge Base Article - Public

2801176 - Cannot select a connection when creating an SQL database in SAP Analytics Cloud (SAC).


When trying to create an SQL database connection in SAP Analytics Cloud (SAC), the 'Connection Type' dropdown box is empty after selecting the 'Location'.


SAP Analytics Cloud.

Reproducing the Issue

  1. In SAC, go to Main Menu > Connection > Add Connection.
  2. Select 'SQL Database'.
  3. Add the location.
  4. Try to add the connection type and notice that the dropdown box is empty. 


The selected location is not set to 'Default Location' because the SAC Cloud Agent has been configured to a different location.


  1. Log into SAP Cloud Connector and select "Connector" from the navigation bar on the left-hand side.
  2. Click 'Edit' on the associated subaccount and ensure that the 'Location ID' box is left empty.
  3. Click 'Save'.
  4. Go to SAC and navigate to Main Menu > System > Administration > Datasource Configuration.
  5. Go to the 'On-premise datasources' section and click 'Add a new location' (if there is not an existing location titled 'Default Location').
  6. Ensure the 'Location' is set to 'Default Location' and enter the host, port and cloud agent credentials.
  7. Click 'Save' and notice a green tick in the location box.
  8. You should now be able to successfully create the SQL connection.

See Also

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


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, cannot, SAP HANA, blank, empty, can not, create , KBA , sap analytics cloud (sac) connection to , (sac) connection to sql , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem


SAP Analytics Cloud 1.0