Authenticating Connections

The adapter supports username/password-based authentication method.

JDBC adapter as a source

The JDBC adapter as a source supports:

• Reading rows from a table.
• Reading rows for a custom database query statement.
• Reading values and rows from a stored procedure.
• Running custom static SQL statements before and after reading rows.

JDBC adapter as a target

The JDBC adapter as a target supports:

• Writing rows to a table, in insert, update and delete modes.
• Writing rows using a custom data manipulation language (DML) statement.
• Invoking stored procedures with passing arguments from input data.
• Running custom static SQL statements before and after writing rows.
• Truncating table before writing rows.