3729078 - Error when adding Databricks connection to SAP Analytics Cloud (SAC)

• "An internal server error occurred in the Data Acquisition Service" when trying to add Databricks connection to SAC.
• Connection timeout error: "Connect to adb-XXXXXXXXXX.16.azuredatabricks.net:443 [adb-XXXXXXXXXX.16.azuredatabricks.net/1.234.567.890] failed: Connection timed out (Connection timed out)".

• SAP Analytics Cloud
• Databricks

1. Attempt to add a new Databricks connection to SAC.
2. Configure the proxy settings on the Cloud Agent host server using environment variables.
3. Test connectivity by pinging the Databricks server directly from the Cloud Agent host server, which succeeds.
4. Attempt to create the same connection through the SAC interface.
5. Observe the connection timeout error.

• Proxy settings in the Cloud Agent environment may not be correctly recognized or utilized during the SAC-to-Databricks connection.
• Additional or specific proxy parameters may be required for the configuration.

1. Ensure the proxy configuration is correctly set in the Cloud Agent host server's environment variables.
2. Configure the proxy settings at the JVM level to ensure compatibility with the Databricks JDBC driver.
3. Modify the connection string for the `HttpPath` field in the JDBC URL to include proxy information in the following format:
   
       ';UseProxy=1;ProxyHost=;ProxyPort='
       
4. Replace `` and `` with the actual proxy host and port values.
5. Test the connection using the updated JDBC URL to confirm resolution.

Here is an example of what a Databricks JDBC URL would look like.

jdbc:databricks://my.prefix.databricks.com:443/default;transportMode=http;ssl=1;AuthMech=11;Auth_Flow=2;
httpPath=/sql/1.0/warehouses/<WAREHOUSE_ID>;UseProxy=1;ProxyHost=<PROXY_HOST>;ProxyPort=<PROXY_PORT>;
TokenCachePassPhrase=cache;PWD=cache;EnableTokenCache=1;

connection timeout, data acquisition service, cloud agent, proxy configuration, azure Databricks, SAC, JDBC URL, httpPath, databricks connection , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem