SAP Knowledge Base Article - Public

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.

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

  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."

Cause

Incompatibility of Databricks JDBC Driver.

Resolution

Workaround:

  1. Put mssql-jdbc-12.6.1.jre8.jar driver file in the tomcat lib folder.
  2. Put the DatabricksJDBC42.jar (downloaded from https://www.databricks.com/spark/jdbc-drivers-download) in the tomcat lib folder.
  3. 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 
  4. 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