In which database is the items from Sharepoint stored?
Good morning all!
The situation:
Whe have created a Team Project that comes with a Sharepoint website. When navigating to this website, we have a section called "links" were a bunch of links are presented. Clicking the link "What's installed" brings me to a page (AllItems.aspx) where all the build numbers (and other information) is currently installed at the client. This information is nicely formated in a <table>...</table>
My Quest:
I'm in the process of creating a windows application that would like to get that information from the sharepoint website and display it somehow. I'm currently faced with 3 possible scenarios to achieve this:
1) Use a screen scrapping technique to get the html and then parse it. Locate the proper <table> I wish to use and then display it in my winform.
2) Directly use T-SQL commands to get the information from the database in wich these values are stored, then display it in my winform.
3) Invoke Sharepoint Web Services to get the information I need , then display it in my winform.
The question(s):
If I decide to use approach 2) then in wich database is this information stored? TFSWarehouse? Is there a cube/view/sproc automagically created to get that information? I'm not really familliar with Sharepoint nor with its webservices so if I decide to use approach 3) where could I find the proper webservices to call?
As for approach 1) well...I'm just not going to do it, as I believe there is got to be a better way :-)
Perhaps anyone out there could help me decide wich approach to use and provide me with information/links on how to use the proper database and/or webservice.
Thanks in advance!
Sincerely
Vince
