# Relational Database Connection

## Relational Database Connection

### Description

![database](/files/pq2aFK55OoWI5zRYZnR6)

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](/data-shaper-1.21/knowing-the-data-shaper-designer/relational-database-connections.md) for more details.

### Related Plugins

Actions:

* [Check DB Connections](/data-shaper-1.21/knowing-the-data-shaper-designer/workflows/actions/checkdbconnection.md)
* [Columns exist in table](/data-shaper-1.21/knowing-the-data-shaper-designer/workflows/actions/columnsexist.md)
* [MS SQL Bulk Loader](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/mysqlbulkloader.md)
* [MySQL Bulk File](/data-shaper-1.21/knowing-the-data-shaper-designer/workflows/actions/mysqlbulkfile.md)
* [MySQL Bulk Loader](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/mysqlbulkloader.md)
* [SQL](/data-shaper-1.21/knowing-the-data-shaper-designer/workflows/actions/sql.md)
* [Table Exists](/data-shaper-1.21/knowing-the-data-shaper-designer/workflows/actions/tableexists.md)
* [Truncate Tables](/data-shaper-1.21/knowing-the-data-shaper-designer/workflows/actions/truncatetables.md)
* [Wait for SQL](/data-shaper-1.21/knowing-the-data-shaper-designer/workflows/actions/waitforsql.md)

Transforms:

* [Call DB Procedure](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/calldbproc.md)
* [Column Exists](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/columnexists.md)
* [Combination Lookup/Update](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/combinationlookup.md)
* [Database Join](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/databasejoin.md)
* [Database Lookup](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/databaselookup.md)
* [Dynamic SQL Row](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/dynamicsqlrow.md)
* [Execute SQL Row](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/execsqlrow.md)
* [Insert/Update](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/insertupdate.md)
* [Oracle Bulk Loader](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/orabulkloader.md)
* [PostgreSQL Bulk Loader](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/postgresbulkloader.md)
* [Synchronize After Merge](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/synchronizeaftermerge.md)
* [Table Compare](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/tablecompare.md)
* [Table Exists](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/tableexists.md)
* [Table Input](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/tableinput.md)
* [Table Output](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/tableoutput.md)
* [Teradata Bulk Loader](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/terafast.md)
* [Update](/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/update.md)

### 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/index-2/rdbms-connection.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.