SAP Knowledge Base Article - Public

3488102 - Unable to view any connection under "Connection Type" when creating a new SQL Database connection in SAC.

Symptom

Unable to view any connections configured in "DriverConfig.properties" file, under "Connection Type" when creating a new SQL Database connection in SAC.

Images and data taken from SAP internal systems and demo environments. Any similarity to production data is purely coincidental.

Environment

  • SAP Analytics Cloud.
  • Windows.

Reproducing the Issue

  1. Login to SAP Analytics Cloud.
  2. Go to Connections.
  3. Click on the + icon to create a new connection.
  4. Select import connection -> SQL Database.
  5. Fill the necessary details.

        >>Cannot view any connection name under "Connection Type" dropdown.

Cause

Misconfiguration of the Environment Variable.

Resolution

"SAP_CLOUD_AGENT_PROPERTIES_PATH"environment variable should be created under "System variables" instead of "User variables" section.

See Also

Keywords

SAC, SAP Analytics Cloud, import, connection, SQL, jdbc, driver, environment variable, windows , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0

Attachments

Pasted image.png
Pasted image.png
Pasted image.png