Table Input
Description
Table Input reads data from a relational database by executing a SQL query and feeding the results into the workflow as rows. Use this step when your workflow needs to pull data from any supported database — such as extracting customer records, running summary queries, or reading configuration tables. It supports variable substitution in SQL statements, lazy conversion for improved performance, and the ability to receive parameters from a previous step to build dynamic queries.
Configurations
| Field Name | Description |
|---|---|
| Step name | Specify the name of this step in the workflow workspace. Step name must be unique. |
| Content Tab: | |
| Step Name | Specify the name of this step in the workflow workspace. Step name must be unique. |
| Connection | Select existing Database connection for reading data. |
| Button: Edit | Click to edit database connection properties. |
| Button: New | Click this button to create and configure settings of a new database connection. |
| Button: Wizard | Click to create a new wizard-based database connection. |
| SQL | Specify SQL statement for reading information from a database connection. |
| Button:Get SQL select statement | Click Get SQL select statement... to browse tables and automatically generate a basic select statement. |
| Enable lazy conversion | If checked, unnecessary data type conversions are avoided resulting in performance improvements. |
| Replace variables in script? | If checked, it allows performing testing with or without performing variable substitutions. |
| Insert data from step | Select a field in the input stream from which information is expected to come. |
| Execute for each row? | If checked, it performs data insertion for each individual row. |
| Limit size | Specify the number of lines to read from the database. Zero (0) means read all lines. |