Tag Info

Hot answers tagged

2

As you call it BDC and not BCS i take it you are using SharePoint 2007 (please update tags). BDC for SP2007/MOSS is read only. That being said Lightningtools do support update operations so you might consider the article below http://www.lightningtools.com/bdc-meta-man/business-data-catalog-write-back.aspx


2

Right, I think your error is that the user you are trying to use with BCS is unable to connect to the SQL database. You actually have two different authentication elements to deal with here: 1) Who the User connects to the BCS Service as. 2) Who the BCS service connects to the SQL database as. You actually need to set up 2), then 1) For point 2 you'll ...


2

I ran into the same problem and solved it by replacing the String[] by a IEnumerable<StringWrapper>, or in your case IEnumerable<Personal_nameElement>. This could look like: public class Personal_nameElement { public String Value { get; set; } } And in the BDC: <TypeDescriptor Name="Personal_name" ...


2

The solution is using BCS resources. How to create and import BCS resources: 1) create a file with .bdcr extension 2) add content there like <Model xmlns="http://schemas.microsoft.com/windows/2007/BusinessDataCatalog/Resources" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Name="..."> <LobSystems> <LobSystem ...


2

I think you are trying to create a Business Data Connectivity service using Visual Studio and SQL Server, If thats the case then you can follow this MSDN tutorial. Hope it helps.


2

It seems that you have to add LastModifiedTimeStampField property to your Finder method. Take a look at this blog posts series from Todd Baginski, especially at this one - The LastModifiedTimeStampField property on the finder method instance is set for two reasons. So search results will display the last time the data was updated So the ...


2

For sure it is. Visual Studio 2010 has even a project item template for it. Have a look here http://troyscott.ca/2010/08/07/bdc-models-in-visual-studio-2010-for-sharepoint-foundation-server-2010/ for something to get you started. The ECT gets created automatically by your BDC model upon solution deployment.


1

Figured it out. This rule not working: bdc3://flatfilelobsystem_flatfilelobsysteminstance/Default/00000000-0000-0000-0000-000000000000/3314/FlatFileLOBSystemInstance/3341?s_id=SBAAAAA==MwA=&s_ce=048u0h3o40800080g10200048u10003v55 So, you have to create profile page for your external content type. And exclusion rule works: ...


1

Unfortunately, it was my mistake. The Business Data Catalog works fine with both types, with an element and with an attribute. However, when the wsdl was changed from the one type to another I had to republish BDC schema into the SharedSerfices.


1

If I understand you correctly you want to set the correct web application for your BCS model. Actually any web application that can connect to the BCS service application will do. I ran into the same issue and created a feature receiver for the BCS feature deploying the external content type to set the web application dynamically - so it works in all ...


1

On SE here is something regarding the TypeDescriptor, but I do not think that this is the way for changing the BDC List Column Type. However, I don't know the way to edit it in this way, so I've upvoted your question. There is a similar question on SE here. One of the proposed answers was a link to the SPCascadeDropdowns function in SPServices on codeplex. ...


1

XML Code of Update method : <Method Name="Update"> <Parameters> <Parameter Name="personne" Direction="In"> <TypeDescriptor Name="Personne" IsCollection="false" TypeName="BDCtestProject.BdcModel.Personne, BdcModel"> <TypeDescriptors> ...


1

Andrzej, SPD2010 may need local admin rights to create this connection, it was the case in my setup anyway. What I did is I have created External Content Type with a logged on user who is a member of local administrators on the SQL server, I haven't had time to get to the bottom of this but it worked. I will update this answer as soon as I get this sorted ...


1

Of course Spencer didn't created also the BCS in partitioned-mode, maybe that is why you are not having it too. Have a look on the diagram considering the services that could be cross-farm (http://go.microsoft.com/fwlink/p/?LinkID=167093). I would say your would need to create BCS in multi-tenant mode too. Have a look at this article which asks the right ...


1

I don't understand what you are after. You are saying that you found some places where people wrote piece of BCS ? Why doesn't that work for you? Here is a very good explained guide that I used to connect MySQL with BCS: http://www.dotnetcurry.com/ShowArticle.aspx?ID=632


1

Check the sharepoint logs on the servers when you deploy the solution to see if there were any errors deploying the external content type. Make sure all of the timer jobs are complete too, it might take a while to deploy and refresh.


1

unfortunately so far BCS for SharePoint online can only support Windows Azure data sources. I would try client-side integration like here: http://www.wictorwilen.se/Post/SharePoint-Online-and-External-Data-using-JSONP.aspx


1

Probably two years too late, but I've got the following multi-value property in my Entity that works fine: <TypeDescriptor Name="Subjects" TypeName="System.String[]" /> Note that I didn't specify 'sub' TypeDescriptors, could that be the difference? Also, I'm using FAST, but I'm not sure if that is of any influence... ~Mark


1

SpecificFinder Finder Your web service needs just 2 methods: find just one item - input parameter is unique ID (for SpecificFinder) find list of all items (or optionally filtered list)- if you want to use filters then input parameter can be some filter value (for Finder) IdEnumerator This operation is needed only if you are planning to ...


1

I have run into this problem as well. What i found helped is that if i had external lists generated, i had to re-generate them, then crawl again. Not sure why it worked but it seemed to.


1

Not sure its possible OOB but, BCS Meta Man from lightning tools has this sort of functionality. Are you looking for something like this ? http://lightningtools.com/bcs_meta_man/sharepoint-external-list-using-the-picker-for-foreign-keys/


1

I still have no idea why it wouldn't work, but I circumvented the problem by using a WCF service for the BDC connection instead of an assembly. Suspicions regarding the original cause go towards a 32/64 bit conflict (although compiling everything to 64 bit didn't resolve it) or perhaps a conflict between 64 bit ODP.NET and Win 2k8 ("The 64 bit ODP.NET for ...


1

I developed a simple converter, which performs basic alterations of 2007 bdc app definition files to make it compatible with SP 2010. It may be useful for somebody else. This tool automates some steps described in the given 'How to'. The converter is accessible here - ...


1

Steve's solution should work nicely for you. It is also possible to import a SharePoint 2007 Application Definition File and upscale it using BCS Meta Man, this will create your BCS Model with a .Net Connectivity Assembly. *I do work for the company who make the product


1

What I did is during one of my early upgrade testing, I did an inplace upgrade. After that, I used SP Designer to export my upgraded BDC models. Then I could manipulate them if needed and import them into my final content database migration.


1

you can copy and paste the XML model from SharePoint Designer into the VS model file if you open it in an XML editor. It will be exactly the same as the SPD one though so you'd need to make quite a few changes to call code methods instead of SQL queries. If you try out BCS Meta Man: BCS Meta Man You can open a model created in SharePoint Designer and it ...



Only top voted, non community-wiki answers of a minimum length are eligible