3702083 - Unable to create Data Source connection in SAC for Databricks

Connection to Databricks as a JDBC datasource in SAC is never successful, and gives an error.

• SAP Analytics Cloud
• Databricks

1. Edit DriverConfig.properties file for the Cloud Agent to add location of Databricks JDBC driver
2. Restart the Cloud Agent
3. In SAC, select Connections -> Add SQL Databases
4. Select the new Databricks option
5. Populate the correct values and click Create

Support for Databricks as a datasource was only added as of version 1.0.423 of the Cloud Agent.  There was a subsequent update as of version 1.0.439.

In order to use Databricks as a datasource in SAC, you should be on the latest version of the Cloud Agent.  

If you are on a version earlier than 1.0.423, Databricks will not work.  It is recommended to keep the Cloud Agent current as changes are made for various datasources periodically.

Please visit https://me.sap.com/softwarecenter and search for SAP ANALYTICS CLOUD AGENT 1.0 (SUPPORT PACKAGES AND PATCHES) to find the latest versions.

You can also get an updated version as part of the SAP Analytics Cloud Kit which also includes the Cloud Connector and Tomcat as part of a unified install.  From the download portal search for Cloud Kit to find it.

Databricks SAC Cloud Agent version , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem