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 (deprecated).

  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.