SAP Knowledge Base Article - Public

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

Symptom

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

Environment

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. 

Cause

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

Resolution

  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.

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, cannot, SAP HANA, blank, empty, can not, create , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , Problem

Product

SAP Analytics Cloud 1.0