SPSync VS CData MySQL Cloud Driver

• Sync SharePoint lists to SQL Server and Azure SQL
  Replicate SharePoint Online lists into SQL Server and Azure SQL on a schedule, so reports, apps and analysts query ordinary tables instead of SharePoint.
• SharePoint lists to PostgreSQL, MySQL and Oracle
  The same normalised tables in PostgreSQL, MySQL, MariaDB, Oracle, SQLite, Supabase and Neon, or in Dataverse for Power Apps.
• SharePoint to data warehouses and lakehouses
  Feed BigQuery, Databricks, ClickHouse, DuckDB, MotherDuck, Delta Lake, Apache Iceberg and Azure Data Lake Storage, with Parquet export to Amazon S3 and Azure Blob.
• SharePoint to search and vector databases
  Index list items in Azure AI Search, Elasticsearch, OpenSearch, PostgreSQL with pgvector, LanceDB, Qdrant and Weaviate, kept current on every sync.
• Incremental delta sync
  After one full load, SPSync reads only new, changed and deleted items through Microsoft Graph delta queries, within the tenant’s throttling budget.
• No 5,000-item list view threshold
  Large lists replicate in full. SPSync reads past the 5,000-item list view threshold, so lists with tens of thousands of items report as easily as small ones.
• Power BI reporting views
  Generated views for Power BI DirectQuery in SQL Server, PostgreSQL, MySQL, Oracle, BigQuery, Databricks and more, ending slow refreshes on SharePoint lists.
• Lookup columns as foreign keys
  Lookups become keys, multi-choice and people columns become child tables, and users go into one table, so joining lists is one simple query in your database or warehouse.
• Read-only SharePoint access
  SPSync never writes to SharePoint. Replication is one-way, from SharePoint Online to your destination, which makes the security review short.
• Sites.Selected permissions
  Unattended sync uses application permissions scoped with Sites.Selected, so an admin grants access to named sites only, never the whole tenant.
• Combine lists from multiple sites
  Merge the same list from many SharePoint sites into one table, with the source site on every row, for organisation-wide reporting.
• Deleted items kept (soft deletes)
  Items deleted in SharePoint stay in the destination, flagged with the time they were deleted, so audit and history questions can still be answered.
• Automatic schema changes
  When someone adds a column to a SharePoint list, SPSync adds it in the destination on the next run. No pipeline to edit.
• Reconcile and outage recovery
  A reconcile, weekly by default and configurable, compares SharePoint with the destination and corrects drift: a quality check and recovery after an outage.
• A governed copy for AI agents
  AI agents, assistants and text-to-SQL tools query a current copy in your own database, holding no SharePoint or Graph permission of their own.
• Vector embeddings for RAG
  Writes embeddings to pgvector and Azure AI Search on each sync, re-embedding only rows whose text changed, so retrieval indexes stay current.
• Document library metadata
  Replicates document library metadata (file names, folders, content types and custom columns) as a queryable catalogue for governance and retention.
• Command line and YAML for CI
  A YAML-driven command line for macOS, Windows and Linux, with exit codes for schedulers and CI pipelines and secrets kept in environment variables.
• Desktop app for Mac and Windows
  A guided desktop app for Apple Silicon Macs and Windows 10 and 11 that keeps syncing in the background, with per-run metrics for every list.
• Admin permissions pack
  The first-run permissions wizard produces a one-page pack telling the tenant admin exactly what to grant, for which sites, and why.
• Sync a whole site or pick lists
  Tick individual lists and libraries, name a list once to select it on every site, or sync a whole site so new lists are included automatically.
• Pre-flight checks before the first run
  spsync doctor checks SharePoint permissions, connectivity and the destination before anything runs, so problems show up in seconds, not in a failed overnight job.

No features have been listed yet.

No analysis of SPSync yet.

Sync SharePoint List to SQL Server on a Schedule

No CData MySQL Cloud Driver videos yet. You could help us improve this page by suggesting one.