Microsoft Azure
Here is everything you need to do before creating a Microsoft SQL Server resource and using Azure.
- Step One: Configure Networking
- Step Two: Enable Change Data Capture
Networking
Before you can create the resource, the SQL Server instance needs to be accessible by Meroxa. You may connect using SSH tunneling or whitelist Meroxa IPs.
To configure the Meroxa IPs in Azure:
- Navigate to your Microsoft SQL Server in the Azure Portal.
- Select "Firewalls and virtual networks"
- Add Meroxa IPs.
- Save the new configuration.
Enable Change Data Capture
For changes to be captured, CDC support must be enabled for the SQL Server database and every table.
See Azure Documentation for more: Enable and disable change data capture .