ArcoreSyncBridge icon

ArcoreSyncBridge

ProductionDeveloper Tooling

Middleware service that synchronizes Postgres data with SharePoint/Teams via Microsoft Graph. ArcoreSyncBridge provisions lists from schemas, runs one-way and two-way sync with idempotent ledgers, supports sharding/moves, ingests CDC, and surfaces drift detection, run history, and ops dashboards.

Key Features

  • Schema introspection and SharePoint list/column provisioning via Graph
  • One-way and two-way sync with idempotent ledger and cursor strategies
  • CDC ingestion with LSN checkpoints, pause/resume, and backpressure controls
  • Conflict resolution and loop prevention; direction toggles per mapping
  • Sharding policies and move logic; drift detection reports
  • Run history/metrics dashboards; reset cursor/rebind workflows; replication slot ops

Usage Example

bash
# Create a sync definition
curl -H "Authorization: Bearer $TOKEN" -X POST https://syncbridge.internal/api/sync-definitions -d @definition.json

# Run a push + CDC sync
curl -H "Authorization: Bearer $TOKEN" -X POST https://syncbridge.internal/api/runs -d '{"sync_def_id":"abc"}'

# Fetch drift report
curl -H "Authorization: Bearer $TOKEN" https://syncbridge.internal/api/runs/123/drift

Tech Stack

FastAPIPostgreSQLRedis/worker queuesMicrosoft Graph (SharePoint/Teams)S3/MinIO

Authentication

  • **Header:** `Authorization: Bearer <token>`
  • **Scopes:** Manage connections/definitions, trigger runs, read runs/drift, manage replication slots.

Compliance & Security

Compliance

  • Ledgered, idempotent runs with audit trails and run history
  • Scoped credentials for Postgres and Graph; replication slot ops endpoints
  • Drift detection and rebind/reset workflows to recover safely
  • Backpressure/pause controls for CDC pipelines

Security

  • TLS 1.3
  • AES-256 encryption

Related Products