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 WebPart is the way to go to easily format & manipulate data for display.
However, Are there any reasons I should consider trying to synch the outside data into Sharepoint Lists verses 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 synch, if I decide to synch 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.
Many thanks for any valuable feedback.