tOracleInput
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.
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.
-
MapReduce: see tOracleInput MapReduce properties.
The component in this framework is available in all subscription-based Talend products with Big Data and Talend Data Fabric.
-
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.