Solved

SharePoint 2013 Business Data Connectivity Services questions

Posted on 2016-11-05
7
59 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 18

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 18

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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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 18

Accepted Solution

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

Expert Comment

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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

707 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