JDBC connection¶
The JDBC connection type enables connection to a JDBC data source.
Configuring the Connection¶
- Host (required)
The host to connect to.
- Schema (required)
Specify the database name to be used in.
- Login (required)
Specify the user name to connect to.
- Password (required)
Specify the password to connect to.
- Port (optional)
Port of host to connect to. Not user in
JdbcOperator
.- Extra (optional)
Specify the extra parameters (as json dictionary) that can be used in JDBC connection. The following parameters out of the standard python parameters are supported:
conn_prefix
- Used to build the connection url inJdbcOperator
, added in front of host (conn_prefix
host
[:port
] /schema
)extra__jdbc__drv_clsname
- Full qualified Java class name of the JDBC driver. ForJdbcOperator
.extra__jdbc__drv_path
- Jar filename or sequence of filenames for the JDBC driver libs. ForJdbcOperator
.