I have been tasked with creating a report in SharePoint to display data compiled from multiple external databases. From my experience thus far it seems that a Visual Web Part is the way to go to easily format & manipulate data for display.
However, Are there any reasons I should consider trying to sync the outside data into SharePoint Lists v/s just pulling a displaying the data to the users?
I know my team is hesitant towards connecting to outside tables via BCS, so I likely would be using the client object model to do a daily data sync, if I decide to sync the data into SharePoint.
With this type of scenario would you recommend just pulling and displaying the data in a visual web part or would you try and synch the data into Sharepoint Lists?
The report should have < 300 items and be updated at least daily. There would likely be about 8 fields.