Database Connections

Database specific functions such as DB Read & Write and Lookups requires the means to connect to a target database, which is provided though a connection string.

A connection string provides the details necessary to find and authenticate with the database.

Whilst the DB Read, DB Write transforms and Lookups all have the ability to define connection strings in each separate function, database connection strings can be consolidated using this option so that multiple integration & lookups can easily re-use the same database connection.

Setup > Database COnnections

ID

A unique Id for the specified Database connection.

Description

A useful description for this connection.

Connection String

The connection string to find and authenticate the database.

The connection string must be either ODBC or OleDB format (Native .Net connection strings are not valid).

A good resource for constructing connection strings is: http://www.connectionstrings.com/

Test

Click to test the connection string is valid and working.