# Dynamic database components

Talend provides a number of database components that allow you to change dynamically the type of database you want to work on. These components are available in the Database Common group under the Databases family of the Palette for standard data integration Jobs.

Each of these components has only one property, the Database list, on its Basic settings view for you to select the type of database of your interest.

For more information on these dynamic database components, see:

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