Setting up the tDBInput_1 component - Cloud - 8.0


Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Talend Studio
Data Governance > Third-party systems > Database components (Integration) > PostgreSQL components
Data Quality and Preparation > Third-party systems > Database components (Integration) > PostgreSQL components
Design and Development > Third-party systems > Database components (Integration) > PostgreSQL components
Last publication date
The tDBInput_1 component retrieves specific data from database table by executing a SQL statement.


  1. Double-click tDBInput_1 to open its Basic settings view.
  2. Make sure that PostgreSQL is selected from the Database drop-down list.
  3. Select the Use an existing connection option and select tDBConnection_1 from the Component List drop-down list.
    This step enables the tDBInput_1 component to reuse the database connection established by the tDBConnection_1 component.
  4. Click [...] next to Edit schema to open the schema editor.
  5. Add these two columns in the schema editor: column name, type String; and column address, type String.
  6. Type in the name of the database table to retrieve data from in the Table field (users in this example).
    You can also select an existing database table by clicking the [...] button next to the Table field.
  7. Type in the SQL statement in the Query field (SELECT NAME,ADDRESS from users in this scenario).
    The SQL statement retrieves name and address data from the database table.
  8. Leave the other options as they are.