Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question