Solved

SharePoint 2013 Business Data Connectivity Services questions

Posted on 2016-11-05
7
34 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 15

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 15

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 15

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 15

Expert Comment

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 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

20 Experts available now in Live!

Get 1:1 Help Now