Specifying a new action for writing the database

  1. On the Documents tab, click Add.
  2. Select the scenario Write Database.
  3. Define the statement used to handle the data from the incoming document. You can use a stored procedure.
  4. In the statement, specify the [Data] placeholder to refer to the incoming data.
    The incoming XML is a single DataArea which can contain one or more document instances. For example, when using SQL Server the statement can contain: EXEC StoreItems '[Data]';
  5. Click Test to test if the statement details specified are correct.
  6. Specify a BOD XML in the dialog box that is displayed.
  7. Click OK to run the test.
    You are informed if errors occur. If the test has finished successfully, check the database whether the data is stored as expected.
  8. Select the document. If the document is not defined in ION Registry, add the required metadata.
  9. Select the Verb to be used.