Business Connectivity Services

learn more… | top users | synonyms

4
votes
3answers
1k 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 ...
1
vote
0answers
213 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 ...
4
votes
1answer
380 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
1k views

BCS custom connector and incremental crawl with search server express not working

we are currently developing a generic connector framework to access JSON-resources from an HTTP-Server. As the connector should not depend on a data model it heavily relies on DynamicType. As there ...
3
votes
1answer
277 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 ...
1
vote
2answers
2k views

working and filtering with large external lists using BCS

I have a large set of orders (about 7500) that I want to show in my SharePoint site. I'm using BCS because I also want to link the orders to documents. I also have an external list with these ...
2
votes
2answers
872 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
251 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 ...
1
vote
3answers
998 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 ...
1
vote
1answer
321 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
160 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
0answers
25 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 ...
0
votes
0answers
432 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
207 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 = ...
1
vote
1answer
165 views

External List not returning values

I have an external list which isn't returning any values. The list uses an external content type, which gets information from a SOAP service. After creating the content type using a read item and ...
0
votes
1answer
258 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
442 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
0answers
89 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 ...
0
votes
1answer
342 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>" + ...
1
vote
1answer
45 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
3answers
255 views

SharePoint foundation and BCS

I am testing SharePoint 2010 foundation with bcs to access one of my sql tables. I created a list with filters on some fields (wildcard and limit types) But unfortunately, when I display (browser) ...
1
vote
1answer
65 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
0answers
111 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
94 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 ...
1
vote
1answer
2k views

Event fire and Workflow Attach to External List?

What is the best way approach to attach workflow and Event Receiver on External List? How to store Directly External Data to SharePoint Custom List?List
1
vote
1answer
2k views

Can you use BCS External Content Types in conjunction with Product Catalogs in 2013?

Does anybody know if it is possible to use an External Content Type as the basis for a Product Catalog in SharePoint 2013? So if we store a load of Product data in a database are we then able to ...
1
vote
2answers
668 views

Deploy BCS profile page without SPD

Is it possible to deploy a BCS profile page via a WSP? Did anyone try this including settting the default action on the external content type? All references I can find explain how to create a ...
5
votes
2answers
328 views

How to dynamically generate Business Connectivity Services

We are trying to deploy a Business Connectivity Services(BCS) Model solution where the properties in the model depend on the structure of the data exposed by a web service. Ideally the BCS Model ...
1
vote
0answers
121 views

Searching CRM 2011 records in Sharepoint 2010

I need to search Microsoft Dynamics CRM 2011 (onpremise or online) records in SharePoint 2010 (onpremise and preferably foundation but can go to enterprise if it is a must). I want to know from ...
1
vote
1answer
2k views

BCS External Item picker

There are two external lists like 'Project' and 'Task'. Task referencing project by using field ProjectID. I've created external content types. For 'Project' content type I've marked field ...
1
vote
2answers
536 views

How to connect Outlook to an external list, which uses external connector in DLL

The task: connect Outlook with the external list, which was created in Visual Studio and uses SAP connector (sapnco.dll). What I've done: Created this external list. I can see all information in ...
2
votes
1answer
2k views

External List from External Content Type: missing and/or error

I've created an ECT w/ Read List and Read Item operations using SharePoint Designer, saved it, and given myself permissions. The ECT's external data source is a WCF service. When I try to create an ...
1
vote
1answer
1k views

Synchronization of SharePoint 2010 List with SQL Server Table

I need to create a list such that the values on the list can be stored in SQL table as well. I need to attach workflows to the list item as well. Its a simple workflow with two approval process ...
0
votes
1answer
167 views

Best to way to populated external database?

I have a requirement where I need to populated a SQL Server database (tbl_Customer) with sharepoint List. I am not sure about the best approach. approach 1: bcs to external database and scheduled ...
1
vote
3answers
1k views

Error while import resource file Business Data Connectivity

I am trying to use powershell for importing a resource file in Business Data Catalog but I keep getting the following error Import-SPBusinessDataCatalogModel : The root element of a valid Metadata ...
1
vote
0answers
129 views

BCS connection with SQL DB and Sharepoint list passing parameters

Is there way to pass parameters to BCS connection between sharepoint list and sql table and populate the list with the sql table data which agrees to a certain scenario(according to the passed ...
1
vote
3answers
3k views

Setting Value of External Field in Code

I cannot seem to find any examples of how to set a BCS External Field via code. I have two lists that both have a BCS field named "Industry". When an item is created in List A I need to create a new ...
2
votes
2answers
951 views

Supplementing User Profile with information from BCS

I've got my external content type and BCS all sorted and working - the list view of the external list shows 100% in the site and the external content type shows under my BCS service application. Now ...
0
votes
2answers
754 views

replication of document libraries in sharepoint 2010

In sharepoint 2010, Need to have a document library in a site and another document library in another site and the 2nd document library should be an exact copy of the 1st document library(with the ...
1
vote
1answer
201 views

How to connect between two document libraries in different webapplications using BCS?

In Sharepoint 2010 , How to connect between two document libraries in different webapplications using BCS?. The webapplications has sitecollections and sites in it and the sites are getting created ...
0
votes
1answer
188 views

Sharepoint 2010, BCS and inner join

We have external content type based on a table in database. It was created using SharePoint designer. Unfortunately one of the column is referencing another table, which is dictionary - primary table ...
0
votes
1answer
356 views

KeywordQuery to search by BCS Entity Name and Namespace

I have built a custom search connector to crawl and index external content types. That works quite well. I find the index entities in the search center as well through using the API of ...
2
votes
1answer
707 views

Paging and sorting in sharepoint BCS

I saw this post about Paging and sorting and tried to do simiral thing in my project. But failed to do so. Everything works fine apart from instead of getting the value i get the parameter name. ...
1
vote
2answers
4k views

BCS and Filtering/Paging - External List vs Business Data List Web Part

I am trying to learn BCS for use in an in-house application. To keep it simple at this point I am limiting myself to a single table even though the table has FK references for grouping and some ...
1
vote
1answer
693 views

SharePoint BCS with SOAP web service using custom authentication

I'm very new to using BCS in SharePoint 2010. I'm not really sure how to go about my problem or if it's even possible without coding a custom solution in Visual Studio using .NET. I have a SOAP web ...
0
votes
0answers
84 views

Auto-generated code for “Using”, “SQLConnection”, “ReadItem”, “ReadList” methods

I am beginner in SharePoint 2010 development. and doing following lab: Module 6: Accessing external data with Business Connectivity Services in SharePoint 2010 ...
1
vote
0answers
194 views

Can't get Custom BCS Connector with filters to work

I am trying to create a BCS connector in Visual Studio that connects to a WCF service. I first used an parameterless GetAccounts method as the source for the ReadList method, and the wanted to add ...
2
votes
1answer
2k views

User profile properties mapped to a BCS connection requires two syncs for new users

I have the User Profile Service Application up and running in a SharePoint 2010 farm. It is configured with two synchronization connections; one to Active Directory and a second to a backend database ...
1
vote
2answers
462 views

BCS Security Access Using Secure Store in code question

I have Secure Store and also Kerberos setup on my development and production farms. I am using Event Receivers to access BCS data. I have verified that if I simply impersonate a user that has access ...
1
vote
1answer
646 views

BDC hide identifier in new item form

I'm working on a simple bdc model in visual studio. i use the entity framework to access the data on the database. Everything works fine (all CRUD operations) but in the "New item" form i have to ...