Getting Started with JDBC

JDBC provides generic non-spatial access to a wide number of database formats. You will need only a driver and a connection string.

The driver JDBC version is recommended to be 4.0 or 4.1. The primary source for drivers is the database vendor; however, commercial and open-source drivers are available from a number of locations. A list of third-party commercial JDBC drivers can be found at

Installing the JDBC Driver

Place the JDBC driver .jar file in one of the locations that are added to the Java CLASSPATH when the Java Virtual Machine is loaded. These locations are dependent on platform, as follows:


/Users/<username>/Library/Application Support/FME/Plugins/Java




<FMEServerSystemShare> (see FME Flow Web UI Resources)




<FMEServerSystemShare>/Resources/engine/Plugins/Java (see FME Flow Web UI Resources)





Download Location

Format Documentation

Microsoft Sharepoint

setup.jar from RSSBus


Microsoft SharePoint List Reader/Writer



Oracle Non-Spatial Reader/Writer

Oracle Spatial Object Reader/Writer




PostgreSQL Reader/Writer

SAP HANA Spatial

SAP HANA Non-spatial


SAP HANA and Cloud Platform HANA Service Spatial Reader/Writer

SAP HANA and Cloud Platform HANA Service Non-Spatial Reader/Writer

Teradata Spatial

Teradata Non-spatial


tdgssconfig.jar Teradata Spatial Reader/Writer

Teradata Non-Spatial Reader/Writer


  • To avoid connection errors, we recommend that you close FME Workbench before adding new .jar files.
  • Some JDBC drivers are bundled with additional libraries. Depending on how these libraries were packaged, they may override the libraries that came with FME. If the libraries are incompatible, they may cause instabilities within FME.

Getting Connected

JDBC connection strings are usually documented for each database driver. For example:

Using the DB2 JDBC driver, the connection string looks something like:


Using the driver available from Oracle, the connection string looks something like:

jdbc:oracle:thin:@//<host>:<port>/<service name>

Using the PostgreSQL JDBC driver available from PostgreSQL, looks something like:

jdbc:postgresql://<host>/<database name>

For accessing SAP HANA, the connection string looks something like:


For accessing SQL Server from Linux, the connection string looks something like:


In FME Workbench, you can set up a Database Connection entry that uses the required connection string. Select Tools > FME Options > Database Connections.

Once this connection has been successfully tested, it can be saved and used in any readers, writers, or transformers that want to connect using that particular connection string. For example:

The Java Driver Class is provided to support drivers that do not register themselves (pre-4.0 drivers or incompletely packaged version 4 drivers) and to ensure that the correct driver class is loaded to handle the connection string.