Database Plugins

Creating a database connection in HOP is done using one of the many database types available, or you can create a generic connection. To create a database connection go to file → New and select Database connection.

The connection is saved in a central location and can then be used by all pipelines and workflows. If you have set your project to work with Hop, the database information will be in the ${PROJECT_HOME}/metadata/rdbms folder. Each connection created will generate a .json file in this folder with the name of the connection, containing the connection information.

If the license allowed it, a jdbc driver is included in the distribution, in a folder specific for each driver, in the general path: Installation directory/plugins/databases/Database type/lib. The documentation of the database type in following subsections shows you whether the driver is included and if it isn’t included will guide you to the location on where to download it.

The HOP_SHARED_JDBC_FOLDERS variable can be set before starting Hop to point at a centralized location of your required jdbc drivers. This can be set as an OS environment variable or be added to the Hop start script as an exported variable. Setting this variable pointed to a folder separated from the Hop installation folder, allows you to keep your drivers versions, no matter which Hop version or installation you use. This variable accepts a comma separated list to point to multiple directories the default value when not set is lib/jdbc.

To avoid conflicts, be sure that for each class of driver, there is only one in any of this folders, HOP_SHARED_JDBC_FOLDERS, hop/plugins/databases/Database type/lib or hop/lib/jdbc folder.