This action attempts to persist a table of data into a database table by creating a table with the proper field names and types and populating the table with the data from the input table. The table includes status information indicating the success or failure of each row. This action removes any access or constraints that were previously included in the table.
Be careful when using this action in reports that can be run by end users. In the event that multiple users run the report concurrently, a conflict may occur since both instances of the report will attempt to create and access the same table simultaneously. If it is necessary to use this action in a user facing report, consider using a property such as ${user.login} to dynamically generate a unique table name for each user.
Example: table_name_${user.login}
-
FieldDescription
-
LabelA label to identify the action. This label appears under the Action name inside the Action box. If this field is left blank, the default value is “Untitled.”
-
DescriptionA brief explanation of what this action does inside the sequence. This description appears as a tooltip when your cursor hovers over the Action box.
-
Fail MessageA message that identifies potential issues that could happen with this action. This fail message will appear if the action fails when you try generating the sequence. If this field is left blank, the default error message built into the action appears.
-
Append Data
- Select this check box to append data to an existing table. This can be useful if you need to preserve the column types of an existing table.
- Unselect this check box to have the table dropped and then recreated.
-
Data SourceSelect the data source from the drop-down list to persist the data to
-
Output DetailsSelect the check box to show individual row status
-
Table NameThe table name to persist data to