Business Connectivity Services
10
votes
3answers
3k views
How to automate entry of external column data in BCS?
I have a document library, Resumes, that has a large number of resumes in it. There is a regular column on that library, called EmployeeID, that is already populated. I have an external content type ...
9
votes
7answers
8k views
How to sync a SQL database with a SharePoint List?
I need to sync an already existing SQL Database to a SharePoint 2010 list. Two way sync would be great but one way sync is also alright. Any documentation in this regard would be of a great help.
...
9
votes
3answers
795 views
FAST Search Security Trimming of non Windows External Content Types
We have integrated a back-end web application into SharePoint 2010 using the BCS and the OOTB Web Services connector.
The data in the backend system is protected by ACLs and we need these ACLs to be ...
7
votes
1answer
362 views
SharePoint 2010 User Profile Synchronization: BCS + WCF
I'm here because I'm trying to implement a scenario of user profile synchro with bcs connecting to wcf service.
Here is the context:
A remote web service is returning a full list of employee infos. ...
6
votes
4answers
2k views
Working with large external lists using BCS
I have a database that I want to display the content in SharePoint 2010. I am not displaying the content in a list but am using a custom WebPart.
The database is not updated any more as it is ...
6
votes
4answers
1k views
Reusing and parameterising BCS External Content Types
I recently posted a query here that asked about the best way of connecting to an external SQL store.
I got some great responses back but need a little more info, specifically around External Content ...
6
votes
4answers
6k views
Paging and sorting with BCS
I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
5
votes
2answers
410 views
Use custom page in _layouts for display item form
I was wondering if I could acheive the following. I have a custom application page living in _layouts which displays an entity based upon an external content type item.
For external lists using this ...
5
votes
2answers
275 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 ...
5
votes
1answer
235 views
How to use BCS in Word for editing BLOBs
If I have an External Content type defined with a StreamAccessor that will end up referencing Word docx files stored in another system (reason for using BCS), what options do I have for updating the ...
4
votes
1answer
204 views
Int type as Entity key into BCS Model
The BCS Model can't create a form for the "Update" operation if the key of Entity has a type of uint, int, long or ulong when I use WCF as a data source. It works fine with the string type.
Does ...
3
votes
2answers
782 views
Moving BDC models from server to server
I have created a BDC model and deploy it through a feature. The feature has to have a SiteUrl as specified in the feature xml below. However when I move the feature from say the development to test, ...
3
votes
2answers
563 views
TFS-SharePoint integration
I am currently investigating how to push data from Team Foundation Server to SharePoint.
Are there any connections available out of the box? Any useful online references? Third party tools?
3
votes
2answers
2k views
Access Denied while setting Metadata Store Permission
Breaking my head with this issue for the past 2 days!
Received Access Denied error in SPD so tried to set Meta Data permission and get the following error.
I am one of the Admins for BSC service ...
3
votes
1answer
144 views
Can document views/metadata be 'live'?
We have a need for end users to see documents with additional 'live' columns, i.e. I would like to show a view of documents with employee id JOINED with data from sql server (for some additional ...
3
votes
2answers
168 views
Update CRM from User Profile
We currently have Sharepoint 2010 setup to use AD to get useraccounts, and a BCS connection to provide extra information to the User Profile of users. The data from AD is very basic: only username and ...
3
votes
1answer
1k views
Sharepoint Incremental Crawl and BCS
I have a BCS connector (partial BDC Model posted below) and I'm noticing some issues with Sharepoint crawls. My full crawl seems to work perfectly, but incremental is pulling back the same number of ...
3
votes
1answer
501 views
multiple value in external data column
We need to store multiple value from external source in the one column. Same multiple lookup.
Is there any exiting way to do it?
If no, i think about developing custom entity piecker, but it need ...
3
votes
2answers
2k views
Date Only format with BCS
I have created an External Content Type through SharePoint Designer. One of the fields that I'm getting from my database is a DateTime column. In SharePoint, however, I want to format this as a Date ...
3
votes
1answer
338 views
Access denied for BCS method in e-mail event receiver
I have a SPItemEventReceiver which does some stuff with an external list when a document is uploaded to a DocLib. I now wanted to have it also run when an e-mail is sent to that DocLib.
I could have ...
3
votes
1answer
271 views
Is it possible to filter a BCS list using a site's name?
I'm running SharePoint Foundation and copying a site template per project. I would like to filter the BCS list in my template using the site name.
Is there a possible method?
3
votes
3answers
1k views
Display an SPFieldUrlValue property from a BCS Model
I have a pretty simple BCS model:
public Guid Id { get; set; }
public SPFieldUrlValue Url { get; set; }
public string Description { get; set; }
public string Owner { get; set; }
public DateTime ...
3
votes
3answers
1k views
Validation for external lists / external content types
Where does one put validation for external content types? Let's say one field on my ECT represents an email address that must be unique in our system. Where would I put the validation that checks to ...
3
votes
1answer
382 views
Paging and sorting with BCS - Is it really possible?
I'm trying to add paging on an external list and so far it does not work 100%. The best references I could find (that actually... kinda... work) are these:
Paging and sorting with BCS
Paging and ...
3
votes
1answer
311 views
How to use the batching and batching termination filter descriptors in BCS .NET Connectivity solutions
I know about this post on BCS paging: Paging and sorting with BCS and have implemented a similar approach in a BCS solution. However, what I'm really looking for is a complete example showing how to ...
2
votes
1answer
853 views
Creating an external list from SQL query using BCS
I'm developing a visualization application on SharePoint Enterprise 2010. This involves doing some SQL queries I would love to expose as external lists in SharePoint. All interfacing with the database ...
2
votes
1answer
349 views
Dropbox access from SharePoint
I am new to Dropbox, and I'd like to know if there is an easy way to access Dropbox content from SharePoint 2010 / Office 365.
For example, should I consider BCS? Or is there a way to work with the ...
2
votes
3answers
5k views
How do you enable connect to outlook on external list?
I am very new to sharepoint, its about day 3 of working with it, and I am having a problem getting Connect to outlook working on external lists. The menu item is greyed out.
In my external contact ...
2
votes
2answers
794 views
Selecting default filter
I have a ERP system which is linked to SharePoint via BCS. In a previous 2007 site, the BDC layer used the searchcode from the ERP system as primary key. That meant the user could just type in a ...
2
votes
1answer
607 views
“Access denied” while loading the BCS list from the database
I have tried to display data from SQL Server to a SharePoint page through BCS services
using SharePoint 2010 designer.
While loading I am getting this error:
Access denied. You do not have ...
2
votes
1answer
2k views
No Business Data Connectivity Service associated with current web context error
I am running on a new dev setup for SharePoint 2010 and trying to setup some External Content types. I think that I have setup BCS correctly (since I see it running in the central administration). ...
2
votes
1answer
458 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 ...
2
votes
1answer
523 views
Using BCS and External Content Types to create Publishing Pages
I'm starting a new SharePoint 2010 web content management project where a portion of the site's content is driven by an external system (SQL Server based). Think employee bios... The external system ...
2
votes
1answer
431 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. ...
2
votes
2answers
504 views
Implementing Security on custom BCS/.net class?
I'm implementing a custom BCS Model to get data from a backend system. As the backend uses it's own user management, I'm accessing it through a service account.
All of this works well and allows me ...
2
votes
1answer
1k views
BCS and Oracle: bug in connection string?
I try to connect from BCS directly to Oracle, but there is an error: Keyword not supported: 'connect timeout'. I think that the connection string formed for Oracle is in an incorrect format for ...
2
votes
1answer
230 views
BCS Model not deploying in Farm environment
Has anyone else seen an issue with deploying a BCS Model WSP to a farm and the External Content Type is not being deployed? The Farm feature is activated.
It is working fine for a single server ...
2
votes
1answer
406 views
Sharepoint Online and custom BDC models
Hello I hope somebody can help.
I need to access an external timesheet from Sharepoint Online.
The Timesheet site uses a REST api to provide the data, not a WCF or traditional ASPX webservice. So ...
2
votes
1answer
73 views
Good book or resource that talks about custom connectors and SharePoint search Integration?
Do you know any good books or resources that explains how to write your own custom connector for search crawling?
I have been reading Professional Business Connectivity Services in SharePoint 2010 ...
2
votes
2answers
595 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 ...
2
votes
2answers
439 views
Can I use a Console Application to Programmatically Create a Content Data Source and Start Crawl?
I am looking for examples where folks have programmatically defined a business data content source and setup Search Service Administration to crawl it, all within a console application. I'm aware of ...
2
votes
1answer
161 views
BCS, field captions/title localizations
We've developed BCS appllication and now have no ideas about how to localize fields titles in BCS model. Where some xml tags in BCS model definition, but it did not work in our practise.
Does ...
2
votes
1answer
1k views
Developing Visual Web Part with external list in ListView
Using VS 2010 i've created BCS model for external MS SQL source, deployed it with success, then created external list - it works perfect.
Now my task is - create visual web part in VS2010 and place ...
2
votes
1answer
2k views
Creating a Site Column from an External List with SharePoint 2010?
Can you create a Lookup column from an External List within SharePoint 2010. I have achieved this before but it seems incredibly fragile and I am now wondering if this is even a supported feature and ...
2
votes
1answer
46 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 ...
2
votes
0answers
99 views
BCS and External List: Validations and Business Logic
I have been able to define an External List through a WCF Service. This works well, but I am now moving onto more advanced scenarios - I would like my Create, Update and Delete methods to implement ...
2
votes
1answer
161 views
Should I Use Business Connectivity Services or Not in This Specific Scenario
I'm currently working on a SharePoint Standard 2010 project.
I would have preferred to use the User Profile Service to sync with AD to populate employee details, but our AD doesn't have much ...
2
votes
0answers
103 views
External Data Column no sorting by a string based additional field
Can anyone confirm or tell me why you can't sort by an External Data column additional field if its type descriptor is a string?
It works for int, bool and guid type descriptors. If I add a standard ...
2
votes
3answers
540 views
SPTimer job and BCS External list
Business requirement - synchronize a table from external my sql database into SharePoint list.
What I have done.
I have an external MySql database which as LOB data. I have created a BCS ...
2
votes
1answer
314 views
How to customize profile pages for external content type search results?
I have set up the SP 2010 enterprise search to include searches in line-of-business data. (In my concrete case that would be data from Dynamics CRM 2011 but I hope that is not relevant). I have ...
