# Vertica components

| [tVerticaBulkExec](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticabulkexec) | Loads data into a Vertica database table from a local file using the Vertica COPY<br>SQL statement. |
| --- | --- |
| [tVerticaClose](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticaclose) | Closes an active connection to a Vertica database. |
| [tVerticaCommit](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticacommit) | Commits in one go a global transaction using a unique connection instead of doing<br>that on every row or every batch and thus provides gain in performance. |
| [tVerticaConnection](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticaconnection) | Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs. |
| [tVerticaInput](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticainput) | Retrieves data from a Vertica database table based on a SQL query. |
| [tVerticaOutput](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticaoutput) | Inserts, updates, deletes, or copies data from an incoming flow into a Vertica<br>database table. |
| [tVerticaOutputBulk](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticaoutputbulk) | Prepares a file to be used by the tVerticaBulkExec component to<br>feed a Vertica database. |
| [tVerticaOutputBulkExec](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticaoutputbulkexec) | Receives data from a preceding component, writes data into a local file, and<br>loads data into a Vertica database from the file using the Vertica COPY SQL<br>statement. |
| [tVerticaRollback](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticarollback) | Cancels the transaction commit in the Vertica database. |
| [tVerticaRow](https://help.qlik.com/talend/en-US/components/8.0/vertica/tverticarow) | Executes a Vertica SQL statement against a database table. |