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.

Caution

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}

  • Field

    Description
  • Label

    A 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.”
  • Description

    A 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 Message

    A 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 Source

    Select the data source from the drop-down list to persist the data to
  • Output Details

    Select the check box to show individual row status
  • Table Name

    The table name to persist data to