Can Fivetran Sync a SQL Server Database Backed Up by Rubrik?

Question

Can Fivetran sync a SQL Server database that uses Rubrik to back up its transaction logs?

Environment

Connector: SQL Server

Answer

If you use the Change Data Capture, Change Tracking, or Fivetran Teleport Sync incremental sync methods, Rubrik doesn't affect your connection.

If you use the Binary Log Reader, Fivetran can't read transaction log backups created by Rubrik because they aren't stored in the native SQL Server format. Therefore, you must configure Fivetran to read the online transaction log. To configure the connection:

1. In Fivetran, go to your SQL Server connection page.
2. Select the Settings tab.
3. In the left menu, select Replication.
4. From the Log Type drop-down menu, select Online Transaction Log.
5. From the Log Truncator drop-down menu, select Fivetran.
   This setting helps keep the required transaction log records available. Otherwise, SQL Server may truncate required online transaction log records before we read them. If this happens, we can't fall back to the Rubrik backup logs and may initiate a historical re-sync.

6. Click Save & Test.