A Perform Database Autowrite workflow action, when executed by the workflow engine, runs one or more Workflow-based Autowrite handlers in order to move data from the submitted form into a database. Using this type of action provides direct data integration between the form and a database, while allowing the database operation to be subject to conditional form processing rules.
In order to have form data sent to a database as part of a form's workflow process instead of on every submission of a form, you must create a Perform Database Autowrite action and associate it with one of the form's workflow rules. Configuration of this type of action requires that you have already defined the Autowrite Statements that will be used in processing of the form. Second, you should define Autowrite Handlers along with the rest of the form's workflow settings. These handlers are set apart from those used for general submission of the form and are the only ones that are available for selection when defining an Autowrite workflow action.
To configure database export of form data as part of a workflow process, follow the steps below:
Create the Data Sources that will be used to connect to the database or databases to which form data will be sent.
Create the Autowrite Statements that will be used to take form data and perform database operations.
Create one or more Autowrite Handlers within the form version's Workflow settings area. Once defined, these handlers will be available for use in definition of the workflow's Autowrite actions.
Create a workflow rule for the form that determines the conditions under which the database integration should occur. For more information on creating workflow rules, see Rule Configuration.
Create a new action for the rule you defined in the step above. When prompted for action type, choose "Perform Database Autowrite." As with other action types, you may optionally enable business process logging for this action. For more information, see Rule Action Configuration.
The final screen of the Action Setup wizard will allow you to choose the destination data repository for the form data, and to select and order the Autowrite Handlers that will be executed by the workflow action.
On this screen:
Choose the Data Source that will provide the connection to the database you want the form data to be written to.
Choose the Autowrite handler or handlers that you want the action to execute from the list on the left and move them to the list on the right.
Use the Up and Down buttons to place the selected handlers into the proper order.
Click Finish to complete configuration of the workflow action.