BackPrevious Topic  Next TopicNext

Supported Report Databases

Logi Report supports the current mainstream databases as well as most databases which support JDBC drivers. In addition to traditional databases, Logi Report also supports databases in the cloud, such as Vertica, Amazon RDS, and RedShift. This topic describes the databases and JDBC drivers that have been tested with Logi Report.

You should use the corresponding driver version with Logi Report if you are using any of the databases listed in the following table, though any driver which the DBMS supplier recommends is also fine. If you encounter problems when using a database or driver version that is not listed here, you can contact Logi Analytics Support at support@logianalytics.com for help.

You can also refer to the page http://wiki.netbeans.org/DatabasesAndDrivers for additional information on databases and drivers.

Database Version JDBC Driver Driver File Name
Amazon RDS   com.mysql.jdbc.Driver mysql-connector-java-5.0.4-bin.jar
Cache Cache 4 com.intersys.jdbc.CacheDriver CacheDB.jar
DB2 10.5 com.ibm.db2.jcc.DB2Driver db2jcc.jar; db2jcc_license_cu.jar; db2jcc4.jar
Derby 10.14.2.0 org.apache.derby.jdbc.ClientDriver derby.jar (already contained in Logi Report); derbyclient.jar
HIVE 0.12.0 org.apache.hadoop.hive.jdbc.HiveDriver hadoop-common-2.2.0.jar; hadoop-core-2.2.0.jar; hive-exec-0.12.0.jar; hive-jdbc-0.12.0.jar; hive-metastore-0.12.0.jar; hive-service-0.12.0.jar; libfb303-0.9.0.jar; libthrift-0.9.0.jar; slf4j-api-1.7.25; slf4j-simple-1.6.1.jar
Hortonworks 0.14.0 org.apache.hive.jdbc.HiveDriver hive-jdbc-0.14.0-standalone.jar; hadoop-common-2.6.0.jar
HSQL 2.5.1 org.hsqldb.jdbcDriver hsqldb-2.5.1.jar (already contained in Logi Report)
Informix 12.10 com.informix.jdbc.IfxDriver ifxjdbc.jar
InterSystems IRIS 2020.1.0.215 com.intersystems.jdbc.IRISDriver intersystems-jdbc-3.1.0.jar
MariaDB 10.0.2 org.mariadb.jdbc.Driver mariadb-java-client-1.5.2.jar
MemSQL 5.5.8 com.mysql.jdbc.Driver mysql-connector-java-5.1.25-bin.jar; mysql-connector-java-5.1.7-bin.jar
MongoDB 4.1.1 toolkit.db.mongo.MongoDriver mongodb-driver-sync-4.1.1.jar, mongodb-driver-core-4.1.1.jar, bson-4.1.1.jar, log4j-slf4j-impl-2.13.3.jar, and slf4j-api-1.7.26.jar (already contained in Logi Report)
MySQL 5.6.15 com.mysql.jdbc.Driver mysql-connector-java-5.1.29-bin.jar
Oracle 12c release1 oracle.jdbc.driver.OracleDriver ojdbc7.jar
PostgreSQL 9.6 org.postgresql.Driver postgresql-42.2.16.jar
PSQL V11 SP3 com.pervasive.jdbc.v2.Driver jpscs.jar; pvjdbc2.dll; pvjdbc2.jar; pvjdbc2x.jar
RedBrick warehouse   redbrick.jdbc.RBWDriver redbrick.jar
RedShift   org.postgresql.Driver postgresql-8.4-703.jdbc4.jar
ScaleDB 0.2.3 com.mysql.jdbc.Driver mysql-connector-java-5.1.25-bin.jar; mysql-connector-java-5.1.7-bin.jar
SQL Server 2019 com.microsoft.sqlserver.jdbc.SQLServerDriver mssql-jdbc-9.2.1.jre11.jar
Sybase 15.7 com.sybase.jdbc2.jdbc.SybDriver jconn3.jar
Sybase IQ 15.4.0.3019 com.sybase.jdbc3.jdbc.SybDriver jconn3.jar; jconn4.jar
Vertica 7.0.1 com.vertica.jdbc.Driver vertica-jdbc-7.0.1-0.jar

Back to top

BackPrevious Topic  Next TopicNext