Business Data Catalog

MOSS 2007 and the Business Data Catalog feature

Jason Medero's SharePointing into Collaboration — Wed, 19 Apr 2006 06:52:37 GMT

Tech Talk PT » Blog Archive » Businnes Data Catalog

Tech Talk PT » Blog Archive » Businnes Data Catalog — Wed, 19 Apr 2006 11:13:59 GMT

PingBack from http://techtalkpt.wordpress.com/2006/04/19/businnes-data-catalog/

re: Business Data Catalog

Jerry — Wed, 19 Apr 2006 11:20:28 GMT

Hi,

Very Nice entry. BDC is a great. It looks like the next version is powerful enought to communicate with other systems or API. The provided web parts looks pretty simple and easy to use. But i guess the real thing is defining the Business Data Catalogue. I have few questions.
1. What kind of APIs that BDC can support, I mean can i reuse\configure my existing Logic (Dlls, Webservices, objects).
2. What point should developers must take in mind in developing DB solutions that can later laverage MOSS 2007 BDC.
3. How to configure BDC. Can a normal SharePoint Aministrator can configure BDC or any development experience or knowledge is requrired.

Regards
Jerry

Randy Holloway Unfiltered 2.0 » Google and Microsoft- Enterprise “Mashups”?

Randy Holloway Unfiltered 2.0 » Google and Microsoft- Enterprise “Mashups”? — Wed, 19 Apr 2006 14:32:39 GMT

PingBack from http://randyh.wordpress.com/2006/04/19/google-and-microsoft-enterprise-mashups/

Business Data Catalog with SharePoint 2007

Luis_DG's Blog — Wed, 19 Apr 2006 15:46:27 GMT

re: Business Data Catalog

Lawrence Liu — Thu, 20 Apr 2006 06:26:30 GMT

Jerry, the BDC uses ADO.NET to connect to practically all popular databases out there by way of native ADO.NET providers for SQL Server 2005 and Oracle, OLEDB providers for SQL Server 2000, and ODBC drivers for older databases. The BDC can also use a Web Services proxy to connect to any Web Services based API.

The BDC has been designed primarily for connecting, mapping, and fetching data rather than transforming or aggregating.

Documentation on configuring the BDC, creating the XML based metadata definition file for each business application, and leveraging the API for the BDC will be available upon Beta 2 available later this quarter. There is already some of this documentation available with the Beta 1 Tech Reference at Microsoft BetaPlace for current beta testers.

re: Business Data Catalog

neo — Mon, 24 Apr 2006 12:29:41 GMT

Hi
I read an article about open source upcomming version of wss, is it true? and where can I read complete article from Microsoft web site?
Thanks a lot

re: Business Data Catalog

Richard Brown — Mon, 24 Apr 2006 22:24:19 GMT

Oh dear. Now it's the "2nd quarter". I can't wait to get this!

re: Business Data Catalog

Lawrence Liu — Tue, 25 Apr 2006 01:40:44 GMT

Neo, open source version of WSS V3? Where did you read about that?

Richard, "2nd quarter" could be tomorrow or end of June or somewhere in between. :-) We're getting very close to Beta 2, so hang in there!

re: Business Data Catalog

shocksll — Tue, 25 Apr 2006 17:24:20 GMT

Will the bdc allow us to pull in data into survey's, etc. The biggest issue we have right now with sps2003 is the ability to view/use lists that are located on another site/area.

For instance, we have a list of offices. We'd like that list to be displayed on our homepage, so that is where the splist is located. But we also like to use that list in a survey that is located in another area. We can't seem to figure out how to use a lookup on a list that is located on another site/area. So we end up copying the data to the site/area the survey is located and now we have a duplication of data and when one gets updated the other doesn't.

I would love to see some type of virtual list in 2007 where the data can actually exist somewhere else but be able to view/interact with it as a splist on a site/area.

Does the bdc allow us to do this? If not, is there something in the works that will? Thanks.

re: Business Data Catalog

shocksll — Tue, 25 Apr 2006 20:48:48 GMT

Also, BTW, the open source thing was posted here

http://microsoft.bilsimser.com/04-01OfficeOpenSourcePR.htm

I'm pretty sure it was an April Fools joke. ;-)

re: Business Data Catalog

Lawrence Liu — Wed, 26 Apr 2006 12:05:19 GMT

Shockall, the BDC enables business data to be surfaced on any SharePoint List, including surveys. See http://blogs.msdn.com/photos/sptblog/images/583931/original.aspx for a screenshot of a test survey question that I created and associated it to the new Business Data field type. Then see http://blogs.msdn.com/photos/sptblog/images/583933/original.aspx for a screenshot of the bottom of that same page where I can specific the business application (the sample AdventureWorksDW in this case) and field (Name) as well as additional fields from the business app to associate with this custom survey question.

Separately, Bil Simser's blog entry about WSS V3 going open source was definitely an April Fool's joke. :-)

re: Business Data Catalog

Lawrence Liu [MSFT] — Fri, 05 May 2006 00:41:10 GMT

For those of you interested in learning more about the BDC, a community driven project space has been created on GotDotNet CodeGallery at http://codegallery.gotdotnet.com/bdc.

SharePoint 2007 Business Data Catalog

SharePointless — Thu, 11 May 2006 04:31:03 GMT

SharePoint 2007 Business Data Catalog

SharePointless — Thu, 11 May 2006 04:37:56 GMT

SharePoint 2007 Business Data Catalog (BDC)

SharePointless — Thu, 11 May 2006 16:36:27 GMT

SharePoint 2007 Business Data Catalog (BDC)

SharePointless — Thu, 11 May 2006 16:38:14 GMT

re: Business Data Catalog

BruceLi — Fri, 12 May 2006 11:09:40 GMT

Does the Office Server in Office 2007 Beta1 TR include the BDC web parts?

Thanks,
Bruce

Update on community activities

Lawrence Liu's Report from the Inside — Tue, 16 May 2006 12:25:46 GMT

&nbsp;&nbsp; I’ve been extremely busy at work, which is the primary reason why I haven’t posted anything...

Business Data Catalog

SharePoint Resources — Tue, 16 May 2006 22:10:31 GMT

[Via SharePoint Team Blog] The BDC is essentially a catalog of business applications that are of interest...

SharePoint Conference, Day 2

Blah Blah Blog [Ryan Rogers] — Wed, 17 May 2006 06:11:48 GMT

Day Two at&nbsp;SharePoint Conference 2006 in beautiful downtown Bellevue, WA today.&nbsp; I proctored...

Business Data in Sharepoint 2007 Lists

Duray Akar's Blog — Fri, 19 May 2006 22:08:13 GMT

What's new in SharePoint, in Sesame Street Markup Language

Marwan Tarek Blog — Sun, 21 May 2006 18:38:34 GMT

The Enterprise is Dead ... Long Live the Enterprise

Cliff Reeves — Thu, 01 Jun 2006 20:43:58 GMT

... or&nbsp;it certainly seemed that way at the Dow Jones:Enterprise Ventures Conference yesterday at...

BetterECM - russ stalters’ Blog on Exploring NextGen ECM » Three of The Most Important New Features In Office 2007

Sun, 11 Jun 2006 22:46:31 GMT

PingBack from http://betterecm.wordpress.com/2006/06/11/three-of-the-most-important-new-features-in-office-2007/

2007 Microsoft Office Server System Reference Material

The Boiler Room - Mark Kruger, SharePoint MVP — Mon, 12 Jun 2006 20:22:17 GMT

Download SharePoint Beta2:

Important Documentation Prior to SharePoint Beta 2 Installation
Get...

re: Business Data Catalog

randalli — Fri, 16 Jun 2006 19:33:34 GMT

The in-depth SDK documentation for Business Data Catalog is now live on MSDN: http://msdn2.microsoft.com/en-us/ms551230(office.12).aspx (links to the Overview).

You can also download the SDK and several metadata samples from the following location: http://www.microsoft.com/downloads/details.aspx?FamilyID=6d94e307-67d9-41ac-b2d6-0074d6286fa9&DisplayLang=en

Hope this helps,
Randall

Content Manager
Office Server Group Developer Documentation
Microsoft Corporation
http://msdn.microsoft.com/sharepoint
http://msdn.microsoft.com/office

Hello Boston [Tech-Ed 2006 Day 4]

choral's blog — Fri, 16 Jun 2006 19:53:33 GMT

Which BCD tool should I use?

Fear and Loathing — Tue, 18 Jul 2006 07:10:37 GMT

I was a little confused (as I often am) earlier today as I noticed Todd Baginski has put together a tool

MOSS BDC - ADF

Olaf's Blog — Tue, 18 Jul 2006 10:01:38 GMT

Immer diese Akronyme... ;)
Um die im Title verwendeten Akronyme mal aufzulösen, hier der vollständige...

MOSS BDC MetaData Manager

SharePoint, SharePoint and stuff — Tue, 18 Jul 2006 16:47:33 GMT

Todd Baginski hat einen Assistenten für das Erstellen von Business Data Connector Dateien gebaut und...

re: Business Data Catalog

AndreiT — Thu, 20 Jul 2006 02:34:24 GMT

Customized search experience against indexed BDC is very nice, yet it assumes that we can run MSSQLFT Query against this content source. My problem is, I can not make any simplest SQL query (tested on SPS 2003!) to work with SPS 2007, e.g. something like:

SELECT "DAV:href", "DAV:displayname" FROM Non_Portal_Content..SCOPE()
WHERE CONTAINS('Foo')

fails miserably against SPS 2007 Beta 2. Has anybody tested SQL Queries with SPS2007? May be they do not work as yet, and I just have to wait?

re: Business Data Catalog

AndreiT — Thu, 20 Jul 2006 23:57:33 GMT

I have given up (for a while) wrestling with QueryService of SharePoint 2007 - I cant' make it work with <QueryText language="en-US" type="MSSQLFT"> , and resorted to Object Model - using FullTextSqlQuery object.

More or less it works, however I can't find by SQL query any BDC-indexed item (keyword query successfully finds them). I suspect that it has to do with the FROM clause - the 2007 documents say FROM SCOPE() is the only option here. Assuming that I have defined a content source "BDC" (which indexes BDC data), how should I build a query which extracts items indexed from that content source?

NB: I have mapped crawled BDC properties to managed ones, and I can see my BDC items in MSSDocProps table, with all their properties correctly found and mapped. Yet SQLQuery does not find them.

re: Business Data Catalog

LLiu — Fri, 21 Jul 2006 08:13:11 GMT

AndreiT, you may have better luck getting your questions answered in the BDC project space on GotDotNet (http://codegallery.gotdotnet.com/bdc) or the SharePoint newsgroups listed at the SharePoint Community Home Page (http://www.microsoft.com/sharepoint/community).

re: Business Data Catalog

mataalla — Tue, 25 Jul 2006 05:52:42 GMT

I want to create a BLOG site with a survey.
I want each blog entry to have a voting poll (say 2-3 questions) - just as blogs have ratings. However, i don't want this to be submitted with the comment (so it is seperate). Then on the blog entry summary page (AllPosts.aspx) I want to show the voting results next to each entry and allow sort/filter by certain results of the vote.

Any ideas? do i need to store the voting results in a database and connect using BDC, or is that an overkill?

re: Business Data Catalog

Bruce Dhara — Thu, 27 Jul 2006 18:19:08 GMT

Team,

Presently I am working with BDC (MOSS 2007) & there is no sample/examples on webworld available right now. I will be posting my Code on Codeproject.com pretty soon.

However, if anyone of you are using BDC or working with it, I have extracted some troubleshooting tips during connection/extractions :

Tip #1: Understand the Metadata Model

You must read the Business Data Catalog Metadata Model section and understand how to write each metadata element. The topics also list supported children and properties and their limits and accepted values in each topic. Also review the comments in the AdventureWorks 2000 and the SampleWebService metadata XML.

Tip #2: Use incremental imports

When authoring metadata, try importing one entity at a time, so you can identify and debug problems more easily.

Tip #3: Use line number information to identify metadata import errors

When you try to import invalid metadata, the Business Data Catalog displays an error message explaining the problem and the line number where the error occurred. It will be helpful to open the XML in Visual Studio, use Edit -> Go to to locate the line where the error occurred and reviewing the XML statements near that line.

Tip #3: Look at the Server Event Log and the ULS log files for business data client (runtime) errors

If you get an error when you try to use a Business Data Web Part or a Business Data column or the object model, check the server event log in Central Administration (or the Windows Event Viewer on your server) and the ULS server logs. Business Data Catalog writes messages and run-time exceptions to the event log and in ULS log files.

The ULS log files contain a copy of the event log information plus contain the stack trace. Hence, the event logs are friendlier than the log files.

Business Data Catalog creates a new ULS log file every 30 minutes. You can find the log files in the <drive>\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS folder. Log files contain useful information about all the run-time exceptions and can help you identify problems. You can also throttle

In the ULS logs, messages are categorized and contain the following fields:

Timestamp

PID - Web client errors show up under the w3wp.exe pid. Search and user profile import errors show up under mssdmin.exe pid.

TID

Product

Category (the Category field is Business Data for Business Data Catalog-related errors)

EventID

Level

Message

Correlation

An easy way to find Business Data Catalog-related messages is by searching for "metadataexception" or "ApplicationRegistry" or "Exception" in the Message field and looking under the Business Data category.

Bruce M Dhara
Sr Developer.

re: Business Data Catalog

LLiu — Thu, 27 Jul 2006 23:00:53 GMT

Bruce, visit the BDC community space at http://codegallery.gotdotnet.com/bdc for code samples and help.

<Lawrence />

re: Business Data Catalog

njg — Thu, 03 Aug 2006 02:45:35 GMT

Does any one have an idea of whether business portal (Dynamics) will run on Sharepoint 2007 server and support forms based authentication?

Where is the appropriate place to post this question?

re: Business Data Catalog

Kris — Tue, 29 Aug 2006 05:01:32 GMT

We are working on a prototype for the BDC to showcase to the capabilities of MOSS to the management. There are about 1000 documents we need to upload to a Shared Document Library list which has associated "Business Data" programmatically. I am able to upload the files to the document library using the MOSS object model but cannot set the "Business Data" associated with the file. How can I programmatically update the "Business Data" column for a file assuming I have all the data I need for the Entity? Can anybody give me pointers. I am looking all over the web but cannot seem to find a hint. I would sincerely appreciate if somebody could respond to this.

Thanks.

Business Data Catalog

My two bits — Tue, 29 Aug 2006 11:55:10 GMT

Business Data Catalog

re: Business Data Catalog

Tim — Tue, 29 Aug 2006 21:56:17 GMT

Kris,

In response to your query...

>> There are about 1000 documents we need to upload to a Shared Document Library

We have a Bulk Import product that does pretty much what you want. It is already available for SPV2 and we are currently porting it over to MOSS2007. Please take a look at our web site http://store.bamboosolutions.com/pc-36-6-list-bulk-import-available-late-august.aspx

Cheers,

Tim
(Sorry, I don't usually promote products in blogs, but I think this might be helpful)

re: Business Data Catalog

LLiu — Wed, 30 Aug 2006 11:24:05 GMT

Kris, while most likely not having as many features as the Bulk Import product that Tim suggested, there will be an Import/Export Framework and Tools for SharePoint project posted on CodePlex within the next couple of weeks, which will provide source code for an import utility for WSS V3 that you can modify to potentially suit your needs. Look for it on CodePlex (http://www.codeplex.com) soon.

re: Business Data Catalog

Chris — Wed, 30 Aug 2006 14:19:51 GMT

Hi !

You did an outstanding job in designing all of these functionalites for integrating LOB data into SharePoint. I really love it! :-)

I'm wondering, if there are some application definition samples for Microsoft Dynamics CRM 3.0 available. I've some difficulties with System.Guid Identifiers in the SpecificFinderMethod...

Thanks!

re: Business Data Catalog

Malliakrjun — Tue, 05 Sep 2006 08:12:07 GMT

Hi,

Explation required on
How to customize serch center to associate BDC with it?

re: Business Data Catalog

Manoj — Thu, 07 Sep 2006 15:39:11 GMT

Is it possible using BDC to connect to an Excel file. Dont see any samples for this.

re: Business Data Catalog

Dave C — Thu, 14 Sep 2006 06:49:24 GMT

I have a question about BDC and Document Libraries....If place a Business Data column in a document library, and then create a new document in Word. The column is there (as are related columns from the Entity), but it doesn't look like I get any of the "finders". I can type the exact KEY and it will find the relevant Entity. Are finders supposrted from the Document Information Panel?

Also, at what point is BDC data updated in the list, OTHER than when the user HITS the Refresh data key? Can this be controlled?

re: Business Data Catalog

sam_n99 — Sun, 24 Sep 2006 14:11:16 GMT

As you know, systems like Hummingbird, or LiveLink has more options to design a relational Metadata (One To Many), I mean a record or document may has field called Subjects (Like Library Management Systems) to cataloging and classifying this document, this field should link to another table to get the subjects from. and this field should be multivalue.

In fact, so far I found tool like Bussines Data Cataloge (BDC) very usefull. BDC can link to any table in SQL Server and get the value, but when you declare the column that binding with BDC, you have not any choice to make this column multivalue, so its (One To One) relation and we have not a relational metadata :( ??!!

Office 2007, SharePoint Server 2007 e WSS

Raul Ribeiro — Tue, 26 Sep 2006 13:38:36 GMT

SharePoint 2007 - General information SharePoint Server 2007 - Hidden gems Microsoft Office SharePoint

MOSS 2007 and BDC « No cuido….

MOSS 2007 and BDC « No cuido…. — Wed, 04 Oct 2006 13:38:58 GMT

PingBack from http://nocuido.wordpress.com/2006/10/04/moss-2007-and-bdc/

2007 MOSS Resource Links

Michell Cronberg — Thu, 05 Oct 2006 18:58:50 GMT

Michell Cronberg - 2007 MOSS Resource Links

Michell Cronberg - 2007 MOSS Resource Links — Thu, 05 Oct 2006 18:58:53 GMT

PingBack from http://blog.cronberg.dk/PermaLink,guid,fb1151e6-fd5a-4752-a8b2-3afbd8ebff43.aspx

re: Business Data Catalog

BobC — Thu, 02 Nov 2006 21:35:39 GMT

I did get this to work on a clean install of MOSS B2TR, but when I try to connect it to a BDC web part, I get errors like:

(Column titles DO display)

The Business Data Catalog is configured incorrectly. Administrators, see the server log for more information.

In the server app error log:

A Metadata Exception was constructed in App Domain '/LM/W3SVC/669577904/Root-1-128069273844023446'. The full exception text is: The Property with name 'SsoApplicationId' is missing on the LobSystemInstance.

re: Business Data Catalog

BobC — Mon, 06 Nov 2006 23:36:16 GMT

I'd like to know what type of connections can/should be made using BDC and user profiles. I'd like to allow updates to AD or ADAM, and wonder if BDC could facilitate this.

Crawling Contents in LiveLink 9.5

TedW — Tue, 14 Nov 2006 09:08:18 GMT

Is there an easy way for SharePoint Search to crawl and index contents stored in OpenText LiveLink system? Maybe by using BDC or using custom code integrated with SharePoint. And upholding permission settings set by LiveLink would be nice, but not sure if that is possible...

Basic and Advanced Deployment in a Nutshell

Joel Oleson's SharePoint Land — Tue, 14 Nov 2006 09:36:14 GMT

Thanks to those of you who partipated in my SharePoint Connection basic and advanced Deployment talks

re: Business Data Catalog

jcherrera — Wed, 29 Nov 2006 06:35:07 GMT

Hola, tienes algun link de BDC pero en el RTM?, puesto que ya instalar el RTM de SPS2007 y tanto las pantallas de configuración como el proceso de registro del xml de configuracion cambia y no he encontrado informacion de como utilizarlo...

gracias

re: Business Data Catalog

Ed Richard — Tue, 05 Dec 2006 07:59:42 GMT

I have the saem question as Kris (26/8/206).

The tool on Codeplex doesn't seem to help me. Any pointers on how to update the BDC-Columns on a programmatically updated Item. Just assigning a value doesn't seem to do anything.

We have thousands of documents to migrate and this is the only thing we can't solve at the moment.

TIA,

re: Business Data Catalog

Arulraja — Tue, 12 Dec 2006 09:27:18 GMT

i got below error while loading application definition file.

Application definition import failed. The following error occurred: The root element of a valid Metadata package must be 'LobSystem' in namespace 'http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog'. The root in the given package is 'LobSystem' in namespace 'http://schemas.microsoft.com/office/sps/2005/bdcMetadata'. Error was encountered at or just before Line: '1' and Position: '2'

Regards,

Arulraja.S

re: Business Data Catalog

Arulraja — Tue, 12 Dec 2006 09:27:21 GMT

i got below error while loading application definition file.

Regards,

Arulraja.S

Attempting to set a BDC column using 'UpdateListItems' on 'Lists.asmx'

Sam — Fri, 22 Dec 2006 06:07:35 GMT

Hi,

I've tried setting a BusinessData type column for a file using the 'Lists.asmx' UpdateListItems webservice method, but can't get it to work. Though I can set the primary BDC column (for example 'Person'), the webservice won't let me set the 'RelatedField' (People_ID) with the long ID number (eg '__ck74754356465.....').

I am high experienced with setting all other SharePoint types (choice, datetime, lookupmulti etc) but haven't been able to find any information on this yet.

Thanks heaps in advance

Sam

Niche Pot - Make Money - PS3 - TMX Elmo » Blog Business Summit definition of Blog Business Summit in computing (Blog business)

Sun, 31 Dec 2006 03:39:57 GMT

PingBack from http://nichepot.com/news/blog-business-summit-definition-of-blog-business-summit-in-computing-blog-business/

re: Business Data Catalog

ccalcut — Thu, 04 Jan 2007 04:47:48 GMT

Has anyone found a solution to this error. I have been getting it as well and have found no answers. I am running SQL 2005 on Windows 2003 Enterprise Server and RTM MOSS. Any help would be great. My email is ccalcut_at_gmail_dot_com if it doesn't show up on my MSDN profile.

****I did get this to work on a clean install of MOSS B2TR, but when I try to connect it to a BDC web part, I get errors like:

(Column titles DO display)

The Business Data Catalog is configured incorrectly. Administrators, see the server log for more information.

In the server app error log:

re: Business Data Catalog

ulfwes — Mon, 15 Jan 2007 18:42:14 GMT

Sam, check the EntityDataTableAdapter for the __serializedId property when generating a datatable.

re: Business Data Catalog

Toby — Tue, 16 Jan 2007 11:49:23 GMT

Hi,

I am working with a web service, i have managed to handcraft a BDC that correctly searchs my ws, i am returning an user defined data object from the ws. However, i can't manage to replicate this in code in order to create the BDC automatically.

Any ideas?

re: Business Data Catalog

chris — Thu, 18 Jan 2007 04:24:02 GMT

does anyone know how to add a bdc column as a lookup field in a regular list?

re: Business Data Catalog

Byron — Fri, 19 Jan 2007 07:39:28 GMT

Does anyone know how to go about connecting a BDC Data List WP to a BDC Related List WP? Sounds pretty straight forward at first glance, I know, but here's the problem though, the BDC List WP and the BDC Related List WP are connected to two different data sources which have different primary keys. Can an association still be created in this scenario? Perhaps the using the Business Data Item Builder for this? Thoughts?

re: Business Data Catalog oracle

Nidhi Seth — Wed, 31 Jan 2007 23:09:07 GMT

If anyone is interested in writing a application definition file to connect to oracle, here is a blog from me:

http://sethnidhi.blogspot.com

Nidhi Seth

Bussiness Data Catalog does not work with Guid identifiers

Hendrik — Fri, 02 Feb 2007 16:16:58 GMT

whenever you try to use the type System.Guid as an identifier in your BDC application definition the following exception is thrown:

System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

Business Data in Content Types

Ron — Sat, 03 Feb 2007 00:21:35 GMT

Any way to define a Content Type in SharePoint 2007 that references Business Data? My end solution would look something like...using a content type template, a user would select business data from our LOB system. Using fields in word, map that business data directly into the Word fields. Viola, you end up with a document populated with data directly from you LOB system. Any thoughts on how to do this out of the box in SharePoint 2007?

re: Business Data Catalog

Dave — Mon, 05 Feb 2007 21:58:02 GMT

I'd like to hear a response to the question above about Business Data in Content Types posed above...

This seems to be the whole point of having BDC columns, and using them in a Document Library...

This capability was available (Content Types with BDC Colums) prior to Beta2TR, and was removed.....

Thanks

re: Business Data Catalog

rahim — Tue, 06 Feb 2007 20:29:38 GMT

Hi,

I don't know if I have posted this question in the correct place, but when I import an application definition file on MOSS2007 it gives error

Could not create profile page for entity <MyEntityName>. The error is: Cannot create a new connection to closed web part "g_813e1ec9_c1ce_4d69_ab7d_3ef226d74bb8"

It does add the entity to the application but when I try to place this entity in a Business Data List webpart, it generates the same error on the server log file and does not allow me to use this entity.

re: Business Data Catalog

ananth — Thu, 08 Feb 2007 15:09:06 GMT

Hi there

i am getting similar error as poseted by Rahim above. could someone reply if they know how to fix this error please?

thanks

ananth

re: Business Data Catalog

Nidhi Seth — Thu, 08 Feb 2007 20:40:19 GMT

Rahim / Ananth

Can you post/send your Applicatin Definiton File.

Nidhi

re: Business Data Catalog

ananth — Fri, 09 Feb 2007 08:58:42 GMT

Nidhi, whats your email alias please?

thanks

ananth

re: Business Data Catalog

Mel — Sun, 11 Feb 2007 02:46:51 GMT

In my Business Data Catalog/ Application dropdownlist the Change Settings not visible on dropdown list.

How can I enable it for my Business Data Catalog Applications ?

re: Business Data Catalog

MSCOM.NET — Tue, 13 Feb 2007 21:03:27 GMT

Is it possible to connect to PeopleSoft.

Leveraging BDC for SAP integration

nicolasl — Sat, 17 Feb 2007 00:04:43 GMT

I attended a great webcast by Mike Fitz a few weeks ago. Included was a compelling demo showing SAP information displayed in MOSS 2007 through BDC.

Is Microsoft planning to share the metadata used for that demo? I try not to reinvent the wheel if I dont have too, and obtaining that XML metadata will cut through hours of xml tweaking.

LOB integration is a strong selling point for migration to MOSS 2007, and my clients are eager to pull SAP information into their SharePoint portal. Not to mention that SAP integration is a strong push at Microsoft!

Nicolas L.

re: Business Data Catalog

Nicole — Wed, 21 Feb 2007 12:27:57 GMT

This question was already asked twice, but not answered yet.

Has anyone an idea what to do with this exception:

A Metadata Exception was constructed in App Domain '/LM/W3SVC/352480820/Root-1-128164404474871104'. The full exception text is: The Property with name 'SsoApplicationId' is missing on the LobSystemInstance.

I've created the BDC file with BDC Meta Man. The other tool, MOSS BDC Meta Data Manager, doesn't work either for me!?

Has anyone ideas?

re: Business Data Catalog

Luke — Thu, 22 Feb 2007 16:42:59 GMT

@Rahim / Ananth and Nidhi

I have exactly the same Problem. For AuthenticationMode I use "WindowsCredentials" and have added a "enterprise application definition" with the same ID as the value from the Proporty "SsoApplicationId" in my BDC xml file.

I can't understand the error. I also deleted all my colsed Web Parts on Sharepoint.

@Mel

I can feel whit you. i have the same problem

re: Business Data Catalog

Steve Lineberry — Thu, 22 Feb 2007 17:19:27 GMT

I also had this same issue until I read somewhere that using certain types of AuthenticationMode require SSO, thus the error because I assume you aren't using SSO. I got it working by using the AuthenticationMode of RevertToSelf and adding my SharePoint Service Account read access to the DB.

re: Business Data Catalog

Peter J — Wed, 28 Feb 2007 22:16:32 GMT

Hi, How does the BDC 'crawl' a web service. Is there an ability to specify a range of values for some sort of index field?

re: Business Data Catalog

shyju mohan — Mon, 19 Mar 2007 15:26:11 GMT

You can view my blogs for configuration

http://shyjumohan.blogspot.com/

re: Business Data Catalog

Ting Fong — Wed, 21 Mar 2007 05:47:23 GMT

Hi, I have uploaded the Sample Amazon Web Service BDC to my SSP, however, when I try to get it out and display data in BDC web part, I was being throw an error stating that there is no BDC file uploaded.

Any idea?

Thanks.

re: Business Data Catalog

Shekhar — Sun, 08 Apr 2007 02:44:31 GMT

We have a custom ADO.NET provider written for our datasource and I want BDC to use our data provider. Is there a way to specify custom ADO.NEt providers in BDc metadata.

Thanks

re: Business Data Catalog

Jim Shelton — Fri, 27 Apr 2007 02:32:18 GMT

I have a BDC application that works for authenicated users. I have not been able to get it working for anonymous users. What are the methods and best practices for enabling anonymous access to BDC data and BDC web parts?

Thanks

re: Business Data Catalog

Rajeev — Mon, 21 May 2007 13:21:16 GMT

Hi,

i installed MOSS 2007, and also create SSP. but in Shared Services Administration page i cannot see Business Data Catalog section. is i am missing any thing??

Any idea?

Thanks.

re: Business Data Catalog

Greg — Thu, 31 May 2007 01:43:33 GMT

Rajeev, you've likely installed the standard verion of MOSS 2007. Use an Enterprise key to enable the Enterprise features and your BDC functionality will show on the SSP administration page.

MOSS and BDC webcast resources

Contagious Curiosity — Sat, 02 Jun 2007 05:18:14 GMT

As promised during today's webcast: ( overview w/screen shots ) 1) Sample ADF template 2) BDC Metadata

re: Business Data Catalog

rajeev — Mon, 04 Jun 2007 15:30:42 GMT

I enabled BDC search functionality . but only the person with permission on bdc can able to see result of search not another user who has access on sharepoint site. is there any way in which without specifying permission on bdc user can see search result by using site access permission only.

re: Business Data Catalog

Rajeev — Thu, 14 Jun 2007 11:30:19 GMT

Thanks Greg, Its work now

Thanks again !!

re: Business Data Catalog

Pallavi — Tue, 19 Jun 2007 12:16:51 GMT

Has anyone written BDC App Def file for a WCF service??

Any help appreciated...thanks

re: Business Data Catalog

Arif Habib Shadan — Wed, 04 Jul 2007 16:34:10 GMT

Hi,

I have created a web service which exposes some data from our time attendance application and we need to display this on our sharepoint portal page. Using BDC i have read that its possible to connect to web service and metalogix also provides some tool to create the xml defs .... is there any other tool and which is free ? or open source .... which will help me achieve it ?

and if i create a web part in vs 2005 consuming this service ? which way is effecient .. a c# web part or a bdc consuming ws?

Regards

Arif Habib Shadan

re: Business Data Catalog

BSV — Wed, 25 Jul 2007 19:32:26 GMT

Can any one please help me. I am trying to connect to commerce server sql database which is on a different server from share point using BDC. When I try to connect i get the following error. Does any one have any idea about the following error. I tried all the four authentication methods....

Could not open connection using 'data source=Ztcfv0n1\comprod;initial catalog=CSharpSite_productcatalog;integrated security=SSPI;pooling=false;persist security info=false' in App Domain '/LM/W3SVC/1623789249/Root-1-128297584703937482'. The full exception text is: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

re: Business Data Catalog

Qazi Mobeen — Mon, 13 Aug 2007 09:50:08 GMT

for creating the bdc application definition metadata for Database, you can use the tool downloadable from http://www.bdcmetaman.com/pages/download.aspx. It will really save a lot of time for you.

re: Business Data Catalog

Jason — Wed, 22 Aug 2007 18:47:47 GMT

It seems that Business Data Catalog does not work with forms authentication and SharePoint SSO. Is there any workaround to use Business Data Catalog on a SharePoint site with forms authentication? Thanks.

re: Business Data Catalog

Visitor — Tue, 25 Sep 2007 12:11:57 GMT

Is it my company only? Or it is normal that managers refuse to use BDC to pull data from SQL Server because they already have another reporting system that they use to charge their customers. BDC will expose the data for the customer with no data reporting fees!

re: Business Data Catalog

Tanzil — Thu, 18 Oct 2007 17:45:50 GMT

Hi,

I was importing BDC xml files. After importing couple of the files it start throughing me the following error:

The current operation could not be completed. The job ID is not valid.

Can anyone please tell me what is going wrong hear?

Thanks

Tanzil

re: Business Data Catalog

jeffreycschan — Mon, 29 Oct 2007 13:15:06 GMT

Where to get the BDC definition file for adventureworks sample?

Thanks

re: Business Data Catalog - dev tools?

Ralph — Wed, 31 Oct 2007 21:58:09 GMT

Where are the tools/gui to create new BDC objects? Where is the how to create a BDC object, from scratch, step by step (do not just point users to the Adventureworks samples)?

re: Business Data Catalog

Chris Eidsmoe — Thu, 08 Nov 2007 16:26:44 GMT

Nice stuff, but it's easy enough for decent programmers to write their own "business data web parts", I have, and we just run WSS 3.0 without paying for MOSS.

Did you know the BDC only queries the data?

The SharePoint Farmer's Almanac — Tue, 29 Jan 2008 06:36:46 GMT

That it actually does NOT import everything but just pulls the data in on demand? You probably just answered

re: Business Data Catalog

dh k — Fri, 15 Feb 2008 12:07:58 GMT

i have the prob when connect with oracle 8.x

with key defined as varchar2 which i define in xml is System.String the return result is ora-12704.

re: Business Data Catalog

Raj — Wed, 02 Apr 2008 13:16:19 GMT

How to give diffrent icons for CRM searc results using BDC.. Eg. if the serach result is from Account entity I need to give Acoount entity image along with the result

re: Business Data Catalog

KristofM — Mon, 05 May 2008 17:00:05 GMT

Hi there,

Ik have installed a trial versiol of Sharepoint MOSS 2007 but the Business Data Catalog is missing. I also isn't listed in de site features so I'm trying to find de dwp-file but with no succes. Can anyone tell me how I can enable the BDC or where I can download this file so I can import and install it.

Thanks

re: Business Data Catalog

chahulSharePoint — Mon, 05 May 2008 21:03:35 GMT

Hay KristoFM,

have you created SSP?

BDC is avialable in SSP.

re: Business Data Catalog

Simha — Thu, 15 May 2008 23:59:49 GMT

Hi,

When I import an application definition file on MOSS2007 it gives error

Could not create profile page for Entity dbo.MVP_CandidateReviewProcessView. The error is: Cannot create a new connection to closed Web Part "g_9e9db8f4_1ccb_48bd_9962_f49baa277a5c".

Stay at home mom resource for making extra money online.

Stay at home mom resource for making extra money online. — Tue, 08 Jul 2008 23:03:56 GMT

Join us today as we discuss The Vaccine Book b y Robert W. Sears. This is the second time that contributors of Silicon Valley Moms Blog , Chicago Moms Blog, DC Metro Moms Blog and NYC Moms Blog (along with the rest our friends throughout the blogsphere)

re: Business Data Catalog

SharepointEquivalentOfDisgruntledPostalWorker — Tue, 22 Jul 2008 19:01:46 GMT

"The BDC enables easy and rapid integration between SharePoint Server and business applications and databases by leveraging an application or database connection"

You have GOT TO BE KIDDING!

I have spent over six months trying to expose a SIMPLE CUSTOMER LIST FROM A SIMPLE SQL TABLE with BDC. It just point blank refuses to do it.

Half the time the ADF XML fails to import for absolutely no fathomable reason. On the rare occasion it does import (sometimes within five minutes of failing to import on the previous attempt, despite no change being made to the ADF in the meantime), the web parts refuse to render any data and I get dumb errors with spelling mistakes in trace - like

Could not run query/stored proceedure 'SELECT [Customer Name], Address, PostCode, Phone, Fax, [Last Updated], Created FROM [dbo].[Customer] WHERE [Customer Name] LIKE @CustomerName' ...... The full exception text is: Must declare the scalar variable "@CustomerName".

(And yes the scalar variable IS declared.

When it does give a reason, it's complete garbage, eg

Could not run query/stored proceedure 'SELECT [Customer Name], CustomerRef, [Found In], [Listed As], Address, PostCode, Phone, Fax, [Last Updated], Created FROM [dbo].[Customer] WHERE [Customer Name] LIKE @CustomerName' using **** The full exception text is: Must declare the scalar variable "@CustomerName".

SQL Server, Access, and even a very ancient version of Excel are all very happily doing what I want, when I want, with the exact same data, and all manage to do it without complaining.

I have even tried using those automation tools to generate the ADF. My best result so far imports OK, but do the web parts work with the data? No.

Did some numpty at Microsoft put in a statement in the code, to the effect of, "IF NOT USING ADVENTUREWORKS THEN THROW AN EXCEPTION"?

Come the revolution, whoever came up with this overcomplicated, flakey option which apparently can't even cope with a stored procedure that every other Microsoft product seems able to execute without any complaining, will be first against the wall.

re: Business Data Catalog

JoJo — Tue, 29 Jul 2008 15:40:54 GMT

Why BDC is a big fail:

1. If you have approvals on in a document library and refresh the BDC column by using the hurricane icon all documents are set back to pending.

2. If you have versioning turned on in doc lib doing refresh will increase version and affect last modified.

3. If you have on change workflows and you refresh - your items all just "changed" watch your workflows freak out.

This is dumb.

re: Business Data Catalog

Yuba — Wed, 10 Sep 2008 23:37:10 GMT

Very nice Resources!!

Thanks a lot!!

-Edison,NJ

re: Business Data Catalog

Ramprasad N — Fri, 26 Sep 2008 11:18:09 GMT

Here is the step by step walkthrough of your first BDC example..

re: Business Data Catalog

Ramprasad N — Fri, 26 Sep 2008 11:19:53 GMT

Here is the step by step walkthrough of your first BDC example..

re: Business Data Catalog

jlozares — Tue, 25 Nov 2008 12:14:29 GMT

How do I call BDC actions from Infopath?

... or Business Data List Connector (for WSS ;-)

fdaske — Thu, 23 Jul 2009 14:43:20 GMT

A more simple approach to integrate business data in any SharePoint (WSS/MOSS) list is the SharePoint Business Data List Connector found at:

http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx

Simply enter a connection string, a select statement and the primary key(s) - thats it.

The list data is updated in background (only changed data, very fast batch update). So all list features can be used, even list workflow or notifications, if external data records are changed...

web tasarım

web tasarım — Thu, 30 Jul 2009 18:32:40 GMT

for you beathttp://www.parcakontorbayiniz.com

web tasarım

web tasarım — Thu, 30 Jul 2009 18:32:50 GMT

for you beatıful http://www.parcakontorbayiniz.com

web tasarım

web tasarım — Thu, 30 Jul 2009 18:36:49 GMT

are http://www.parcakontorbayiniz.com