Component family |
Databases/MaxDB |
|
Function |
tMaxDBInput reads a database and |
|
Purpose |
tMaxDBInput executes a DB query |
|
Basic settings |
Property type |
Either Built-in or Since version 5.6, both the Built-In mode and the Repository mode are |
|
|
Built-in: No property data stored |
|
|
Repository: Select the repository |
|
Click this icon to open a database connection wizard and store the For more information about setting up and storing database |
|
|
Host |
Database server IP address |
|
Port |
Listening port number of DB server. |
|
Database |
Name of the database. |
|
Username and |
DB user authentication data. To enter the password, click the […] button next to the |
|
Schema and Edit |
A schema is a row description. It defines the number of fields to be processed and passed on Since version 5.6, both the Built-In mode and the Repository mode are This component offers the advantage of the dynamic schema feature. This allows you to This dynamic schema feature is designed for the purpose of retrieving unknown columns |
|
|
Built-in: The schema is created |
|
|
Repository: The schema already |
Click Edit schema to make changes to the schema. If the
|
||
|
Table name |
Type in the table name. |
|
Query type and |
Enter your DB query paying particularly attention to properly Warning
If using the dynamic schema feature, |
|
Guess Query |
Click the Guess Query button to |
|
Guess schema |
Click the Guess schema button to |
Advanced settings |
Trim all the String/Char columns |
Select this check box to remove leading and trailing whitespace |
|
Trim column |
Remove leading and trailing whitespace from defined |
|
tStat |
Select this check box to collect log data at the component |
Global Variables |
NB_LINE: the number of rows processed. This is an After
QUERY: the SQL query statement being processed. This is a 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 Talend Studio |
|
Usage |
This component offers the flexibility of the DB query and covers |
|
Log4j |
The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User 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. |
|
Limitation |
This component requires installation of its related jar files. For more information about the |
For a related scenario, see: