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.
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 tJDBCInput Standard properties.
The component in this framework is available in all Talend products.
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.