# 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.

For more technologies supported by Talend, see [Talend components](https://help.qlik.com/talend/r/en-US/7.3/components/jdbc).

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](https://help.qlik.com/talend/en-US/components/7.3/jdbc/tjdbcinput-standard-properties).

  The component in this framework is available in all Talend products.

* MapReduce: see [tJDBCInput MapReduce properties (deprecated)](https://help.qlik.com/talend/en-US/components/7.3/jdbc/tjdbcinput-mapreduce-properties-deprecated).

  The component in this framework is available in all Talend products with Big Data and Talend Data Fabric.

* Spark Batch: see [tJDBCInput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/jdbc/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 Talend products with Big Data and Talend Data Fabric.

### In this section

* [tJDBCInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/jdbc/tjdbcinput-standard-properties)
* [tJDBCInput MapReduce properties (deprecated)](https://help.qlik.com/talend/en-US/components/7.3/jdbc/tjdbcinput-mapreduce-properties-deprecated)
* [tJDBCInput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/jdbc/tjdbcinput-properties-for-apache-spark-batch)