Hot answers tagged bcs
12
Business Connectivity Services (BCS) is the way to go...here's a nice 3 part series on setting it up as well as programatically working with it:
http://www.zimmergren.net/archive/2010/01/18/sp-2010-getting-started-with-business-connectivity-services-bcs-in-sharepoint-2010.aspx
Tons of data out there if you want to do additional research...google SharePoint ...
9
Thus far, using the object model has been the only way I have been able to successfully do this. I encountered the same issues as you when using PowerShell.
Using Jaspers' post SP2010: Setting BCS column and related fields as my guide, I used the following code to iterate through all the items in my Resumes document library, read the value from the ...
6
In my experience, this would work best as a webpart. When editing the displayforms, to play nice with SP, you have to keep that listview webpart on the page. Fortunately, you can make it hidden. So, what I would do is create a webpart that duplicates the functionality of your application page. Edit the displayform page using the browser, edit the webpart ...
5
SharePoint Designer will also expose any views or stored procedures you have. You can set those up for use in the external contenttype. If you go into the data source explorer in sharepoint designer you will see views and routines in the tree under your database. If you can add a view or a stored procedure in SQL, then it will show up there and you can take ...
4
Thanks, guys, I'm already create paging and sorting with BCS. In my case BCS works fine with WCF services.
At first I'm develop web service with follow contract:
[OperationContract]
IEnumerable<Employee> GetEmployeesPaged(int startRowNumber, int pageCount, string sortColumn, string sortDir);
then I'm created BDC definition with Read List Method for ...
4
DropBox does have an API with a REST interface - described here. I think REST may be the way to go compared to BCS.
There's an article showing how it is used (via .NET) - Create, delete and move folders with the Dropbox REST API.
4
Got it!
<View>
<Method Name='ReadList'>
<Filter Name='PartnerName' Value='{0}'/>
</Method>
<Query>
<Where>
<Contains>
<FieldRef Name='Name'/>
<Value Type='Text'>{0}</Value>
</Contains>
...
3
It sounds like you need to set permissions on the BCS entity. In Central Admin go to Application Management, then Manage Service Applications. Open the Business Data Connectivity Service and select your entity, then select Set permission from the context menu or click on the Set Object Permission button. Once you have permission to the entity the error ...
3
External list data is stored in the external system, and not in SharePoint. SharePoint stores connection information and the schema of the external data.
For client systems only, there is a cache component for the external data (using SQL CE). I think this is the source of the confusion.
3
As usual, there's several ways to pull this off, some better than others.
The "most SharePoint-y" way to do it is using Business Connectivity Services (BCS). That link includes a intro/tutorial on how to use BCS to create "faux lists" that are backed by an external data source, such as SQL (or much more exotic sources!).
Secondly, Sahil Malik wrote a great ...
3
Apparently this is a bug. A possible solution is to use http://localhost/ as the URL, but I think this may still get overwritten by VS when you next open the project. In that case a custom build action may be the way to go for the time being.
3
In case you do not want to use BCS (I am personally not a fan of BCS) there are some third party alternatives. This component from Layer2 for example is very easy to use but maybe best suited for lists without a feature based content type: http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx
In my opinion BCS has these ...
3
You can map User Profile properties to BCS connections as long as there is a unique identifier on your SQL data that can map to a unique property in the User Profile. Here is a blog post that can walk you through it:
http://www.kowalski.ms/2010/07/20/sharepoint-server-2010-supplementing-user-profile-imports-using-bcs/
3
You need to define filter parameters on your read list operation for your ECT in sharepoint designer. For example, create a wildcard filter for text filtering, and set it to default. Then that filter with your selected field will be the default search parameter in your external item picker.
In SharePoint Designer, navigate to External Content Types.
Right ...
2
The BCS can integrate with any system that can be exposed through SQL or Web Services.
I have a strong preference to use Web Services for any integration so that you have a defined integration point that is easier to reuse. If Sage Timberline has published web services then you may be able to connect to them from the BCS. Worst case scenario you can ...
2
One option as you say is to leverage the Secure Store Service (SSS) and allow users to map their credentials of the account they use to access SharePoint your backend system. This mapping is done by the user in a self-service way if it can't find a match, not by an admin.
However if you don't want to do that, you could implement a custom .NET Assembly ...
2
You will need to set up the External Content Type to the correct Office Item Type, by default it is generic list but there are other options available.
Appointment
Contact
Task
Post
There is a good blog here: http://www.chakkaradeep.com/post/SharePoint-2010-Business-Connectivity-Services-Walkthrough.aspx
If you are using a third party tool to create ...
2
A common cause of Access denied from BCS is not having permissions on the External Entity.
To check this navigate to the Business Data Connectivity Service Settings (Central Admin, Manage Service Applications)
You should see the list of external content types.
Check the permissions on the External Entity that displayed an Access Denied error by selecting ...
2
Yes, you can. You need to create them on the External Content type, through SharePoint Designer. Edit your Read List method - and when you configure your Filters Parameters add the filters you need. You should be able to add many filters.
When configuring the filters, make sure you check the "Use to create match list in external item picker".
You should ...
2
The answer is adding the following code to your model:
<FilterDescriptors>
<FilterDescriptor Type="Wildcard" FilterField="Name" Name="Product Name" >
<Properties>
<Property Name="IsDefault" Type="System.Boolean">true</Property>
<Property Name="UsedForDisambiguation" ...
2
Going up through the gears:
1) For a simple scenario, use SharePoint Designer to create an external content type (formerly known as entities) and an external list based on this. Then use the normal SharePoint OM to query that list (or you can use the more powerful BCS Object Model). The SPD tools are surprising powerful and include the ability to pull in ...
2
I am working on a system with exactly the issues you talk about. My observations on your points;
To filter results based on unique IDs such as ClientID you can add a (comparison type) Filter Descriptor to the Finder method of your entity. The limitation I have found with External Lists is that these filters are only exposed by views on the list so for ...
2
The use of BCS for external content types and lists is more suitable for surfacing external data in a familiar format that business users can consume - a SharePoint List. I don't see much of an advantage using it the way you are suggesting.
Have you considered using BCS to augment user profiles to pull in the bio information as a mapped property? This would ...
2
There is an article in the DUET info on MSDN that shows you how to do this: http://msdn.microsoft.com/en-us/library/gg271157.aspx
I think you can do it as follows as well (since an external content type is still a content type; however I have not tested this):
- Create your external list from the
external content type
- Go into the external lists you ...
2
I also stubled over that problem and found the answer in this post:
http://www.silver-it.com/node/92.
It mainly proposes the following:
Remove the association to the event receiver from the model (property "Feature Reeiver"
of the BDC project)
Edit the existing feature that deploys the BDC Model, Add an event receiver to it
Create a new class that derives ...
2
Our solution was to go to SP Central Admin > System Settings > Services on Server and start the "Claims to Windows Token Service". We also found this error in the logs which helped lead us to this as the solution:
SPSecurityContext.WindowsIdentity: Could not retrieve a valid windows
identity for NTName='PRMM-SP\polyadmin',
...
2
I would advise doing any joins/where statements in a SQL Stored procedure and using views to make your query faster. Keep the code inside your web part as simple as possible and toward displaying the data, rather than manipulating it.
While the Linq to SQL will create a SQL query, it may not be optimised to perform well. At least by putting a stored ...
2
Two things here which are affecting performance adversely.
BCS is service application, therefore some WCF service calls are involved
SPList.Items loads all the items of the list before your list before LINQ filters it.
So this approach should not be used on large lists. Using CAML will be better.
Given your scenario I think it's best you query the ...
2
I think the way to achieve a huge performance gain is not use the SPList and LINQ to the external list, but to define either a SpecificFinder-method for the corresponding SQL-query or to add an Filter to the Finder-method.
Then use the direct access to the BCS Metadata-Repository like described Browsing the Metadata Repository and Executing Methods and ...
Only top voted, non community-wiki answers of a minimum length are eligible
