"DB003: Suitable driver not found" when configuring 360Suite databases

"DB003: Suitable driver not found" when configuring 360Suite databases

Symptom

  • When configuring 360Suite main database

  • When configuring 360Eyes database

  • When trying to create a 360Cast or 360WOFBO SQL source

  • When trying to create a 360View SQL Query

Once you selected your database type and validate the form, you fet "DB003: Suitable driver not found".

Environment

  • Product : 360Suite

  • Product Version : any

  • Database : any

Cause

360Suite uses JDBC drivers to connect any database. By default we only provide postgres JDBC driver. However we are compatible with a much broader set of DBMS (see PAM)


Resolution

If you need to access only one type of DBMS, you can auto configure the deployed JDBC driver at setup time:

Once the system prompt you from the JDBC driver path, enter the path to the jar file.
Please ensure the JDBC driver is compatible with java 8

Otherwise the procedure is : 

  1. Stop 360Suite tomcat
  2. Copy your jarfile into {tomcat}/webapps/360.suite/WEB-INF/lib
  3. Start 360Suite tomcat
  4. Retry configuring the database



    • Related Articles

    • How to expand Dataprovider SQL Query column in 360Eyes database

      Symptom In your 360Eyes Webi and Crystal job logs you are seeing data being truncated in EYE_DATAPROVIDER.DATAPROVIDER_SQL_QUERY Environment 360Eyes SAP BusinessObjects Enterprise XI 3.1 SAP BusinessObjects Business Intelligence 4.0 SAP ...

    • JDBC drivers matrix

      DataBase Management System (DBMS) JDBC driver names PostgreSQL postgresql-xx.x.xx.jar Oracle ojdbcX.jar MySQL mysql-connector-java-x.x.xx.jar Microsoft SQL Server mssql-jdbc-x.x.xx.jar SAP Hana ngdbc.jar SAP Sybase / SQL Anywhere jconn4.jar ...

    • Converting Oracle based MSU UNX to SSU fails with "driver could not be loaded error"

      Symptom When you launch a MSU to SSU conversion on a universe based on an Oracle ODBC connection. On WebPatform 2023.1.1 : The task ends in success When you retrieve the - Converted universe, you have an empty Data foundation On WebPlatform 2023.2 ...

    • 360Eyes Database Size Calculator

      Symptom Need to know how to size the database for 360Eyes. Environment - SAP BusinessObjects Enterprise XI 3.1 - SAP BusinessObjects Business Intelligence 4.0 - SAP BusinessObjects Business Intelligence 4.1 - SAP BusinessObjects Business Intelligence ...

    • How to configure SQL Server with Windows Authentication

      Symptom When trying to configure a SQL Server database using Windows Authentication as part of the 360eyes database configuration, the following error is returned: "The driver is not configured for integrated authentication". Environment 360Eyes ...