tEXARow – Docs for ESB 5.x

Component family

Databases/EXA

Function

The tEXARow component is specific
to this type of database. It executes SQL queries on specified
databases. The Row suffix indicates that it is used to channel a
flow in a Job although it does not produce any output data.

Purpose

Depending on the nature of the query and the database, tEXARow acts on the actual structure of
the database, or indeed the data, although without modifying
them.

Basic settings

Property type

Either Built-in or
Repository.

Since version 5.6, both the Built-In mode and the Repository mode are
available in any of the Talend solutions.

Built-in: No properties stored
centrally.

Repository: Select the repository
file in which the properties are stored. The fields that follow are
completed automatically using the data retrieved.

Host

Database server IP address.

Port

Listening port number of the DB server.

Schema name

Enter the schema name.

Username and
Password

User authentication information.

To enter the password, click the […] button next to the
password field, and then in the pop-up dialog box enter the password between double quotes
and click OK to save the settings.

Schema and Edit
Schema

A schema is a row description. It defines the number of fields to be processed and passed on
to the next component. The schema is either Built-In or
stored remotely in the Repository.

Since version 5.6, both the Built-In mode and the Repository mode are
available in any of the Talend solutions.

Built-In: You create and store the schema locally for this
component only. Related topic: see Talend Studio
User Guide.

Repository: You have already created the schema and
stored it in the Repository. You can reuse it in various projects and Job designs. Related
topic: see Talend Studio User Guide.

Click Edit schema to make changes to the schema. If the
current schema is of the Repository type, three options are
available:

Table Name

Name of the table to be processed.

Query type

Either Built-in or
Repository.

Since version 5.6, both the Built-In mode and the Repository mode are
available in any of the Talend solutions.

Built-in: Enter the query
manually or with the help of the SQLBuilder.

Repository: Select the
appropriate query from the Repository. The Query field is then completed
automatically.

Guess Query

Click the Guess Query button to
generate the query that corresponds to the table schema in the
Query field.

Query

Enter your query, taking care to ensure that the field order
matches that defined in the schema.

Die on error

This check box is selected by default. Clear the check box to skip
the row on error and complete the process for error-free rows. If
needed, you can retrieve the rows on error via a Row > Rejects link.

Advanced settings

Additional JDBC parameters

Specify additional connection properties for the DB connection you
are creating.

Propagate QUERY’s recordset

Select this check box to insert the query results in one of the
flow columns. Select the particular column from the use column list.

Commit every

Number of rows to be included in the batch before the data is
written. This option guarantees the quality of the transaction
(although there is no rollback option) and improves
performance.

tStatCatcher Statistics

Select this check box to collect the log data at a component
level.

Global Variables

QUERY: the SQL query statement being processed. This is a
Flow variable and it returns a string.

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio
User Guide.

Usage

This component offers query flexibility as it covers all possible
SQL query requirements.

Log4j

The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User
Guide.

For more information on the log4j logging levels, see the Apache documentation at http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/Level.html.

Due to license incompatibility, one or more JARs required to use this component are not
provided. You can install the missing JARs for this particular component by clicking the
Install button on the Component tab view. You can also find out and add all missing JARs easily on
the Modules tab in the Integration perspective
of your studio. For details, see https://help.talend.com/display/KB/How+to+install+external+modules+in+the+Talend+products
or the section describing how to configure the Studio in the Talend Installation and Upgrade
Guide.