CRC-based incremental sync - changes to data are detected and sync is done
Date-partitioned sync - Syncs data based on date partitions to optimize performance and reduce load
BI Table | Sync Method | Sync Frequency | Standard Run (Sync - based on the service schedule - for ex. once in 30 mins) | Extended Daily Run (Once in 24hrs sync) |
| SurburbBi | Daily Full Sync | Once daily | NA | Full Data |
CustomerBi | CRC-based incremental sync | Based on Service schedule | Full Data & CRC checked | NA |
AgentBi | CRC-based incremental sync | Based on Service schedule | Full Data & CRC checked | NA |
TicketBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 14 days of data (per run) | Last 90 days of data (once daily if previous run over 1 day already) |
UserBi | CRC-based incremental sync | Based on Service Schedule | Full Data & CRC checked (for Staff, Customer, Agent) | NA |
ConsignmentBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 7 days of data (per run) | Last 6 months of data (once daily if previous run over 1 day already) |
ConsignmentCustomerPriceBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 7 days of data (per run) | Last 6 months of data (once daily if previous run over 1 day already) |
ConsignmentAgentPriceBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 7 days of data (per run) | Last 90 days of data (once daily if previous run over 1 day already) |
CustomerInvoiceBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 14 days of data (per run) | Last 90 days of data (once daily if previous run over 1 day already) |
AgentInvoiceBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 14 days of data (per run) | Last 90 days of data (once daily if previous run over 1 day already) |
ConsignmentReportableCostBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 14 days of data (per run) | Last 90 days of data (once daily if previous run over 1 day already) |
ScanBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 7 days of data (per run) | Last 30 days of data (once daily if previous run over 1 day already) |
ManifestCustomerBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 3 days of data (per run) | Last 7 days of data (once daily if previous run over 1 day already) |
ManifestAgentBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 3 days of data (per run) | Last 7 days of data (once daily if previous run over 1 day already) |
ManifestRunsheetBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 3 days of data (per run) | Last 7 days of data (once daily if previous run over 1 day already) |
DriverDailySummaryBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 3 days of data (per run) | NA |
QuoteBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 7 days of data (per run) | Last 6 months of data (once daily if previous run over 1 day already) |
DriverDailySummaryBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 3 days of data (per run) | NA |
EquipmentTypeBi | CRC-based incremental sync | Based on Service schedule | Full Data & CRC checked | NA |
EquipmentTransactionBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 3 days of data (per run) | Last 30 days of data (once daily if previous run over 1 day already) |
ConsignmentCommentBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 3 days of data (per run) | Last 30 days of data (once daily if previous run over 1 day already) |
ManifestLinehaulBi | CRC-based + Date-partitioned incremental sync | Based on Service schedule + Per-day looped retrigger | Last 3 days of data (per run) | Last 7 days of data (once daily if previous run over 1 day already) |
VehicleBi | CRC-based incremental sync | Based on Service schedule | Full Data | NA |
| VehicleMaintenanceBi | CRC-based incremental sync | Based on Service schedule | Full Data | NA |
VehicleMaintenancePartsBi | CRC-based incremental sync | Based on Service schedule | Full Data | NA |
VehicleAlertsBi | CRC-based incremental sync | Based on Service schedule | Full Data | NA |
ConsignmentPodBi | CRC-based incremental sync | Based on Service schedule | Last 7 days of data (per run) | Last 30 days of data (once daily if previous run over 1 day already) |