On-Premises Database Replication (DMS)

Availability

On-Premises Database Replication is available on the Enterprise plan, or as a paid add-on for other tiers.

Step 1: Identify Your Source Database

1. Determine which on-premises database you need to replicate:
   • SQL Server
   • PostgreSQL
   • MySQL
   • Oracle
   • Other supported databases
2. Note the database version, size, and network location

Step 2: Set Up Network Connectivity

1. A VPN connection between your network and BEEM is typically required (see the VPN article)
2. Alternatively, a Database Bridge or Cloud Connect can provide access
3. Ensure the source database allows connections from the BEEM environment
4. Work with your network team to open the required ports

Step 3: Contact BEEM for Configuration

1. Contact support@beemdata.com or your BEEM account manager
2. Provide:
   • Source database type and version
   • Tables or schemas to replicate
   • Network connectivity method (VPN, Database Bridge, etc.)
   • Desired replication frequency
3. The BEEM team configures the DMS replication task

Step 4: Validate the Replication

1. Monitor the initial full load in the Monitor section
2. Verify data in the Datalake once the initial sync completes
3. Check that ongoing change data capture (CDC) is working for near-real-time updates

How It Works

• Full Load: Initial complete copy of selected tables
• Change Data Capture (CDC): Ongoing replication of inserts, updates, and deletes
• Data lands in your dedicated BEEM warehouse, ready for transformation in the Warehouse
• Automated monitoring detects and alerts on replication issues

Key Details

• Requires network connectivity (VPN, Database Bridge, or Cloud Connect)
• Supports most major relational databases
• DMS consumption is tracked as part of your DPU usage
• The BEEM team manages the replication infrastructure