What is the Business Data Catalogue?

What is the Business Data Catalog - a nice summary from Martin Kearn

Resources and Stuff — Thu, 05 Oct 2006 17:59:17 GMT

Martin has posted a great overview of the new Business Data Catalog feature in SharePoint 2007. What

re: What is the Business Data Catalouge?

Martin P — Thu, 05 Oct 2006 18:56:44 GMT

You are so right!!

2007 MOSS Resource Links

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

re: What is the Business Data Catalouge?

Brant — Thu, 05 Oct 2006 20:38:58 GMT

Do you know how to setup a BDC instance and specify the database connection parameters? I think I need SSO (but I hope not) service to do this.

re: What is the Business Data Catalouge?

Martin.Kearn@Microsoft.com — Thu, 05 Oct 2006 22:30:25 GMT

The connection parameters are one of the things that are defined as part of the Application Definition file. If you look at the SQL 2005 Adventre Works example you'll see the section for adding connection parameters.

There are two options around security. You can either have MOSS access the backend system using a single service account or you can use MOSS's SSO system for indivual permissions. The SDK has great examples of this (http://msdn2.microsoft.com/en-us/library/ms563661.aspx)

re: What is the Business Data Catalouge?

Brant — Thu, 05 Oct 2006 23:18:21 GMT

So there is no way to specify a SQL Server userid / password directly?

re: What is the Business Data Catalouge?

Martin.Kearn@Microsoft.com — Fri, 06 Oct 2006 13:26:10 GMT

Yes, you absolutely can use a SQL username and password. This is specified as part of the application definition file (The LOBSystemInstance object). You can see more here: http://msdn2.microsoft.com/en-us/library/ms550725.aspx

What is the Business Data Catalogue?

Office Rocker! — Fri, 06 Oct 2006 17:35:00 GMT

Martin Kearn who is one of the guru Microsoft Consulting Services in the UK team has written a really

re: What is the Business Data Catalogue?

Brant — Fri, 06 Oct 2006 21:27:07 GMT

Sorry to be a pest but I can't seem to get this working. Here is the error I get: A Metadata Exception was constructed in App Domain '/LM/W3SVC/1739994257/Root-1-128046305479230304'. The full exception text is: The LobSystemInstance Property 'AuthenticationMode' has a value that requires 'Integrated Security' in the connection string Here is how I have defined my LOBSystemInstance PassThrough SqlServer dbserver ACMEDB YYY XXX I tried using both Credentials and PassThrough and neither seem to work.

re: What is the Business Data Catalogue?

Martin.Kearn@Microsoft.com — Sat, 07 Oct 2006 10:35:52 GMT

I'm digging into this SQL security thing a little more. The authentication mode part of the AppDef file has four different options, they are outlined here (http://msdn2.microsoft.com/en-us/library/microsoft.office.server.applicationregistry.systemspecific.db.dbauthenticationmode.aspx). From my understanding of this article (http://msdn2.microsoft.com/en-us/library/ms566523.aspx) it seems that there should be a DatabaseCredentials option but that does not seem to marry up with the other article. I'll do some digging internally and post back here when I get an answer. In the short term, I suggest that you just Windows Authentication as that is the 'recomended' approach anyway, but I will try and find out about SQL authentication.

re: What is the Business Data Catalogue?

Brant — Mon, 09 Oct 2006 07:20:38 GMT

Maybe its been depreciated; here is the error I get when using DatabaseCredentials

Application definition import failed. The following error occurred: The metadata object with Name 'ACME' and of Type 'LobSystemInstance' has a Property with Name 'AuthenticationMode' that has either an invalid value or Type. Error was encountered at or just before Line: '7' and Position: '10'.

re: What is the Business Data Catalogue?

Curious — Tue, 10 Oct 2006 15:18:54 GMT

Could anybody give me some additional information regarding LoBI in connection with the BDC? As I figured out BDC is read only while LoBI is transactional ... a more detailed description would be great!

re: What is the Business Data Catalogue?

Martin.Kearn@Microsoft.com — Tue, 10 Oct 2006 15:48:01 GMT

LoBI is a little way off yet (not on the same release path as Office & MOSS), but the best information is as follows:

Press Release: http://www.microsoft.com/presspass/press/2006/jun06/06-12OBAPR.mspx

Office Business Applications Developer Portal: http://msdn.microsoft.com/office/tool/OBA/default.aspx

re: What is the Business Data Catalogue?

Curious — Wed, 11 Oct 2006 12:09:31 GMT

Thnx a lot for the links.

After watching the LoBI webcast and reading the additional information about the BDC there was just one question which came up, maybe u can help as well ;)

I spent some time looking at Duet the joint product between MS and SAP. When I look at the BDC with all its possibilities and LoBI as a future product ... then companies would be able to buy a very affordable product compared to the expensive Duet with similiar functions as Duet, am I wright? You would just have to pay the ISV's or even your own staff could configure the BDC in the necessary way is it? Can I at all compare Duet with the BDC (LoBI)?

re: What is the Business Data Catalogue?

Don Shults — Wed, 18 Oct 2006 19:49:53 GMT

Thanks Martin... This info is a great help..

Don Shults

error Import application definition !!!

cidracula — Wed, 25 Oct 2006 11:58:48 GMT

help me, please. Error occurred when I import file XML to BDC:

"Application definition import failed. The following error occurred: The system Property named 'Version' of Type 'System.String' is present on the LobSystem but has an invalid format. Error was encountered at or just before Line: '2' and Position: '2'. "

send mail for me: cidracula@yahoo.com

re: What is the Business Data Catalogue?

sean.campbell@ascentium.com — Tue, 31 Oct 2006 03:07:45 GMT

Nice post. I've been looking for something that takes this at a high level to point out to customers.

re: What is the Business Data Catalogue?

Josh meyer — Wed, 29 Nov 2006 22:51:14 GMT

Is there a way to specify the port to use when connecting to Oracle from the BDC? Our Oracle db doesn't use the standard 1521 port, and i can't seem to get the BDC to connect to it.

re: What is the Business Data Catalogue?

antoinks — Thu, 30 Nov 2006 09:26:50 GMT

Do you know how to add user profile properties imported from BDC?

re: What is the Business Data Catalogue?

Paras — Fri, 05 Jan 2007 06:24:20 GMT

could you modify the data using the business data catalouge?? how do you connect to the sql server tables??

re: What is the Business Data Catalogue?

ccalcut — Wed, 10 Jan 2007 22:20:20 GMT

Is there a way to retrieve data with the list web part that pulls the information from all the columns in the list, not whatever filter is chosen?

re: What is the Business Data Catalogue?

Peter Duerden — Thu, 11 Jan 2007 19:01:21 GMT

Did you find out anything more about a possible DatabaseCredentials option for the AuthenticationMode? It would be really useful in testing the BDC if I could connect to my existing databases using existing SQL Sever username password pairs. I have noticed a few other people having difficulties with this but no solutions posted

My Awesome MOSS 2007 Demo !

Sezai's Blog — Wed, 07 Feb 2007 11:37:57 GMT

It’s demo time! MOSS is still fairly new, and seeing as we are starting to flog it I have been...

re: What is the Business Data Catalogue?

deeptyranjan — Thu, 08 Feb 2007 13:09:57 GMT

A brand new feature of Microsoft Office SharePoint Server 2007 (MOSS 2007) is the Business Data Catalog. This new component allows line of business data to be integrated with within your SharePoint environment with Business Data Webparts, SharePoint Lists, Search, User Profile Importer, and Custom Solutions. Previously in SharePoint 2003 to get this external data to display in your portal often required the development of custom webparts which could have entailed months of development and testing. The Business Data Catalog offers an easy, no code way of integrating your backend data into MOSS 2007.

re: What is the Business Data Catalogue?

deeptyranjan — Thu, 08 Feb 2007 13:10:40 GMT

Business Data Web Parts

MOSS 2007 ships with 4 new web parts which are used in conjunction with data imported via the Business Data Catalog to provide a way to display your data in your portal. The four web parts available are:

Business Data List Web Part

Business Data Items Web Part

Business Data Related List Web Part

Business Data Actions Web Part

re: What is the Business Data Catalogue?

Padmaja — Fri, 02 Mar 2007 06:12:18 GMT

Does anybody can help out resolving this problem?

BDC Column in ContentType?

Thomas — Fri, 16 Mar 2007 13:26:38 GMT

I cant find a way to ad a bdc bound column to a contenttype. Your example describes only how to add a bdc column to a document library.

Better decisions faster: Blogcast demo

Office Rocker! — Wed, 18 Apr 2007 18:08:39 GMT

Continuing my series of blogcast demos, this week I am talking about business intelligence , showing

WSS 3.0 & MOSS: Recopilación de enlaces interesantes (IV)

Blog del CIIN — Tue, 24 Jul 2007 15:19:22 GMT

Siguiendo con la recopilación periódica de recursos sobre WSS 3.0 & MOSS, esta semana en el número

Business Data Catalogue (BDC) and Microsoft Dynamics CRM

Microsoft Dynamics CRM Team Blog — Tue, 07 Oct 2008 19:10:29 GMT

Business Data Catalogue (BDC) is one of the very exciting features of SharePoint. It got introduced in

Business Data Catalogue (BDC) and Microsoft Dynamics CRM

Microsoft Dynamics CRM Team Blog — Wed, 08 Oct 2008 03:01:32 GMT

Business Data Catalogue (BDC) is one of the very exciting features of SharePoint. It got introduced in

Business Data Catalogue (BDC) and Microsoft Dynamics CRM

Microsoft Dynamics CRM Team Blog — Tue, 28 Oct 2008 20:18:21 GMT

Business Data Catalogue (BDC) is one of the very exciting features of SharePoint. It got introduced in