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