tVerticaInput
tVerticaInput Standard properties
These properties are used to configure tVerticaInput running in the Standard Job framework.
The Standard
tVerticaInput component belongs to the Databases family.
The component in this framework is available in all Talend
products.
connector. The properties related to database settings vary depending on your database
type selection. For more information about dynamic database connectors, see Dynamic database components.
Basic settings
Database |
Select a type of database from the list and click |
Property Type |
Select the way the connection details
|
![]() |
Click the icon to open a database connection wizard and store the database connection For more information about setting up and storing database connection parameters, see |
DB Version |
Select the version of the database. |
Use an existing connection |
Select this check box and in the Component List click the relevant connection component to When a Job contains the parent Job and the child Job, if you need to
For an example about how to share a database connection across Job |
Host |
The IP address or hostname of the database. |
Port |
The listening port number of the database. |
Database |
The name of the database. |
Schema |
The schema of the database. |
Username and Password |
The database user authentication data. To enter the password, click the […] button next to the |
Schema and Edit schema |
A schema is a row description. It defines the number of fields
Click Edit
schema to make changes to the schema. Note: If you
make changes, the schema automatically becomes built-in.
This This |
Table Name |
The name of the table from which data will be retrieved. |
Query Type and Query |
Specify the database query statement paying particularly attention to the
If using the dynamic schema feature, the SELECT query must |
Advanced settings
Additional JDBC Parameters |
Specify additional JDBC parameters for the This property is not available when the Use an existing connection |
Trim all the String/Char columns |
Select this check box to remove leading whitespace and trailing |
Trim column |
Select the check box for corresponding column to remove leading whitespace This property is not available when the Trim all the String/Char |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job level |
Global Variables
NB_LINE |
The number of rows processed. This is an After variable and it returns an integer. |
QUERY |
The query statement being processed. This is a Flow variable and it returns a |
ERROR_MESSAGE |
The error message generated by the component when an error occurs. This is an After |
Usage
Usage rule |
This component covers all possible SQL queries for the Vertica Talend Studio and the |
Dynamic settings |
Click the [+] button to add a row in the table The Dynamic settings table is For examples on using dynamic parameters, see Reading data from databases through context-based dynamic connections and Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |