SharePoint 2010 + Dynamics GP + CRM + Excel Data

[toodorH]

Hi


I have a request from some of the teams at my company and I am wondering if it is possible without too much development outside of SharePoint and how it can be achieved.

Basically we want to create a customer profile for each customer the company has and this data is currently stored in Microsoft CRM, Microsoft Dynamics GP and some is in Excel spread sheets.

So I would need to pull all this data from the respective databases and the spread sheets and display it on SharePoint somehow. We are currently using PerformancePoint services to display sales data but I don't know if PerformancePoint is the right tool to use for this customer profile. To me it seems like it mostly displays numerical data while this profile would have a lot of customer information like contact details, rating, contracts etc.

So my question to you guys is...what tool is in place in SharePoint to display this kind of data? Would it be SQL Server Reporting Services? Keep in mind that the data needs to automatically update on SharePoint at some sort of interval to represent changes in database data or new additions.


Thank You!

Tudor

 

[ehaze]

SQL Reporting or SharePoint Business Connectivity Services (BCS).

BCS overview:

http://technet.microsoft.com/en-us/sharepoint/ee518675.aspx

http://msdn.microsoft.com/en-us/magazine/ee819133.aspx

http://www.sharepointed.com/