3360433 - ERROR: "The database driver is misconfigured. Please contact your on-site SAP Analytics Cloud agent administrator." when creating a new Databricks connection in SAC.

• When trying to create a new connection to Databricks in SAC, the below error occurs:
  "The database driver is misconfigured. Please contact your on-site SAP Analytics Cloud agent administrator."

• In the ljs_trace.log this error is found:
  "SEVERE [http-nio-8080-exec-3] com.sap.fpa.cloud.internal.DAException.null CID[29454688-5567-4677-9883-522556600185] TID[7D4425B5-4BAB-480B-AF5B-533DF446B62B] ERROR_DRIVER_NOT_CONFIGURED"

SAP Analytics Cloud

1. Login to SAC.
2. Go to connections.
3. Click on the "+" icon.
4. Choose SQL databases.
5. From the popup menu, choose the Generic JDBC datasource type.
6. Fill the necessary details.
7. Click Create
   >> Notice the error: "The database driver is misconfigured. Please contact your on-site SAP Analytics Cloud agent administrator."

Workaround:

Add the MS SQL Server 2014=<path_to_jdbc_driver> to the .properties file as such:

MS SQL Server 2014=<path_to_tomcat_bin_folder>/mssql-jdbc-6.4.0.jre8.jar
Generic JDBC datasource=<path_to_tomcat_bin_folder>/DatabricksJDBC42.jar

Note: The JDBC drivers of SQL Server and Databricks must be under the the Apache Tomcat bin folder.

In SAC side:

• For the JDBC URL: jdbc:databricks://<JDBC_SERVER_HOST>:<JDBC_SERVER_PORT>/<CLUSTER_ID>
• For the JDBC Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Microsoft JDBC Driver for SQL Server support matrix: https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16&source=recommendations

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, database, connect, establish, error , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem