Reads an Oracle database and extracts fields based on a query.
tOracleInput executes a database query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component via a Main row link.
For more technologies supported by Talend, see Talend components.
Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks:
Standard: see tOracleInput Standard properties.
The component in this framework is available in all Talend products.
Spark Batch: see tOracleInput properties for Apache Spark Batch.
This component also allows you to connect and read data from a RDS Oracle database.
The component in this framework is available in all subscription-based Talend products with Big Data and Talend Data Fabric.