Did you know the BDC only queries the data?

That it actually does NOT import everything but just pulls the data in on demand? You probably just answered yes you already knew that. So why am I playing the role of Captain Obvious? Well, because possibly if the only thing you ever learned about the BDC prior to this was post was from me you might have gotten the above questions wrong. Brad H. from my Boston admin class emailed me today thinking he had misunderstood me. Nope. He heard me correctly, the problem was I was wrong. I will not rehash what I said wrong but will try to say things correctly from now on.

  • You use the Business Data Catalog (BDC) to connect MOSS Enterprise to business data sources (such as PeopleSoft, SAP, Seibel, etc)
  • You can display that data using the business data web parts
  • You can use the data as metadata in lists or libraries
  • You can setup custom actions on the displayed data to interact with it
  • You can make the BDC a content source for search, creating full indexes of the data (this is what cause my confusion)
  • The BDC is defined and administered at the SSP level (Shared Services Provider)
  • The BDC is a MOSS 2007 Enterprise feature only

For more information check out this great full feature information from my buddy Sahil http://blah.winsmarts.com/2007-4-SharePoint_2007__BDC_-_The_Business_Data_Catalog.aspx or the official Microsoft scoop at http://blogs.msdn.com/sharepoint/archive/2006/04/18/business-data-catalog.aspx

Anyway my apologies for the miss-information.


Shane – SharePoint Consulting

Weird error due to permissions

So it is 1:30 am and I am sitting here trying to hodge-podge a medium server farm together to test a Kerberos issue/theory. My environment is a Windows Server 2008 box as my central admin, WFE, Excel, and query server (physical hardware), Windows Server 2003 VPC as the Index server, and a another VPC (running on another host) playing the role of SQL Server 2005 and Domain Controller. Does it sound like fun? Yeah right.

Anyway, I started getting the error below whenever I tried to start the Office SharePoint Server Search service on the index box.

An unhandled exception occurred in the user interface.Exception Information: Unable to generate a temporary class (result=1).
error CS2001: Source file ‘C:\Windows\TEMP\xm7qyq1x.0.cs’ could not be found
error CS2008: No inputs specified

Quick search? Nothing. A little playing and guessing and the issue turned out to be permissions. For some reason WSS_Admin_WPG and WSS_WPG did not have the any rights to c:\windows\temp on the central admin server. So I gave wss_admin_wpg full control and wss_wpg read & execute. Fixed everything instantly. I am guessing this is an issue with my random servers (not clean installs for this test) and not a W2K8 issue. Anyway, hopefully the error message and fix saves someone else some time.


SharePoint Consulting

Upcoming Speaking and Training

1/14 –Professional SharePoint Administration – Boston, MA. Come and spend 4 days with me hanging out in Boston. How much more fun can it be? I even promise to teach you some SharePoint in the process. Though former students will also tell you that dumb jokes will be plentiful also. πŸ˜‰

1/28 – Professional SharePoint Administration – Online version. That is right, you sit at your desk and learn. I sit in my pajamas and teach.

3/3 – The SharePoint Conference – Seattle, WA. I am doing 3 sessions at this fabulous conference in March. If you can only go to one conference this year this would be my pick. They haven’t posted all of the sessions yet but the ones I have seen are WOW! Lots of new content will come out this week.

I have a ton more conference and classes scheduled but these will get you started. I just submitted some TechEd Sessions so I will cross my fingers that I get to spread the SharePoint love in Orlando this year. Then I got to start working on the international schedule. Should be a fun year.

Shane – SharePoint Help

I passed Configuring Microsoft Office SharePoint Server 2007 070-630

I know, I am so cool. LOL

Had some students in my Professional SharePoint Administration class ask about how well the class would prepare them for the exam. I was like “Hell, I don’t know?”. So I went and took the exam the next day to find out.

I would have to say the exam is not as much hardcore admin as I thought it would be. Really turns out to be more about using the MOSS Standard and Enterprise features. Make sure before you take it you have an understanding of Excel Services, BDC, Forms Server, Content Management features and of course Search. There are a couple of deployment/upgrade questions but nothing too complicated. For more information on the exam check out http://www.microsoft.com/learning/exams/70-630.mspx.

I think I am going to go try out Configuring Windows SharePoint Services 070-631 soon. I heard it is harder so should be interesting to see what is on it.

Shane – SharePoint Help

Running – Server 2008, SQL 2008, MOSS 2007 SP1

One of the joys of owning your own business is every year in December you decide that you should buy some new business toys. Kind of like a second Christmas. One of the new toys we bought this year was a new server. It is an AMD X2 6000 (3 GHz) with 4 GB of RAM. It is actually a desktop class machine that we use as a server. We actually have 3 of them in this place. They have some fancy Antec case that keeps them from making any noise at all. And since one of them is under my desk that is nice. True server class hardware makes way too much noise for me. Oh yeah, and did I mention the server is like $800. If you want to check it out for yourself look at AlphaPCStore and build your own AMD. I have 3 of these things and they rock.

Anyway the server was slated to run Windows Server 2003 with Virtual Server. (Boring) So instead I decided to load up Windows Server 2008 RC1, SQL Server 2008 CTP, and Microsoft Office SharePoint Server 2007 with SP1. I would like to tell you that it was some big long complicated story…. But it wasn’t. Pretty straightforward to do. So I am going to beat on it for a couple more days. If all continues to look good then you can look forward to a post or two on how to set it up. I am just going to format the box and do it all again. Should be fun.



SharePoint Help