Skip to main content Skip to complementary content

Setting up the tDBInput_1 component

The tDBInput_1 component retrieves specific data from database table by executing a SQL statement.

Procedure

  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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here