# DB Generic components

| [tDBCDC](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbcdc) | Extracts only the changes made to the source operational data and makes them<br>available to the target system(s) using database CDC views. |
| --- | --- |
| [tDBCDCOutput](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbcdcoutput) | Synchronizes data changes in database of the selected database type in the CDC<br>mode. |
| [tDBInvalidRows](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbinvalidrows) | Checks database rows against specific Data Quality patterns (regular expression)<br>or Data Quality rules (business rule). |
| [tDBValidRows](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbvalidrows) | Checks database rows against Data Quality patterns (regular<br>expression). |
| [tDBBulkExec](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbbulkexec) | Offers gains in performance while executing the Insert operations on a<br>database. |
| [tDBClose](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbclose) | Closes the transaction committed in a connected database. |
| [tDBColumnList](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbcolumnlist) | Iterates on all columns of a given database table and lists column<br>names. |
| [tDBCommit](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbcommit) | Validates the data processed through the Job into the connected<br>database. |
| [tDBConnection](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbconnection) | Opens a connection to a database to be reused in the subsequent subJob or<br>subJobs. |
| [tDBInput](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbinput) | Extracts data from a database. |
| [tDBLastInsertId](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdblastinsertid) | Obtains the primary key value of the record that was last inserted in a database<br>table by a user. |
| [tDBOutput](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdboutput) | Writes, updates, makes changes or suppresses entries in a database. |
| [tDBOutputBulk](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdboutputbulk) | Writes a file with columns based on the defined delimiter and the standards of<br>the selected database type. |
| [tDBOutputBulkExec](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdboutputbulkexec) | Executes the Insert action in a database. |
| [tDBRollback](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbrollback) | Cancels the transaction commit in a connected database to avoid committing part<br>of a transaction involuntarily. |
| [tDBRow](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbrow) | Executes the stated SQL query onto a database. |
| [tDBSCD](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbscd) | Reflects and tracks changes in a dedicated database SCD table. |
| [tDBSCDELT](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbscdelt) | Reflects and tracks changes in a dedicated SCD table through SQL<br>queries. |
| [tDBSP](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbsp) | Calls a database stored procedure. |
| [tDBTableList](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tdbtablelist) | Lists the names of specified database tables using a SELECT statement based on a<br>WHERE clause. |
| [tParseRecordSet](https://help.qlik.com/talend/r/en-US/7.2/components/db-generic/tparserecordset) | Parses a recordset rather than individual records from a table. |