Skip to content

Data source credentials

A Data Source Credential defines the properties for connecting to a Database Data Source.

Connection Strings for Database Data Sources are configured in the Credential Manager. Add a Data Source credential and specify the connection string:

Data Source Provider specifies the type of connection driver. Most databases support both OLE DB and ODBC providers, some databases have their own native providers. If a choice of provider is available then the first choice should be the native provider then an OLE DB provider and ODBC should be used when there is neither a native provider or an OLE DB provider. The Connection String specifies the location and access to the database. The format and requirements of the connection string depends on the target database environment.

Creating a connection string

There are three ways to create the connection string:

  1. OLE DB Wizard is the standard way of building the connection string for OLE DB providers. Use the Test Connection button to verify.
  2. Edit Connection String is a structured editor for the connection string.
  3. Edit Connection String by hand - a good resource for connections can be found here: www.connectionstrings.com

This data source credential is then specified by name anywhere in the design you want to reference it.