Installing JDBC Drivers for Workflows¶

Fire has JDBC Processors for reading from JDBC sources or writing to JDBC sinks.

In order to connect to a JDBC source like Oracle/DB2 etc. the JDBC driver needs to be installed in Fire.

Below are the steps for installing the JDBC driver into Fire:

Download the JDBC jar file¶

Download the JDBC jar file for the Database you are looking to connect to.

Under the Fire installation directory, there is fire-user-lib directory.

Copy the downloaded JDBC jar file into it.

Stop the running Fire processes with ./run-fire.sh stop

They will be restarted automatically.

When running workflows which depend on the jar file, select the checkbox for that jar file in the Workflow Execution Page.

MySQL connector can be downloaded from : https://dev.mysql.com/downloads/connector/j/
After downloading untar it with : tar xvf mysql-connector-java-5.1.46.tar.gz
After untaring the jdbc jar file is available in the directory
Use the jar file (mysql-connector-java-5.1.46.jar) for installation in Fire

PostgresSQL JDBC drivers can be downloaded from : https://jdbc.postgresql.org/download.html

When using the JDBC processors, the following can be used for the JDBC Driver. Below are the JDBC URL’s for some databases:

Below are some example JDBC URL for reading from Relational sources when using the JDBC Processors: