从 sharepoint 到 sql server 的实时同步 [英] Real time sync from sharepoint to sql server

问题描述

我见过很多将 SQL Server 数据同步到 SharePoint 的解决方案，但没有将 SharePoint 列表同步到 SQL Server.

I've seen many solutions to sync SQL Server data TO SharePoint, but nothing to sync SharePoint lists to SQL Server.

有人知道解决办法吗?商用没问题.

Does anyone know of a solution? Commercial is fine.

或者，我需要编写一个 Web 部件来在多个 SharePoint 列表之间创建关系.不幸的是，有些是没有查找字段的 InfoPath 库，因此我无法使用 SPQuery CAML 连接.

Alternatively, I'll need to write a web part that creates relationships between multiple SharePoint lists. Unfortunately, Some are InfoPath libraries with no lookup fields so I can't use the SPQuery CAML joins.

我找到了 Camelot .NET 连接器，但语法似乎不支持连接和 SLAM！SharePoint 列表关联管理器可能对我有用，但只是将数据同步到 SQL Server 并从那里创建我的报告.

I've found the Camelot .NET Connector but the syntax doesn't seem to support joins, and the SLAM! SharePoint List Association Manager which may work for me but would rather just sync the data to SQL Server and create my reports from there.

大满贯！SharePoint 列表关联管理器实时执行我想要的操作.

SLAM! SharePoint List Association Manager does what I was looking for in real time.

推荐答案

您可以编写自己的 SSIS ETL 过程来从 SharePoint 中提取列表数据并将其加载到 SQL 服务器表中.Codeplex 上有一个免费的 SharePoint 列表适配器可以帮助解决这个问题.看看 SharePoint 列表源和目标

You can write your own SSIS ETL process to extract the list data from SharePoint and load it into SQL server tables. There is a free SharePoint list adapter on codeplex to assist with this. Take a look at SharePoint List Source and Destination

这篇关于从 sharepoint 到 sql server 的实时同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！