Symptom
- 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 Catalina logs 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"
Environment
SAP Analytics Cloud.
Reproducing the Issue
- Login to SAC.
- Go to connections.
- Click on the "+" icon.
- Choose SQL databases.
- From the popup menu, choose the Generic JDBC datasource type.
- Fill the necessary details.
- Click Create
>> Notice the error: "The database driver is misconfigured. Please contact your on-site SAP Analytics Cloud agent administrator."
Cause
Incompatibility of Databricks JDBC Driver.
Resolution
Workaround:
- Put mssql-jdbc-12.6.1.jre8.jar driver file in the tomcat lib folder.
- Put the DatabricksJDBC42.jar (downloaded from https://www.databricks.com/spark/jdbc-drivers-download) in the tomcat lib folder.
- In the Cloud Agent properties file (e.g. DriverConf.properties), add the connection type to the appropriate driver i.e., Generic JDBC datasource = <path_to_tomcat_lib_folder>/DatabricksJDBC42.jar
- In SAC side:
- For JDBC URL:
- If you are configuring SSL on Databricks, use: jdbc:databricks://<JDBC_SERVER_HOST>:<JDBC_SERVER_PORT>/<CLUSTER_ID>:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=<>;
- If not use the following URL: jdbc:databricks://<JDBC_SERVER_HOST>:<JDBC_SERVER_PORT>/<CLUSTER_ID>?ssl=false;
- For the JDBC Class: com.microsoft.sqlserver.jdbc.SQLServerDriver.
See Also
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
Keywords
Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, database, connect, establish, error, Databricks , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud 1.0