SQL Server database and sharepoint

by 5 replies
6
What is the best way for enabling reporting when some of the data is residing in Sharepoint lists and a part of it is residing in the SQL Server database.
#programming #database #server #sharepoint #sharepoint consulting #sharepoint services #sharepoint training #sql
  • Banned
    [DELETED]
  • Hi,

    If you have different data sources and you are looking for reporting i would suggest Oracle OBIEE which can integrate all the data sources and report as one needs for better decisions
  • Banned
    [DELETED]
  • i suggest you to use microsoft sql server help u to integrate different data source
  • Ooooh...a little part of me died when I read "Sharepoint"

    Getting data out of Sharepoint in a meaningful manner is notoriously painful. Ultimately, you'll want to aggregate the data somewhere (possibly in a SQL view), and then you can use SQL Server Reporting Services to create reusable reports (for free, it's included even in the Express version of SQL). I would strongly recommend you take a look at SSIS (SQL Server Integration Services) and see if you can't use that to pull data from Sharepoint in a more meaningful form.
  • Microsoft sql would be the proper solution as far as i know. You will be able to import outer sources also.
  • Microsoft SQL Server would be an easier option for you
  • Banned
    [DELETED]
Join the discussion

Next Topics on Trending Feed