Return
-
Title
Is it possible for a single quick connect job to connect to multiple databases? -
Description
Is it possible to configure a single Quick Connect workflow to read data from multiple databases?
-
Cause
When connecting to a SQL Server database, only one database can be selected under connection settings.
-
Resolution
- Create a SQL Server view to present data from the required databases and tables
- Select the view as a table to read data from under SQL Server Connector connection settings
Note: a view can also be used to write data to multiple target databases, if required.