A single data source may connect to multiple databases. For example, if you need to authenticate using Kofax TotalAgility with multiple instances (database deployments), a single data source may contain multiple databases and queries at the same time.

You can use the data source both in Admin Console > Connections, and in Studio, within a project. Please note the following when using multiple connections strings:

• Only tables with the same structure (field names and types) can be used from multiple connection data sources.

• When the data is loaded from multiple databases, the data is combined from all connections of the data source.

• To enable multiple connection strings, the Support multiple connections property must be selected in the Property Panel.