Microsoft SharePoint Team Blog

Business Data Catalog Definition Editor tool (or "BDC tool") The Business Data Catalog Definition Editor

Finalmente..... The Business Data Catalog Definition Editor tool (or "BDC tool") is now available in

Finalmente..... The Business Data Catalog Definition Editor tool (or "BDC tool") is now available

finally! thanks!

bye bye bdcmetaman

I seem to have trouble installing on a danish Windows XP, as the BUILTIN\Users group that the installation seem to access, is called BUILTIN\Brugere (Users in danish) and therefore can't find it.

But very nice work, will try it on a 2k3 development server.

Hi, I am installing BDC Editor, but I get an error when I install it.

Details of my system:

- Windows XP (Spanish version).

- SQL Server 2005 (English version [with Spanish version I get the same error]).

Message Error:

Unexpected Error has ocurred. Error is 'Error de Crear para Usuario 'BUILTIN\Users'.'--> Error de Crear para usuario 'BUILTIN\Users'. --> Excepción al ejecutar una instrucción o un proceso por lotes Transact-SQL --> Windows NT user or group 'BUILTIN\Users' not found. Check the name again.

I suppose that is an error with the not English Users group. In Spanish OS is the "Usuarios" group instead of "Users" in English systems. I think that is an error with not English OS is it?.

It would be very insteresting get a fix for this error ASAP in the installation of BDC Editor.

I hope that helps.

I am long overdue for a good "Sharepoint in the Manufacturing Enterprise" post, but I didn't

Ever since March I knew there was a BDC editor from Microsoft coming up. Just last week when I was having

Hi all, Just want to make sure that you saw the announcement for the new Microsoft Business Data Catalog

Hi, came across the same problem ('BUILTIN\Users') as Jorge Serrano and Christian Sparre for the installation of BDC Definition Editor on a German Windows 2003 Server OS.

I'd appreciate if you could give a workaround how to fix it.

Thanks for the tool; it's quite timely, as I've just started researching BDC as an option for our internal processes.  However, I'm getting the following error: "Backend system adapter returned a structure incompatible with the corresponding metadata (MethodInstance, Parameter or TypeDescriptor)" - without being able to see exactly what's returned, I'm not sure I can figure out what went wrong.  A viewer would be nice.  

Installation seems to fail when a SQL Server installation is in place. I tried installation on both my local machine (winXP) as well as our development server (win2k3). Both installations fail on the same error: "SetParent failed for Database AS633244309859138088" and "Failed to connect to server .\BDC.

Any ideas where this might be coming from? I'm using admin account for installation, which have all permissions on the SQL Server instances.

I also get the error "There are no Business Data Types loaded in the Catalog". Did anyone at all get this tool to work?

In order to consume the BDC connections via BDC Web Parts, you must add a Finder method using the tool.  The tool will automatically set up IDEnumerator and FindSpecific method instances for databases, but you must manually add the Finder method instance.

I get 'Unknow error "-1"' when I try to install BDC Editor.  This error is displayed after the 'Confirm Installation' step.  My OS is Windows XP.  The SQL Express and .NET 2.0 installation seem to have succeeded.  Can any one let me know what is going wrong here?  Appreciate your help.

Hi Brian,

any new information about the error with Builtin\Users?

Thanks in advanced,

Jorge

Hi,

i have the same problem with the Builtin\Users.

Any workaround available?

Best regards,

Daniel

Hi Brian,

I also have the BUILTIN\Users problem on Windows Server 2003 (Dutch). When is that programmatic fix coming? In the meantime, is there no workaround available?

I have downloaded the MOSS SDK 2007. But when I try to install it it says another version of this product is already installed cannot continue..

I have MOSS instlled on my machine(Enterprise version) but could not find the BDC Editor. I want to install for BDC editor.

  Is BDC editor available separetely or is it already installed on my machine in some location .

  Plz help

Pre tých čo sa zaujímajú o Microsoft Sharepoint, buď zo tvedavosti ale z povinnosti, krďže

I am looking for a example of using the BDC without SSO. Basically I have a MS SQL database and was provided a sql read only account.

Any example of this? Is it even possible without SSO?

Hello, with the problem of error in creating builtin \ users already saw it resolved in a forum, I have not tried but the author says that only by the version of the operating system that is if Spanish signaled that mistake, try to change the version the system, and if the response is successful, I hope I write

As nice as it is to include SQLExpress with the BDC editor, it`s a real pain in the ass for those of us who are installing into a VM that already has a SQLExpress instance (typically feeding the MOSS instance there also). Why am I forced to install a second instance of SQLExpress? please provide instructions to leverage an existing sql server when installing BDC Editor.

I was able to install the tool. There is a setup.exe in the directory for the BDC editor. Run this before you run the MSI for the editor. This installs the instance of SQL Express the editor looks for.  

However I did run into some issues with the editor while using it.

-Some of the Business Data web parts aren't working with the data (let me know if you need to know which ones)

-With the adventure works database I'm finding that the tool will only work with the dbo schema and not the others such as HumanResources, Person or Production.

The editor appears to be a great tool if you can work around its quirks.

I have downloaded the MOSS SDK 2007. But when I try to install it it says another version of this product is already installed cannot continue..

If you want to play with a sample database, I strongly recomend the AdventureWorksBI.msi (http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004).

The other one have issues.

業界最安値宣言！ここがウワサのコンタクトレンズ超激安店！<a HREF="http://www.gekicon.com/">ザ・激安 コンタクトレンズ通販</a>はあなたのニーズに合った各種コンタクトレンズを販売しています。<a HREF="http://www.gekicon.com/1-day.html">1日使い捨て コンタクト レンズ</a>のワンデーアキュビューは毎日取り換えるわかりやすさが大好評。

Hi,

Good Work

I wanna know how can we extend Buisness Data Catalog with asp.net code or web custom controls

When we create custom web parts we inherit WebParts Class

What Class will be Inherited to make BDC Compatible Web Parts,Because BDC Web Parts Contains several properties

thanks

Prashant

Has anyone installed it on Vista?

I get an error

Source MsiIstaller

EventID 10005

Product: Microsoft ®  Business Data Catalog Definition Editor -- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2869. The arguments are: ErrorDialog, ,

I just took the install package from Win2003 Server (after installing the SDK there) to run it on Vista.

Thanks

Martin

Why is it that in August 2008, the BDC Editor tool still doesn't work?

I've been trying to get it to work on my SharePoint development box for a week now, but not matter what way I connect to the local SQL Server (Windows authentication as local Administrator or the "sa' account), I still get the error message when I try to drag the Employee table of the AdentureWorks database into the design surface:

Could not process Table "Employee'.Make sure you have SELECT Rights on the Table/VIEW.

I can query the table from SQL Server Manager or Server Explorer in Visual Studio 2008 with the exact same connection (as Administrator), so I conclude this tool is B.A.D. (Broken As Delivered).

My connection string from Administrator is:

Data Source=.;Initial Catalog=AdventureWorks;Integrated Security=True

I'm using SQL Server 2005 Enterprise Edition 9.0.3239 SP2 on Windows Server 2003 R2 Enterprise Edition SP2, if that matters.

I totally agree with ALEXANDERN.  Except in my case I DON'T WANT SQL EXPRESS ANYWHERE NEAR MY SQL SERVER 2005 INSTANCES!

Why do you guys always require Express with any data-driven tool that you provide?  Why can't I choose to use my currently installed SQL Server 2005 instance?

Installing SQL Express generally screws up all machine.config settings that have painstakingly been set.  Let us use SQL Server 2005 as an option!

I had the error with SQL Express, try running the .msi instead of the setup.exe. Worked for me. So far the install is the only thing that has worked for me though!