tELTVerticaMap
Builds the SQL SELECT statement using the table schema(s) provided by one or more
tELTVerticaInput components.
The three ELT Vertica components are closely related, in
terms of their operating conditions. These components should be used to handle Vertica
database table schemas to generate SQL statements, including clauses, which are to be
executed in the database output table defined.
tELTVerticaMap Standard properties
These properties are used to configure tELTVerticaMap running in the Standard Job framework.
The Standard
tELTVerticaMap component belongs to the ELT family.
The component in this framework is available in all Talend
products.
Basic settings
DB Version |
Select the version of the Vertica database being used. |
Use an existing connection |
Select this check box and in the Component List click the relevant connection component to Note: When a Job contains the parent Job and the child Job, if you
need to share an existing connection between the two levels, for example, to share the connection created by the parent Job with the child Job, you have to:
For an example about how to share a database connection |
ELT Vertica Map Editor |
The ELT Map editor allows you to define the output schema as well as |
Style link |
Select a way in which links are displayed.
|
Property Type |
Either Built-In or Repository. |
 |
Built-In: No property data stored |
 |
Repository: Select the repository |
Host |
Type in the IP address or hostname of the database. |
Port |
Type in the listening port number of the database. |
Database |
Type in the name of the database you want to use. |
Additional JDBC Parameters |
Specify additional connection properties for the database connection |
Username and Password |
Type in the database user authentication data. To enter the password, click the […] button next to the |
Advanced settings
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job |
Global Variables
Global Variables |
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
tELTVerticaMap is used along with Note:
The ELT components do not handle actual data flow but only schema |