Skip to main content

DB Generic components

tDBBulkExec Offers gains in performance while executing the Insert operations on a database.
tDBCDC (deprecated) Extracts only the changes made to the source operational data and makes them available to the target system(s) using database CDC views.
tDBCDCOutput (deprecated) Synchronizes data changes in database of the selected database type in the CDC mode.
tDBClose Closes the transaction committed in a connected database.
tDBColumnList Iterates on all columns of a given database table and lists column names.
tDBCommit Validates the data processed through the Job into the connected database.
tDBConnection Opens a connection to a database to be reused in the subsequent subJob or subJobs.
tDBInput Extracts data from a database.
tDBInvalidRows Checks database rows against specific Data Quality patterns (regular expression) or Data Quality rules (business rule).
tDBLastInsertId Obtains the primary key value of the record that was last inserted in a database table by a user.
tDBOutput Writes, updates, makes changes or suppresses entries in a database.
tDBOutputBulk Writes a file with columns based on the defined delimiter and the standards of the selected database type.
tDBOutputBulkExec Executes the Insert action in a database.
tDBRollback Cancels the transaction commit in a connected database to avoid committing part of a transaction involuntarily.
tDBRow Executes the stated SQL query onto a database.
tDBSCD Reflects and tracks changes in a dedicated database SCD table.
tDBSCDELT Reflects and tracks changes in a dedicated SCD table through SQL queries.
tDBSP Calls a database stored procedure.
tDBTableList Lists the names of specified database tables using a SELECT statement based on a WHERE clause.
tDBValidRows Checks database rows against Data Quality patterns (regular expression).
tParseRecordSet Parses a recordset rather than individual records from a table.

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!