Replicate Data Sources allows a user to easily connect multiple data sources that have an identical data structure. After the data sources have been connected the user can then add fields or tables and these changes will be incorporated across all of the data sources that have been enabled as a template data source. Replicate Data Sources is an add-on feature that is available for purchase.
Enabling Replicate Data Sources
To enable Replicate Data Sources the user must first go down to the Data Source section at the bottom of the Data tab. Right click on Data Sources and add the initial data source to be used as a template. For this example a SQL data source will be added.
Configure the data source as needed. Once the initial data source has been configured right click on the data source name and click Add SQL Server Data Source.
Configure this second data source with the needed parameters. This additional data source will then appear under the original data source in an Additional Connections folder.
When tables and fields are added to the original data source these changes will automatically be propagated to all of the data sources that are configured under the Additional Connections folder as well.
Below is the result of adding the table and fields shown above to the HAB data source with the records from the GAB data source being brought in automatically.