Symptom
- When trying to create a new connection to SAP MaxDB in SAC, the below error occurs:
"The database driver is misconfigured. Please contact your on-site SAP Analytics Cloud agent administrator." - In Catalina logs below error is found: "ERROR_DRIVER_NOT_CONFIGURED"
Environment
- SAP Analytics Cloud
- MAxDB
Reproducing the Issue
- Login to SAC.
- Go to connections.
- Click on the "+" icon.
- Choose SQL databases.
- From the popup menu, choose "MaxDB 7.9".
- Fill the necessary details.
- Click Create
>> Notice the error: "The database driver is misconfigured. Contact your SAP Analytics Cloud agent administrator."
Resolution
Create the connection using the Generic JDBC datasource with the following configuration:
- Connection URL: jdbc:sapdb://<database_computer>[:<port>]/<database_name>
- JDBC class: com.sap.dbtech.jdbc.DriverSapDB
See Also
SAP MaxDB JDBC Driver help portal: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/1f8802ad0a634955b6210c6e98536097/467bc36ee97150d1e10000000a155369.html
Keywords
SAC, MaxDB, Driver, import connection, SAP Analytics Cloud, jdbc , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud 1.0