Relational Database Connection

Relational Database Connection

Description

Describes all the information needed to connect to a relational database.

Hop supports tens of relational databases out of the box. If your specific database doesn’t have built in support, you’ll probably still be able to connect with the Generic database connection.

Check the list of databases for more details.

Related Plugins

Actions:

• Check DB Connections

• Columns exist in table

• MS SQL Bulk Loader

• MySQL Bulk File

• MySQL Bulk Loader

• SQL

• Table Exists

• Truncate Tables

• Wait for SQL

Transforms:

• Call DB Procedure

• Column Exists

• Combination Lookup/Update

• Database Join

• Database Lookup

• Dynamic SQL Row

• Execute SQL Row

• Insert/Update

• Oracle Bulk Loader

• PostgreSQL Bulk Loader

• Synchronize After Merge

• Table Compare

• Table Exists

• Table Input

• Table Output

• Teradata Bulk Loader

• Update

Options

The options describe below are for the Generic database connection.

The options for your selected database depend on the database vendor and/or engine.

General

Option	Description
Connection name	the name to use for this connection
Connection type	the description to use for this connection
Username
Password
Driver class	classname to use for this connection. This is usually only needed for generic connections. There shouldn’t be a need to specify if your select a specific database engine.
Manual Connection URL	This is usually only needed for generic connections. There shouldn’t be a need to specify if your select a specific database engine.

Advanced

Option	Default	Description
Supports the Boolean data type	true
Supports the Timestamp data type	true
Quote all identifiers in database
Force all identifiers to lower case
Force all identifiers to upper case
Reserve case of reserved words?	true
The preferred schema name
The SQL statements to run after connecting (; separated

Options

Specify a list of extra JDBC connection options as a parameter/value list.

Samples

None