Database Activity

The Database Activity allows you to directly interact with a SQLServer or Access database from a Workflow. You simply set the connection string, and the query (which can contain tokens).  The tokens can be Workflow variables, Workflow messages, Workflow message properties (in the syntax MessageName.PropertyName) or XPath, the XPath relating to the optional ParameterMessage property.

Data can optionally be returned as an Xml message, and on specifying the root and record tag names BlueIntegrator will automatically generate the schema for you.  The message will be returned in the message specified by the ReturnMessage property.

For further details please see the Database Send Transport, which uses a similar model.