将 Sharepoint 数据复制到 SQL Server,然后使用该数据进行报告
我的 sharepoint 中有 104 列和 708 行的数据。这些数据基本上包含了企业的信息。高级管理层希望使用这些数据查看不同的图表,例如条形图、饼图、表格、气泡图等,没有具体数量的图表,因为他们可以根据任何内容绘制任何列。例如,在饼图中按重要性对应用程序进行分组。
为了创建这 n 个报告,我们的想法是将共享点列表传输到 sql server(使用 SSIS),然后使用 sql server reporting services (SSRS) 生成这些报告,然后使用 ASP .net 前端来包含报告。
第一个重要的问题是我们是否可以使用 SSIS 将共享点列表传输到 SQL Server。这可能吗?
I have data in sharepoint which has 104 columns and 708 rows. This data is basically contains information about enterprise. The senior management wants to view different charts by using these data such as bar chart, pie chart, tabular, bubble chart etc., There are no specific number of charts as they can plot any column against anything. For instance grouping of applications by criticality in a pie chart.
In order to create these n number of reports what we thought is to transfer the sharepoint list to sql server (using SSIS) and then use sql server reporting services (SSRS) to generate those reports and then use an ASP .net front end to contain the reports.
The very first important question is whether we can transfer sharepoint list to SQL Server using SSIS. Is this possible?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
我认为可以使用 SSIS 提取 SharePoint 数据,但我个人从未这样做过。如果您使用的是
SSIS 2008
,以下链接可能会对您有所帮助。SharePoint 列表源和目标
在 SQL Server Integration Services 中提取和加载 SharePoint 数据
I think it is possible to pull SharePoint data using SSIS but I have never done it personally. If you are using
SSIS 2008
, following links might help you.SharePoint List Source and Destination
Extracting and Loading SharePoint Data in SQL Server Integration Services
我们的商业产品“Enesys RS Data Extension”是一种报告服务扩展,可让您直接从 SharePoint 列表构建报告。
不确定首先将列表传输到 SQL Server 是否会带来很多好处。然而,如果这确实是您想要做的,标准版和企业版还包括“Enesys IS 数据扩展”,它提供了一组集成服务组件。
Our commercial product "Enesys RS Data Extension", a reporting services extension, lets your build reports directly from your SharePoint lists.
Not sure it would provide much benefits to transfer your list(s) to SQL Server first. If that's really what you would like to do however, the Standard and Enterprise editions also include "Enesys IS Data Extension" which offer a set of components for Integration Services.
您还可以使用列表中的“连接到 Access”按钮将副本放入 Access 中,然后使用 Access 导出到 ODBC 数据源将其移动到 SQL 中的表中。非常快速和容易。
You can also use the "Connect to Access" button from a list to put a copy in Access and then use Access's export to ODBC Data Source to move it into a table in SQL. Very quick and easy.