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
- Login to SAP Analytics Cloud.
- Go to Connections.
- Click on the + icon to create a new connection.
- Select import connection -> SQL Database.
- 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
- Import Data Connection to an SQL Database
- KBA: 2358097 - SAP Analytics Cloud connecting to on-premise data (Import Data Connection) *** Collective KBA ***
Keywords
SAC, SAP Analytics Cloud, import, connection, SQL, jdbc, driver, environment variable, windows , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
Attachments
Pasted image.png |
Pasted image.png |
Pasted image.png |