SQL Server database and sharepoint

5 replies
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.
#database #server #sharepoint #sharepoint consulting #sharepoint services #sharepoint training #sql
  • Profile picture of the author purpleviolet
    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
    {{ DiscussionBoard.errors[6529779].message }}
  • Profile picture of the author michael clay
    i suggest you to use microsoft sql server help u to integrate different data source
    {{ DiscussionBoard.errors[6635128].message }}
  • Profile picture of the author TopicSpan
    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.
    Signature
    Don't lose users!
    Grab our full-page UltraCache system that instantly speeds up any PHP website!
    {{ DiscussionBoard.errors[6636908].message }}
  • Profile picture of the author jaasmit
    Microsoft sql would be the proper solution as far as i know. You will be able to import outer sources also.
    {{ DiscussionBoard.errors[6637382].message }}
  • Profile picture of the author locke815
    Microsoft SQL Server would be an easier option for you
    {{ DiscussionBoard.errors[6637507].message }}

Trending Topics