"DB003: No suitable driver found" when configuring 360Suite databases

"DB003: No suitable driver found" when configuring 360Suite databases

Symptoms

When configuring 360Suite main database.
When configuring 360Eyes database.
When trying to create a 360Cast SQL source.
When trying to create a 360View SQL Query.

In any of these situations, when the database type was selected, the following error appear:
Quote
DB003: No suitable driver found

Cause

360Suite uses JDBC drivers to connect any database.
By default, 360Suite only embeds PostgreSQL JDBC driver.
Info
360Suite is compatible with a much broader set of DBMSes (see our PAM).

Resolution

All appriopriate JDBC drivers must be selected when prompted during the installation or the upgrade of 360Suite.
It is therefore recommended to copy/paste them all beforehand in a single custom folder (e.g. "D:\JDBC"). and the during the setup, select all the required drivers from this folder.

References

  1. 360Suite Product Availability Matrix (PAM)
  2. 360Suite Documentation | Installation

    • Related Articles

    • Audit Snapshot Fails in 360Eyes — Unsupported DB URL (jdbc:sqlanywhere)

      Symptoms When running the 360Eyes – Audit job, the job fails during DO_SPECIFIC_JOB_ACTIONS and the log displays: Could not generate snapshot : Current DB URL (jdbc:sqlanywhere:DSN=BIA_Audit_PROD) is not supported. Cause The Audit data source is ...

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

      Symptom When running 360Eyes Impact Analysis Reports (such as Report 52), users observe that the SQL query stored in the 360eyes_REPORTS.unx / Eye Document / Dataprovider / Dataprovider Sql Queryfield is incomplete, partial or truncated. This often ...

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

    • DB011/DB02 - How to configure the 360Suite database with SQL Server AD Domain account

      Symptom When configuring the database in the Web Platform Administration Console with a AD Domain account for SQL Server, you encounter one of the following errors : - DB012: Could not find driver - DB011: This driver is not configured for integrated ...

    • Wrong collation for 360Eyes database on SQL Server

      Error Updating SQL Server Password in 360Eyes – Collation Issue Description After updating the SQL Server account password used in 360Eyes, attempts to update the password in the Eyes Configuration (Admin Page) result in a runtime error: [ERROR] ...