tJDBCInput
Reads any database using a JDBC API connection and extracts fields based on a query.
tJDBCInput 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 tJDBCInput Standard properties.
The component in this framework is available in all Talend products.
-
MapReduce: see tJDBCInput 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 tJDBCInput properties for Apache Spark Batch.
This component also allows you to connect and read data from a RDS MariaDB, a RDS PostgreSQL or a RDS SQLServer database.
The component in this framework is available in all subscription-based Talend products with Big Data and Talend Data Fabric.