Self-Hosted Replica Integration

If you're considering hosting your own Azure replica for an On-Premise integration with Mosaic, here are the steps to guide you:

Step 1: Replicate Required Database Tables:

Please refer to the Required Tables in the following guides to be included in your Azure Replica:

Should you need to filter your data, please ensure it's done as you replicate from SQL Server to Azure. See the Microsoft Filter Published Data guide for more details.

For an overview of Mosaic's typical replication process and requirements, please see SQL Server Integration Requirements.

Step 2: Whitelist Mosaic Server IPs:

To enable Mosaic's servers to fetch data from your self-hosted replica, ensure uninterrupted connectivity by adding firewall rules on the Azure SQL Server:

Go to SQL Server > Security > Networking > Firewall rules.
Select + Add a firewall rule.
Enter Mosaic's public internet IP addresses, which the Integrations Team will provide, to grant them access to your resources.

By following these guidelines, you can ensure a seamless integration of your self-hosted replica with Mosaic.

Step 3: Sharing Azure SQL Server Connection Credentials:

Once you've replicated the required tables from your SQL Server to your Azure replica, share the following details with Mosaic to establish the integration:

Azure SQL Server Name:
- Locate this under SQL Server > Overview > Server name in your Azure portal.
Azure SQL Database Name:
- This is found in the list of SQL databases under SQL Server > Overview > Available Resources > SQL database.
Connection Credentials:
- Provide the username and password for a SQL Server user with read-only access to the database.