Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SharePoint 2013 Business Data Connectivity Services questions

Posted on 2016-11-05
7
Medium Priority
?
80 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 20

Expert Comment

by:Walter Curtis
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 20

Expert Comment

by:Walter Curtis
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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 20

Accepted Solution

by:
Walter Curtis earned 2000 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 20

Expert Comment

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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

636 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