Write Data Store actions

Write Data Store actions read data from a Table dataset and write it to a Data Store in the current workspace.

Action property	Description
Data Store	A Data Store parameter or dataset referring to an existing Data Store in the current workspace, or to a new Data Store which will be created if the action is successful.
Delete Table	A Boolean parameter that determines whether the table specified in the Table Name parameter should be deleted from the Data Store. If this parameter is set to true and the Table Name and Data Store parameters have been set, the specified table will be deleted from the Data Store. If the Delete Table parameter is set to true, the Source parameter for the Write Data Store action should be left unset.
Overwrite	A Boolean parameter that determines whether the specified table in the Data Store will be overwritten with the source data (true) or appended to with the source data (false). If you don’t set this property, the action uses false as the default value.
Source	A Table dataset to be written to the specified table in the specified Data Store. If the table already exists in the Data Store and the Overwrite parameter is set to false, the columns in the Source table must match the columns in the Data Store table.
Table Name	A String parameter or dataset specifying the name to be associated with the Source table when it is written to the Data Store. The dataset or parameter value should not contain any spaces. If the Source table was obtained from the results of the Read SAP Table or Read Large SAP Table action, this property would normally be set the Read SAP Table or Read Large SAP Table action’s Table Name parameter. If the Data Store property has been set, you may enter a new value or select one of the Data Store’s existing tables.

Example

If the Data Store parameter specifies a new Data Store, you will need to refresh the workspace’s ‘Data Stores’ hierarchy to display the Data Store after the action has completed. To refresh the hierarchy, choose Reload Children from the Data Stores folder’s context menu.

Write Data Store actions support the use of the Define Action Parameters Wizard, which allows new output properties of type Table to be created. This output table is not populated by the Write Data Store action; however, it may be used to influence the flow of execution of workflow actions.

To examine the details for a Write Data Store action, double-click the action node, or select View Details from the node’s context menu. The Details screen displays the number of rows read from the Source table and the time taken for the action to complete.