SAP Knowledge Base Article - Public

3685390 - Error:"The database driver is misconfigured." when trying to create an import data connection to Progress OpenEdge DB in SAP Analytics Cloud

Symptom

The following error occurs: "The database driver is misconfigured. Please contact your on-site SAP Analytics Cloud Agent administrator." when trying to create an import data connection to Progress OpenEdge DB using SQL Database connection.

Environment

  • SAP Analytics Cloud.
  • Progress OpenEdge 11 Database.

Reproducing the Issue

  1. Configure an import data connection to SQL Databases as per Import Data Connection to an SQL Database | SAP Help Portal.
  2. Login to SAC.
  3. Go to Connections.
  4. Click on the "+" icon.
  5. Choose SQL databases.
  6. From the popup menu, choose "Progress OpenEdge 11".
  7. Fill the necessary details.
  8. Click Create.
    >> Notice the error: "The database driver is misconfigured. Please contact your on-site SAP Analytics Cloud agent administrator."

Cause

Wrong JDBC driver used.

Resolution

  • Use Generic JDBC Datasource, with following parameters in SAC:
    • JDBC URL: jdbc:datadirect:openedge://<hostname>:<port>;databaseName=<databaseName>.
    • JDBC Class: com.ddtek.jdbc.openedge.OpenEdgeDriver.

  • Put the JDBC Driver under tomcat lib folder and configure the Cloud Agent properties file (e.g. "DriverConf.properties") accordingly.

See Also

Import Data Connection to an SQL Database | SAP Help Portal

Keywords

sap analytics cloud, import, sql database, driver, generic, connection , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0