tAccessInput
Reads a database and extracts fields based on a query.
tAccessInput executes a DB query with a strictly defined statement
which must correspond to the schema definition. Then it passes on the field list to the
next component via a Row > Main
connection.
tAccessInput Standard properties
These properties are used to configure tAccessInput running in the Standard Job framework.
The Standard
tAccessInput component belongs to the Databases family.
The component in this framework is generally available.
Basic settings
Property type |
Either Built-in or |
|
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 |
Use an existing connection |
Select this check box and in the Component 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 across Job levels, see |
DB Version |
Select the version of Access that you are using. |
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 (columns) to This component offers the This dynamic schema |
|
Built-in: The schema is created |
|
Repository: The schema already |
Click Edit schema to make changes to the schema.
|
|
Query type and Query |
Enter your DB query paying particularly attention to properly
If using the dynamic schema |
Advanced settings
Additional JDBC parameters |
Specify additional connection properties for the DB connection you |
tStat |
Select this check box to collect log data at the component |
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 |
Global Variables
Global Variables |
NB_LINE: the number of rows processed. This is an After
QUERY: the query statement being processed. This is a Flow
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 |
This component offers the flexibility benefit of the DB query and |
Dynamic settings |
Click the [+] button to add a The Dynamic settings table is For examples on using dynamic parameters, see Scenario: Reading data from databases through context-based dynamic connections and Scenario: Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |
Limitation |
If you are using an ODBC driver, you need to work with Java 7, and make sure that your JVM When working with Java 8, this component supports only the General collation mode of |
Related scenarios
For related topics, see:
Related topic in description of tContextLoad.