Solved

SharePoint 2013 Business Data Connectivity Services questions

Posted on 2016-11-05
7
23 Views
Last Modified: 2016-11-07
I am trying to get SQL database accessed and updated using SharePoint BDC and have following questions.

1. How to edit data in SharePoint list once it is fetched from SQL database?
2. Later can we add more fields to SharePoint list if needed?
3. How user permission will be remapped or updated? to ensure only user who is authorized is updating the SharePoint list?
4. Can we have two sync meaning if someone update the data on SQL using another ASP.net application and someone using SharePoint list? will both changes be seen on ASP.Net application as well SharePoint list?
5. Can we have versioning enabled on SharePoint list which is created through BDC process?
0
Comment
Question by:Pankaj Parmar
  • 4
  • 3
7 Comments
 
LVL 14

Expert Comment

by:SneekCo
ID: 41875534
You first question seems to indicate a misunderstanding about SharePoint. A SharePoint list is found in a SQL database, but you don't need BDC to get to data in a SharePoint list.

Are you referring to something else besides and just calling it a SharePoint list?
0
 
LVL 4

Author Comment

by:Pankaj Parmar
ID: 41875795
let me reframe my questions.

My objective is fetched data from ASP.NET application and that is using MS SQL database.

Now I want that data to be accessed using SharePoint BDC service and have following questions.

1. How to edit data in SharePoint list once it is fetched from SQL database?
 2. Later can we add more fields to SharePoint list if needed?
 3. How user permission will be remapped or updated? to ensure only user who is authorized is updating the SharePoint list?
 4. Can we have two sync meaning if someone update the data on SQL using another ASP.net application and someone using SharePoint list? will both changes be seen on ASP.Net application as well SharePoint list?
 5. Can we have versioning enabled on SharePoint list which is created through BDC process?
0
 
LVL 14

Expert Comment

by:SneekCo
ID: 41877077
Thanks for the reframe, it makes more sense now:

When you connect to a SQL database from SharePoint using Business Connectivity Service (BCS), you can create an external content type for that data. That content type can be used in a SharePoint list just as a normal content type. When you create the connection, via SharePoint designer, you determine the type of access be it read only, write access etc...

SharePoint list permissions will apply, so if you have the connection set up as a full read \ write connection, a user with read only access to the list will not be able to write to the list, including the external content type (the SQL database.)

As far as changes being seen, yes they will be seen, however the user using the ASP.net will not see any changes to the SharePoint list that are not connected to the SQL database using the external content type. That means, that is the SharePoint list has multiple content types putting various columns in use, the columns that are not a part of the external content type will not write back to the SQL data base. This could become a problem depending upon what specifically you are trying to do.

As far as versioning, standard list item versioning can be enabled, but it would not be linked to any type of versioning on the SQL database.

Honestly, this approach you are considering seems that it is going to lead to big problems. You have a challenge of keeping two separate databases in sync, (consider unique ID's for example). If users are allowed write access in both SharePoint and your ASP.Net application there could be data integrity problems, not to mention possible conflicts of data that needs to be resolved, a difficult process to code for. If possible, decide on one data source and design around that and not attempt to keep two data sources in-sync that have such different purpose and design. Just my two cents worth...

Good luck...
1
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 4

Author Comment

by:Pankaj Parmar
ID: 41877127
Thank you Brother!!

So I think the best would be not write data back to that SQL database from SharePoint, instead just create new column in SharePoint and use SharePoint database and then only update those columns.

Could you please confirm if this is possible.
0
 
LVL 14

Accepted Solution

by:
SneekCo earned 500 total points
ID: 41877155
You approach you just submitted sounds very good. It should work for you.

Good luck...
0
 
LVL 4

Author Closing Comment

by:Pankaj Parmar
ID: 41877193
Thank you very much SneekCo

I appreciate all your help. Excellent Job!!
0
 
LVL 14

Expert Comment

by:SneekCo
ID: 41877207
Thanks, glad I could help and good luck!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now