I want to create data conection library to transfer a data from MSSQL serwer to Sharepoint list and with read write option. I must edit a data from a MSSQL table to Sharepoint list.

Please help.

  • 2
    Looked in to BCS? – Robert Lindgren Mar 17 '14 at 10:15
  • Yes and no because now I traingng this by InfoPath, because I must have got two or three tables not one table. – Grzegorz Z Mar 17 '14 at 10:29
  • How could I set user permissions in BCS ? – Grzegorz Z Mar 17 '14 at 10:35

Research "Creating an external list using BCS" to see if this will work for you. It should as external lists can provide read/write access to external content types, including a SQL Server database table. There are numerous examples on the web and plenty of Microsoft documentation on this topic. Many of the web examples show exactly that scenario, creating an external content type that connects to MS SQL Server.

SharePoint Business Connectivity Services on Technet

Create an External List based on a SQL Server table

There is even a whole book dedicated to BCS.

Professional Business Connectivity Services

Regarding your comment above about permissions, see:

Business Connectivity Services Security Overview

Because your question is not that specific, these are high-level answers to point you in the right direction so you can get started. Once you get started SharePoint StackExchange is a good resource if you get stuck or have more specific questions.

| improve this answer | |
  • And Can I Conect MS SQL serwer table with Sharepoint list and show this conection on sharepoint another list ? – Grzegorz Z Mar 17 '14 at 12:01
  • 1
    You can use external columns (slightly different than an external list). See the resources I listed above for the difference. You can join SharePoint lists (using CAML queries) or SQL server tables (using SQL). You can also create views in SQL Server that do the joins and then have an external content type to show that view in a list. The view lets SQL Server do the work for the joins (which it is good at). – lwbecker2 Mar 17 '14 at 14:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.