MySQL
- class:com.mysql.jdbc.Driver
- connectString:jdbc:mysql://<host>/<database>?useUnicode=true&characterEncoding=utf8
SQLITE
- class:org.sqlite.JDBC
- connectString: jdbc:sqlite:/tmp/test.db
MSSQL
- class: net.sourceforge.jtds.jdbc.Driver
- connectString: jdbc:jtds:sqlserver://<host>;databaseName=<DATABASE_NAME>;instance=<INSTANCE>
MSSQL - EXPRESS
- class: net.sourceforge.jtds.jdbc.Driver
- connectString: jdbc:jtds:sqlserver://<host>;databaseName=<DATABASE_NAME>;instance=SQLEXPRESS
Sybase
- class: net.sourceforge.jtds.jdbc.Driver
- connectString: jdbc:jtds:sybase://<host>[:<port>][/<database_name>] , for example: jdbc:jtds:sybase://localhost:5000/myDB
POSTGRESQL
- class:org.postgresql.Driver
- connectString: jdbc:postgresql://<host>:5432/<database>
ORACLE
- class: oracle.jdbc.driver.OracleDriver
- connectString: jdbc:oracle:thin:@<host>:1521:<oracle_sid>
INFORMIX
- class:com.informix.jdbc.IfxDriver
- connectString: jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<instance>;CLIENT_LOCALE=en_US.57372;DB_LOCALE=en_US.57372;DBDATE=Y4MD-
Apache-Drill
- class: org.apache.drill.jdbc.Driver
- connectString: jdbc:drill:drillbit=<address_ip_apache_drill_1.0.0>:<port>, example: jdbc:drill:drillbit=127.0.0.1:31010 (if Apache Drill and ProReports share machine).
ElasticSearch
- class: nl.anchormen.sql4es.jdbc.ESDriver
- connectString: jdbc:sql4es://<host>:9300/<myidx>?cluster.name=<your-cluster-name>, example: jdbc:sql4es://127.0.0.1:9300/logstash?cluster.name=elasticsearch (if ElasticSearch and ProReports share machine).
- datasource definition in ProReports:
HP Vertica
- class:com.vertica.jdbc.Driver
- connectString: jdbc:vertica://<host>:<port>/<dbname>
Azure Cosmos DB (MongoDB interface)
- class:com.dbschema.MongoJdbcDriver
- connectString: mongodb://USERNAME:PASSWORD@USERNAME.documents.azure.com:10255/?ssl=true&replicaSet=globaldb
In internal report set block like below:
Variable $V[row] is array with next records from collection tablica in database testdb. Variable $V[row_utf8] is row converted to string with UTF-8 encoding.
SmallSQL
- class:smallsql.database.SSDriver
- connectString: jdbc:smallsql:<database>[?create=true] (<database> is a absolute or relative directory name)
XLS files
- class: org.aarboard.jdbc.xls.XlsDriver
- connectString: jdbc:aarboard:xls:<directory_path_to_xls_files> (for example: jdbc:aarboard:xls:/C:/ProReports.utf8/XLS/)
XLS file - sqlsheet driver
In Element of Internal report in section SQL write: SELECT <name_of_field1>,<name_of_field2>.... FROM <name_of_xls_file_without_xls),
for example: SELECT ID,NAME FROM TEST - where data in file test.xls
