Select from Table Via JDBC

Use the Select from Table via JDBC activity to read table data by executing a SQL query.

Usage

Complete the following properties to use this activity:

• SQL - Specify the following information or click the Variable Reference icon to choose a variable:

  • SQL query to execute - Enter the SQL query to be executed. The data in the database is case-sensitive.

    For example, this query selects specific columns from a table:

    SELECT column1,column2 from mytable

    This query selects the country code and the name of the country:

    SELECT code, name from country

• Persist Table - Check this check box to perform query against data that has already been summarized, this helps reducing the query time and database load.
• Read all columns from SQL Query - Check this check box to read all the columns from the SQL query.
• Columns to read - Click Add to enter the column name and then choose the Type from drop-down list, such as Boolean, Date Time, Decimal, Integer, and String.
• Number of rows to return - Enter the maximum number of rows to display (default=200).