Data Source

Poli connects to database through the JDBC interface. You can try connect to any databases that supports JDBC drivers. To configure Poli to connect to different databases, two steps are required.

Download the JDBC jar file

Download the JDBC jar files based on the database you'd like to connect to and put those JDBC jar files under /jdbc-drivers.

For example:

  1.     |-- jdbc-drivers
  2.         |-- postgresql-42.2.5.jar
  3.         |-- mysql-connector-java-8.0.12.jar
  4.         |-- mssql-jdbc-7.2.0.jre8.jar
  5.         |...

There are no JDBC drivers included in the release except the JDBC driver for SQLite.

Create a Data Source

For instance, information needed to connect to a PostgreSQL database

  1. Connection Url: jdbc:postgresql://127.0.0.1:5432/testdb
  2. Driver Class Name: org.postgresql.Driver
  3. Username: postgres
  4. Password: test
  5. Ping: SELECT 1

Use the ping button to test the connection.