E
E
Egor2014-02-04 13:56:31
SharePoint
Egor, 2014-02-04 13:56:31

Data aggregation from MS SQL in conjunction with Sharepoint

Good day!
Given: a database on MS SQL Server 2012. It contains data on persons and departments. The data from the database is available through a site deployed on Sharepoint 2010.
Question: by what means (as close as possible to the Sharepoint platform) can you implement the issuance of aggregated (summary, combining several tables. Generalized indicator) data? Something in the manner of ratings for a unit or a particular person. For example, when creating an application for some work, according to the data from the database, he pulled out people who were engaged in these works.
As options, I see a self-written web part in c #, using Analysis Services (SSAS-> OLAP cube) or Reporting Services (tables). Interested in additional options. Any third party solutions based on Sharepoint. For example, Nintex implements workflow.
I will be glad to any name related to the case. So that you can google.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question