Skip to main content

JDBC components

tJDBCClose Closes an active JDBC connection to release the occupied resources.
tJDBCColumnList Lists all column names of a given JDBC table.
tJDBCCommit Commits in one go a global transaction instead of doing that on every row or every batch and thus provides gain in performance.
tJDBCConfiguration Stores connection information and credentials to be reused by other JDBC components.
tJDBCConnection Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.
tJDBCInput Reads any database using a JDBC API connection and extracts fields based on a query.
tJDBCLookupInput Reads a database and extracts fields based on a query.
tJDBCOutput Executes the action defined on the data contained in the table, based on the flow incoming from the preceding component in the Job.
tJDBCRollback Avoids commiting part of a transaction accidentally by canceling the transaction committed in the connected database.
tJDBCRow Acts on the actual DB structure or on the data (although without handling data) using the SQLBuilder tool to write easily your SQL statements.
tJDBCSP Centralizes multiple or complex queries in a database in order to call them easily.
tJDBCTableList Lists the names of a given set of JDBC tables using a select statement based on a Where clause.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!