The tDBInput_1 component retrieves specific data from database table by executing a SQL statement.
- Double-click tDBInput_1 to open its Basic settings view.
- Make sure that PostgreSQL is selected from the Database drop-down list.
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.
- Click [...] next to Edit schema to open the schema editor.
- Add these two columns in the schema editor: column name, type String; and column address, type String.
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.
Type in the SQL statement in the Query field (
SELECT NAME,ADDRESS from usersin this scenario).The SQL statement retrieves name and address data from the database table.
Leave the other options as they are.