Table Output
Description:
Text file output is a step in the Output Plugin for Process Studio Workflows. The Table output step writes information to a database table. It provides configuration options for a target table.
Configurations:
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step. Note: This name has to be unique in a single workflow. |
| Connection | Specify the database connection to which the data is to be written. Edit: Click to edit the database connection. **New:**Click to create a new database connection. **Wizard:**Click to create a new database connection using the Wizard. | |
| Target Schema | Specify the name of the database schema. **Browse:**Click to browse and select a database schema. | |
| Target Table | Specify the name of the table to write data. **Browse:**Click to browse and select a table from the schema. | |
| Commit size | Specify the batch size for commit. Specifying a commit size may change the performance Note: Transactions are not supported on all database platforms. | |
| Truncate table | Enable checkbox to truncate the table before inserting the first row into the table. | |
| Ignore insert errors | Enable checkbox to ignore all insert errors A maximum of 20 warnings are logged. This option is not applicable for batch inserts. | |
| Specify database fields | Enable checkbox to specify the fields in the Database fields tab. Otherwise all fields are inserted by default. | |
| Main options Tab | ||
| 1 | Partition data over tables | Enable checkbox to split the data over multiple tables based on the value of the date field specified in the Partitioning field below. When this option is selected, data is inserted into tables with name format: '<target-table>_<date-format>'. These tables must be created manually before running the transformation in order for data to be inserted in these tables. |
| 2 | Partitioning field | Select the date field to use to determine how to split values across multiple tables. This value is used to generate a dated table name into which data is inserted. |
| 3 | Partition data per month | Specify the date format used in the table name when partitioning the table: 'yyyyMM' for 'per month' |
| 4 | Partition data per day | Specify the date format used in the table name when partitioning the table: 'yyyyMMdd' for 'per day'. |
| 5 | Use batch update for inserts | Enable checkbox for batch inserts. This option is enabled by default. The batch mode is only used when the following conditions are met: - The Use batch update for inserts check box is selected - The Commit Size option is greater than 0 - The Return auto-generated key option is cleared - The workflow is not enabled to use unique connections (Workflow properties > Misc Tab > Make the workflow database transactional) - The database type supports batch updates - There are limiting factors depending on the database type and further step options. |
| 6 | Is the name of the table defined in a field? | Enable checkbox to specify the name of the target table in the Field below. This option allows you to store data from each row in a different table, based on the value of the Field that contains name of table. |
| 7 | Field that contains name of table | Select a field name from the input stream to use for the name of the table when the option "Is the name of the table defined in a field?" is selected. |
| 8 | Store the table name field | Enable checkbox to store the table name in the output. When using this option, the table must contain a column with the name you defined in the Field that contains name of table. |
| 9 | Return auto-generated key | Enable checkbox to return the key that was generated by inserting a row into the table in the field ‘Name of auto- generated key field’, below. |
| 10 | Specify Name of the auto- generated key | Enable checkbox to store the key that was generated by inserting a row into the table; in the field below ‘Name of the auto-generated key column’. |
| 11 | Name of the auto-generated key column | Specify an output field that stores the name of auto-generated key column. |
| 12 | Name of auto-generated key field | Specify an output field that stores the auto-generated key. |
| Database Fields Tab | ||
| Fields to insert: | Tabular List: | |
| 1 | Table Field | Specify the name of the database column to insert data. |
| 2 | Stream Field | Specify the stream field being read from the source/input steps and inserted into the database. |
| 3 | Get fields (button) | Click to import the fields from the data source into the Database fields table. The Specify database fields option in the general area must be selected for this to be active. |
| 4 | Enter field mapping (button) | Click to open the Enter Mapping window. The Specify database fields option in the general area must be selected for this tool to be active. |