Is it possible to access the database backend of a sharepoint server? My company uses Sharepoint to store data and pictures of various assets. Ideally I would be able to access the data and display it in my application to allow users both methods of access.
是否可以访问sharepoint服务器的数据库后端?我的公司使用Sharepoint来存储各种资产的数据和图片。理想情况下,我将能够访问数据并在我的应用程序中显示它,以允许用户使用这两种访问方法。
Before I go talk to the IT department I would like to find out if this is even possible?
在我与IT部门交谈之前,我想知道这是否可能?
Edit: From rails on linux? (Yes, I know I'm crazy)
编辑:从linux上的rails? (是的,我知道我疯了)
4 个解决方案
#1
3
Agree with Adam. Querying the Sharepoint Database is a big no-no, as Microsoft does not guarantee that the Schema is in any way stable. Only access the database if there is really no other way.
同意亚当。查询Sharepoint数据库是一个很大的禁忌,因为Microsoft不保证Schema在任何方面都是稳定的。只有在没有其他办法的情况下才能访问数据库。
As for Sharepoint, usually the Lists.asmx Web Service is what you want to look at first.
对于Sharepoint,通常Lists.asmx Web服务是您首先要查看的内容。
http://www.c-sharpcorner.com/UploadFile/mahesh/WSSInNet01302007093018AM/WSSInNet.aspx
#2
3
yikes! :)
look at the web service and .net API before going direct to the database. i've used both and they provide plenty of flexibility (including building your own web services on top of the API if necessary). API for on server clients, web services for off server clients.
在直接访问数据库之前查看Web服务和.net API。我已经使用了它们,它们提供了很大的灵活性(包括在必要时在API之上构建自己的Web服务)。服务器客户端的API,关闭服务器客户端的Web服务。
#3
1
Just a small comment. Never ever go to the database direct. If there is no way to do it via published and supported API's, then there is no way to do it. End of story. This applies even to when you are "just reading data", as this can still cause significant issues.
只是一个小评论。永远不要直接去数据库。如果无法通过已发布和支持的API执行此操作,则无法执行此操作。故事结局。这甚至适用于“只读数据”,因为这仍然会导致严重问题。
#4
1
Just to support the above if you ever take a look at the SQL tables that sit behind SharePoint you'll realise why its not recommnded or supported to access the database direct. MADNESS!
只是为了支持上述内容,如果您查看位于SharePoint后面的SQL表,您将会发现为什么不建议或不支持直接访问数据库。疯狂!
#1
3
Agree with Adam. Querying the Sharepoint Database is a big no-no, as Microsoft does not guarantee that the Schema is in any way stable. Only access the database if there is really no other way.
同意亚当。查询Sharepoint数据库是一个很大的禁忌,因为Microsoft不保证Schema在任何方面都是稳定的。只有在没有其他办法的情况下才能访问数据库。
As for Sharepoint, usually the Lists.asmx Web Service is what you want to look at first.
对于Sharepoint,通常Lists.asmx Web服务是您首先要查看的内容。
http://www.c-sharpcorner.com/UploadFile/mahesh/WSSInNet01302007093018AM/WSSInNet.aspx
#2
3
yikes! :)
look at the web service and .net API before going direct to the database. i've used both and they provide plenty of flexibility (including building your own web services on top of the API if necessary). API for on server clients, web services for off server clients.
在直接访问数据库之前查看Web服务和.net API。我已经使用了它们,它们提供了很大的灵活性(包括在必要时在API之上构建自己的Web服务)。服务器客户端的API,关闭服务器客户端的Web服务。
#3
1
Just a small comment. Never ever go to the database direct. If there is no way to do it via published and supported API's, then there is no way to do it. End of story. This applies even to when you are "just reading data", as this can still cause significant issues.
只是一个小评论。永远不要直接去数据库。如果无法通过已发布和支持的API执行此操作,则无法执行此操作。故事结局。这甚至适用于“只读数据”,因为这仍然会导致严重问题。
#4
1
Just to support the above if you ever take a look at the SQL tables that sit behind SharePoint you'll realise why its not recommnded or supported to access the database direct. MADNESS!
只是为了支持上述内容,如果您查看位于SharePoint后面的SQL表,您将会发现为什么不建议或不支持直接访问数据库。疯狂!