Questions tagged [bcs]
Microsoft Business Connectivity Services (BCS) (formerly named the Business Data Catalog) provides the capability to allow data sources outside of SharePoint to be surfaced and potentially modifiable in SharePoint's List user interface. Use this tag for questions or problems related to configuration or using BCS.
387
questions
1
vote
3
answers
3k
views
Why aren't my result types working with managed properties?
I'm having trouble getting Result Types working in SharePoint Search. I've defined a result source for one of my BDC datatypes, plus a result type that matches everything from that result source. ...
- 330
2
votes
1
answer
2k
views
Impersonated Windows Identity vs Impersonated Custom Identity
Could anyone explain the difference between Impersonated Windows Identity and Impersonated Custom identity in SharePoint?
- 595
0
votes
2
answers
1k
views
Insert data from a XML into a List
Two questions:
Is it possible insert data from a XML doc in a SharePoint Native List? Because I checked and is possible create a DataView from a Xml source in SP , but I can't find if it's possible ...
5
votes
1
answer
2k
views
System Account not having permission to update external list via BCS
My SharePoint administrator granted permissions to services, sp app pool, sp farm adim, and secure store in BCS for me to use but was only able create/delete but not update.
I use SharePoint designer ...
- 53
0
votes
1
answer
928
views
Using workflow and BCS to sync external data - CRUD
I'm new to SharePoint and trying to get BCS working with external content. I need to "replicate" native list to an external SQL DB for my project. So I use the crated/changed workflow start options ...
- 53
0
votes
1
answer
1k
views
External Content Type = access denied
I have an External Content Type created. It connects to a SQL Server 2005 db, using "Impersonate Windows Identity" authentication, with an account over in Secure Store Service. I've got a Read List ...
- 1,338
0
votes
1
answer
1k
views
How to get BDC data from BDC URL returned by search in SharePoint 2013?
I am building a POC system based on Search in SharePoint 2013. I have setup BCS to crawl external SQL DB. Search crawl is successful and I am getting the results.
I have not setup any Managed ...
- 394
4
votes
1
answer
2k
views
Timestamp in Sharepoint external content type not matching value in SQL table
I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
- 163
3
votes
1
answer
536
views
How to Sync user data from multiple sources BDC and AD?
I have a user profile that has fields from multiple sources. fields form AD and fields from BCS -> SQL DB. Everything is working, except if the DB is down, the fields get populated with empty data. ...
- 121
1
vote
1
answer
240
views
SharePoint 2010 - BCS secondary columns in viewedit.aspx
I was wondering if this has happened to anyone and if anyone can suggest a fix is.
| SharePoint 2010
| Top level site
| Administrator permissions
I had a number of BCS connections to a document ...
- 11
8
votes
3
answers
8k
views
BCS External Content Type with 20,000+ items (O365)
We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
- 746
1
vote
2
answers
588
views
Query External Data using BCS
I'm using SharePoint 2013 and I'm developing a webpart that has to query an external data and show the results. I cannot create external list due to the fact that my external table has more than 200,...
- 475
0
votes
1
answer
102
views
I stopped the BCS service on a couple of servers, but I still get connectivity errors
Stopping the service on some of the servers seems to have no effect when the system is trying to make a web service call. Here is the error in the ULS:
The BDC Service application Business Data ...
2
votes
1
answer
713
views
SP Designer 2013 - External Content Types & BCS
I'm currently setting up an experimental 2013 environment with BCS, following the instructions in the AdventureWorks white paper found here - http://www.microsoft.com/en-gb/download/details.aspx?id=...
- 433
2
votes
0
answers
2k
views
Getting External Data from Oracle to O365?
We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365.
The requirement is that ...
- 746
2
votes
1
answer
1k
views
namespace on external content type
I have noticed that when moving BCS lists/external content types from my development computer to our production server, it keeps the namespace of my development computer.
For example, all the ...
- 501
1
vote
0
answers
26
views
BCS: Allow deletion of rows only under a given condition
I created a BCS Model and external data type for a MS SQL table. I added a delete action, too, and it is working as expected.
But now I want to allow the user only to delete items, that aren't ...
- 512
1
vote
1
answer
221
views
Kerberos + SharePoint
Kerberos - the beast of SharePoint - has been configured and is creating tickets on my test environment WFE. I also had RevertToSelf for the BCS service application turned on. I am able to create an ...
- 544
0
votes
1
answer
293
views
Business Connectivity Services vs. ADO.NET
Why should I prefer Business Connectivity Services (BCS) over plain ADO.NET, if all I want are simple CRUD operations on an external database (e.g. remote Oracle Database), which are made from a ...
- 381
3
votes
3
answers
10k
views
How can I get external content crawled into SharePoint online index
I have SharePoint online and I want to add external content to the index.
So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
- 247
1
vote
1
answer
296
views
Show Atom feed as external content
I hope that this is the correct place to ask this. I have a site that "spits out" an ATOM feed/seedlist that I want to show in SharePoint as an external content type. So far I know that this is done ...
- 247
7
votes
1
answer
6k
views
Business Data Connectivity Service is not accessible
I am working on sharing service applications across farms ( SP2013 Publishing Farm, SP 2010 Consuming Farm). Services like Search, MMS and Secure Store are working perfectly fine after sharing.
...
- 18.7k
1
vote
2
answers
1k
views
Using BCS and WCF to add external data to sharepoint index
Being completely new to the whole SharePoint environment, I am having trouble understanding exactly how to crawl external data into a SharePoint index.
What I need to accomplish is that a user can ...
- 247
1
vote
1
answer
142
views
How to create a External Content Type equivalent to a Document Set?
I'd like to create an External Content Type either inheriting from or equivalent to a Document Set. I'm not finding any good examples and Document Sets are derived from folders, so the API must be ...
- 376
0
votes
1
answer
1k
views
Create external content type with impersonated custom identity
I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a ...
- 275
0
votes
1
answer
1k
views
Create a SharePoint 2010 BCS connection to Web Service with Visual Studio only
While I have been using SharePoint for quite some time I have not used BCS at all (except way back when I took some training). What I am looking for are steps to create a BCS connector to an external ...
- 996
0
votes
1
answer
731
views
Catastrophic failure when crawling BCS data in SharePoint 2013
I am getting error in search crawl Logs when doing a full crawl on a Business Data Connectivity content source. The content source is set up to crawl a SQL BCS entity that has a stream accessor, ...
0
votes
0
answers
46
views
Cannot modify BCS Model Security Validation Exception
I am trying to programmatically modify a ECT/Entity based on REST data from another system. It works if I am running it from a console application but if I am trying to run it from for example a ...
- 55
0
votes
1
answer
385
views
BCS: Edit button in context menu works, but edit button in display form is disabled
I created an external content type für a MS SQL Server view. I created a list from it and three different views and I changed the form with InfoPath. All of this done without VS, only SharePoint ...
- 512
1
vote
2
answers
5k
views
Access denied by Business Data Connectivity on Setting Metadata Store Permissions
When I try to configure Metadata Store Permissions I keep getting this error
I am the Farm Administrator and have full access on Sharepoint to start with.
Now as I drilled down further looking at my ...
- 131
1
vote
0
answers
58
views
BCS entity code update
I have a problem with the develop with BCS and the Search in SharePoint 2013... I develop an entity that connect with UCM documents and it incorporates in search service (crawling, indexing, etc)
The ...
- 11
5
votes
3
answers
735
views
CAML query on external list: access denied by business connectivity services
I am trying to run a CAML query on a BCS list and getting access denied as an error when debugging the code:
SPList CMList = web.Lists[Constants.cmlist];
SPQuery query = new SPQuery();
query.Query = "...
- 501
5
votes
2
answers
2k
views
Updating Active Directory User Information from Sharepoint User Profiles BCS Data
I am investigating the possibility of updating Active Directory user account information from Sharepoint 2010 User Profiles.
I am aware that there is functionality to synchronise data from the User ...
- 83
5
votes
1
answer
1k
views
SharePoint 2013 Result Sources - Combining BCS Content Source with SP Content Source - Only See SP Content Source
Scenario:
Content Source 1 : Standard SharePoint Local Sites
Content Source 2 : BCS Application
Seek to create 1 Unified Search Result from a Common Result Source..
I have been trying to combine a ...
0
votes
1
answer
306
views
Cascading External Data in Sharepoint 2010
I have a list called "Jobs" that have two columns (Type External Data) called "Company" and "Project". When the user selects a Company, I need the field "Project" filter projects in accordance with ...
1
vote
1
answer
433
views
Sharing list data between sites
I have a list on a sub-site that I want to share via Drop Down List with a Calendar on the root site. ie. When you add or modify a Calendar entry, one of the columns will be a Drop Down List ...
- 173
0
votes
1
answer
133
views
Using External Content Type Pickers with Boolean fields
I have a SQL table with three fields - a unique ID I don't care about, a description, and a Boolean indicating whether or not the record is 'current'. This table is setup as a fairly standard ...
- 61
1
vote
1
answer
382
views
Item-level security possible with OData external content type?
I've created an External Content Type which uses an OData service as it source, and I created a content source in the Search Service Application in order to crawl this data.
This works fine.
However, ...
1
vote
1
answer
492
views
SharePoint 2010 - Create related hierarchical fields from external source
Is there a way to create two related columns as a custom field type in SharePoint? For example, can you develop a custom field type named CustomerOrder that consists of two related lookup columns ...
- 61
2
votes
2
answers
4k
views
How to connect multiple external tables into one SharePoint list to perform CRUD operations
I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to ...
- 87
3
votes
0
answers
199
views
Ribbon is disabled when I Filter an external list in SharePoint 2010
I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter).
The out of the box ...
- 1,254
2
votes
2
answers
6k
views
Deleted item still showing up in search results if only doing Incremental Crawls
I'm trying to set up a Sharepoint search service using a Content Source based on an external BCS data source.
In the BDC model, I implemented the operations I needed, adding a SpecificFinder, an ...
- 131
4
votes
2
answers
2k
views
Does all external SharePoint data have to flow through BCS?
I was asked the question why I need access to BCS Services and have been tasked with documenting "ways to access external data in SharePoint'
I've read one article after the next regarding external ...
0
votes
1
answer
958
views
InfoPath changes the look of the form
I am following this guide to create a cross site lookup field in SharePoint. I am using SharePoint 2013. The problem is that when I open the form with InfoPath Designer 2013 the form doesn't resemble ...
- 317
1
vote
1
answer
501
views
Search in Custom indexing connector with AttachmentAssociator property in AssociationNavigator
I have a custom indexing connector with Entities associated via AssociationNavigator method. In order for Search (of SharePoint 2013) to crawl the associated entity, we need to set either the '...
- 41
1
vote
0
answers
313
views
Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint
I'm using SharePoint 2010 and I have access to InfoPath and BCS services.
I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
- 11
4
votes
0
answers
565
views
How to filter a paged and sorted external list
I have succesfully implented an external content type with a read list method, which can sort and page through the external data.
The external content type has 4 filters (two limit and two wildcard) ...
- 333
4
votes
1
answer
613
views
SharePoint 2013 Custom BCS/BDC Entity Search Refiner
I have a custom BCS model that I am using to index SQL data in SharePoint 2013. The localized name of the type of item is being set as the title (i.e. Answer, Question, Idea, etc.). In the search ...
- 12k
3
votes
1
answer
373
views
Context Aware BCS Model for Search Crawling in SharePoint 2013
I have an external SQL data source that I would like to include in SharePoint search crawling with a BCS/BDC model. As it stands, SharePoint sees this data independently of the SharePoint site ...
- 12k
2
votes
2
answers
1k
views
Connect SAP data from SharePoint 2010
If we want to create a custom connector to connect SAP data from SharePoint 2010 ... how to do that? what steps are involved?
- 455