Business Connectivity Services

learn more… | top users | synonyms

0
votes
1answer
247 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
1answer
40 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 ...
0
votes
0answers
21 views

Business Connectivity Service set permission on entry level

I am not sure if it is possible or not. I Need a way to set permissions on entry Level. that means that I am retrieving data from a REST Service but every single user has different permissions on ...
0
votes
0answers
22 views

SP 2010 - BCS - Displaying SP List with additional columns autopopulated from External List

I want to know if the following is possible. I have an SP list called 'Orders'. The Fields are 'Number', 'Quantity','Amount', etc. I have an External List from a SQL DB called 'ExtOrders' - Fields = ...
1
vote
1answer
46 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 ...
0
votes
1answer
40 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 ...
1
vote
1answer
79 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, ...
0
votes
0answers
23 views

how to use association when creating a new item using BCS Object Model and OData

I have an odata service that exposes two collections: customer and orders. So I have this example: http://spabcd.net/customer('1')/Orders How can I create a new customer and associate new orders to ...
1
vote
1answer
164 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 ...
0
votes
0answers
34 views

Dynamically create BDC Data Model based on delivered Meta information via REST

I have the Problem that I have a REST Service which delivers the data I Need to work with in SharePoint but the System I am retrieving the data from might get additional parametes/fields over the time ...
0
votes
1answer
309 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 ...
0
votes
0answers
68 views

BCS code - The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel

I am using a Console Application to connect to an Enternal Source (BCS) which is secure. How can I pass my credentials to my code below so that I don't get the error above? // Specify the SiteURL, ...
3
votes
0answers
86 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 ...
2
votes
2answers
339 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 ...
3
votes
2answers
338 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
0answers
41 views

Custom connector for BCS search - SP 2010

I have some doubt on when to create a custom BCS connector for searching LOB data? By default BCs provides way to search on LOB database like Adventureworks in the given image. But when do we need ...
0
votes
0answers
22 views

Custom search option through BCS Metaman

Can any one of you help me on this? If we implement BCS through BCS Metaman tool will we be able to search LOB oracle data through our SharePoint 2010 Enterprise search template? Or even after using ...
0
votes
1answer
131 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 ...
0
votes
0answers
298 views

Using Business Connectivity Service to connect SharePoint 2013 to an external WCF service

Has anyone successfully connected BCS in SharePoint 2013 to an WCF service? I did several attempts and always got Cannot connect to Business Data Connectivity Metadata Store in the SharePoint ...
1
vote
1answer
66 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 ...
1
vote
0answers
108 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 ...
3
votes
0answers
172 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) ...
0
votes
0answers
135 views

External Content Type in a Site Column results in ArgumentNullException for wildcardedNamespace

I created an external content type, which seems to work fine. I created a list to browse the external content type, and I can see the elements coming from my sql server. I can also use the create and ...
3
votes
1answer
204 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 ...
0
votes
0answers
98 views

BCS DateTime Format to Date Format Conversion in Display From

Version: sharepoint Online 365 I am having Date Field in DB . While i am retrieving in BCS Its showing as Datetime Format. How can trim Time Value. I need to display in Date Format only . ...
0
votes
0answers
16 views

2010 BCS contains metadata for an invalid Data Source for a ECT

I have been asked to look at getting search to work on an External Content Type. Taking a look at the ECT in designer I see that the previously defined datasource which is stored in BCS is invalid in ...
2
votes
1answer
164 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 ...
0
votes
0answers
30 views

BCS field seen in model but not in item profile page - SP2013

I've added a column to my source SQL table, updated the model so that I CAN the new (URL - string type) field in the model (both in SP designer 2013 & BCS application), profile page for displaying ...
2
votes
2answers
318 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?
1
vote
0answers
144 views

Using code, how to sync data from CRM online 2011 to sharepoint online 2011 (or 2013) & vice-versa

I am trying for a proof-of-concept on this one. I have a sample crm-online plugin and I would like to know if through the code I can open my sharepoint online site and thereby get access to the ...
0
votes
0answers
98 views

BDC model to connect oracle data in SharePoint 2010

Need to connect to oracle through BDC model - we can do this by either BDC model created through Visual studio or through BCS Meta man? performance wise which one will be better? BDC model created ...
0
votes
3answers
160 views

How to sync a Sharepoint 2010 list with data from a table in SQL server

I have a table in SQL server 2008 and a list in sharepoint 2010 that has a few columns from this table and a few other unrelated columns as well. This SQL server table keeps changing and I want to ...
2
votes
0answers
123 views

Custom BCS indexing connector with changelog inremental crawl is not working properly

Custom BCS indexing connector with changelog inremental crawl is not working properly I am writing a custom indexing connector using changelog incremental crawl approach. I'm using sample from ...
1
vote
1answer
157 views

How can I create a multi-valued refiner for a Business Data Catalog external content type?

This question regards a SharePoint 2010 instance using vanilla search. I'm currently using a Business Data Catalog to pull records from a database table with an end-goal of displaying the records in ...
0
votes
1answer
134 views

Which approach I should follow; SharePoint business connectivity services OR developing SharePoint App

I have developed a document management system and an enterprise wiki library for our company using SP2013. The second project I am going to start is to develop an asset management system for our ...
0
votes
2answers
426 views

oracle data in InfoPath form

We have a InfoPath form on which wants to show real time data from Oracle database. E.g. Employee name in a drop down list in InfoPath form from employee table in oracle. Don't want to populate ...
0
votes
0answers
23 views

Is there a way to make data linked to by BCS look like a document library?

Is there a way to make the data linked to by BCS look like a document library? Basically, I'm storing some archival type documents in cheaper storage than a SharePoint document library, but I would ...
3
votes
3answers
520 views

Custom BCS indexing connector and changelog inremental crawl: ChangedIdEnumerator method is not working

I am writing a custom indexing connector using changelog incremental crawl approach. The full crawl is working perfectly. All atems are indexed and queryable. The problem is that incremental crawl ...
0
votes
0answers
80 views

External item picker Default Value

How to set default value to external item picker (the textbox that related to it.) Thanks, Omri
0
votes
0answers
261 views

The created external list does not support creating new items

i have BCS with external list that read list and read item is from a table. and create new item is from Stored Procedure. i'm using applicative user who has full permissions (work directly from ...
0
votes
2answers
133 views

Get Items from View of an Extrenal List(BCS List) programmatically

I have created a external content type (BCS list) in SharePoint. I am using the below code in order to get items from bcs list. SPQuery query = new SPQuery(); query.Query = ...
0
votes
1answer
173 views

Search External Content type not returning all records

I have a sql view that returns 449 records. I have setup my external content type to point to this view and have implemented via SPD the read item and read list operations. I have created the ...
1
vote
1answer
222 views

Error while creating a new customer via BCS from within a web part

This is my first time that I am using BCS via a web part and in general. this is my code and I am getting the following error: The given dot notation 'CustomerID' refers to a node in Type Descriptor ...
0
votes
3answers
442 views

How can I view Developer Dashboard from a custom master page or PowerShell?

I need to view Developer Dashboard data to investigate a bottleneck on a SharePoint deployment, but the master page has been customized and the Developer Dashboard is not available (after enabling it ...
0
votes
0answers
60 views

Enumerate BCS Object Permissions

Hi I am looking for a method via PowerShell to enumerate the various ETC's that have been created to determine who currently has access. I realize that I can do this via the front end, however I need ...
1
vote
1answer
38 views

Limiting a view based on authentication by writing qualified username

This article http://www.thesharepointbar.com/?p=340 how to limit a read on a user in BCS, but we can't find the correct syntax for fba-users. (MS Quote: If the login mode for the user is claims-based, ...
1
vote
1answer
46 views

Read/Write capability in BCS

Can someone tell me what exactly does "Read/Write Capability" means in Business Connectivity Services for SharePoint 2010? I read it somewhere that this is a new feature in 2010 which was not present ...
0
votes
1answer
162 views

Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model

I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript. I've tried everything to get those results with query like: "<Where>" + ...
0
votes
0answers
85 views

Show related entities in FAST search results

I've successfully created a .net assembly BCS to crawl external data in my enviorment. The BCS include an AssociationNavigator to crawl related entities based on foreign key. When i perform a crawl ...
1
vote
0answers
75 views

COM BCS model programmatic creation methods

Following the source code found here: http://code.msdn.microsoft.com/office/Creating-SharePoint-2010-ad694d17 I've managed to create the Create, Update and Delete method, but only the Delete ...