Multiple connection strings

A single data source may connect to multiple databases.

Open Studio > Documents Tree > Data sources. Please note the following when using multiple connection 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 into a single record.
To enable multiple connection strings, the Support multiple connections property must be selected.

Set up the data source with multiple connections

Define the following settings when using a data source with multiple connections.

Select an applicable option for the Key type parameter.
- None: The key is not defined.
- Constant: You should define a key as a constant for each connection in the Key query field.
- Query: You should define a common query in the Key query field that will be executed for each connection to define the key.
Key value type: String or Integer
For the Failure condition parameter, select one of the following options:
- Any: If any of the multiple connections fails, all data loaded is considered as failed.
- All: If all connections fail, all data loaded is considered as failed. If only one connection fails, the others are loaded anyway.

Manage multiple connections

You can manage the connections on the drop-down list that is available after you select the Support multiple connections check box, using the Add and Delete buttons.

To create a new connection, click Add, fill in the respective fields (such as Database type, Provider name, and more). Remember to Save your choices.

To edit the existing connection, select the connection on the list, edit the fields and properties, and click Save.