Connection Data Type v1

A Connection Property supplies a Node with the endpoint, credentials, and related configuration it requires to access another system.

A Workflow can use a saved Connection key or, for supported designs, a dynamically supplied XML Connection value. See Repeating an integration with Dynamic Connections for this pattern.

A dynamic Connection can supply either the saved Connection key or an XML document containing its Properties. A SQL Query Connection can use this XML:

<root>
    <Server>(local)</Server>
    <Database>database</Database>
    <UserId>sa</UserId>
    <Password>password</Password>
    <UseWinAuth>0</UseWinAuth>
    <DropPointId>00000000-0000-0000-0000-000000000000</DropPointId>
</root>

An XML Connection value cannot supply some additional Properties, including Timeout and DropPoint Offline Timeout. To retain them, create a stub saved Connection with those Properties and assign it to the Node. The dynamically supplied XML then replaces the supported runtime values without discarding the configured timeouts.

See Connection for identity and Environment values.