How to create view table directly from sharepoint's database ?
Posted on 2016-09-25
I am very new to sharepoint. But I do have experience as dba and developer using Oracle database, Oracle Developer suite 10g, opensource etc.
My friend work as a developer, creating forms using sharepoint. All he did was to capture personal information, detail, education, higher qualification, etc. He told me that he never created any table. He just created forms and sharepoint somehow will create source lists just like table.
After few months, we need to extract all data but not via sharepoint. We want to access directly to the sql database because I believe this is more flexible (due to my background as dba for oracle). It give me freedom to create view table but not to update any.
When I check the database, I couldn't find specific table like what most developer do, create table and create form later. What I realised is, under SQL server dbo tree, I see Tables - further down AllDocs,AllDocStream,...AllLists, AllListAux etc...
Is this how sharepoint store the data as a list? Is there any tool that can read entire database and display it in table form ? Or is there any workaround ? Once I can run normal sql query statements, like , select * from person_tbl, education_tbl .....where ..condition (join statement), then I am happy. I can further develop myself.
Please note: My question is more on discussion how sharepoint works and how it can assist non-sharepoint developer to extract existing data. An example of this, what if I want to create mobile apps that need to extract captured data in sharepoint.