Skip to main content

Patrick Tisseghem's Blog [MVP SharePoint]

Go Search
U2U Blog Center
U2U website
  

The Happy SharePoint Traveller

U2U Blog Center > Patrick Tisseghem's Blog [MVP SharePoint] > Posts > Exposing Microsoft Dynamics CRM 4.0 Data within SharePoint Custom Fields
Exposing Microsoft Dynamics CRM 4.0 Data within SharePoint Custom Fields

More and more organizations feel the need to unlock their business data to the information workers either in the Microsoft Office or the SharePoint environment. Office Business Applications are excellent demonstrations of this type of solution. Within the SharePoint environment you can use the Business Data Catalog to connect easily to all of this data and let the users work with it with the out-of-the-box Features such as the Business Data Web Parts and for example the Business Data field type. But the BDC also has a very rich run-time object model that you can program against as a developer. Learning this object model is very important when you want to expose the business data in a custom manner to the users. One of the possible solution components is the creation of a custom field type. At U2U we have created a 2 day development course dedicated to integrating Microsoft Dynamics CRM 4.0 and WSS 3.0/MOSS 2007. In it, you'll learn plenty of things, including the creation of custom field types for SharePoint.

We have packaged that part in a walkthrough that is published as an article on our site. You can read it here and the sample can be downloaded here. It is a nice illustration of the work you can do with the BDC and it is easily re-usable when you want to hook up with other LOB-systems such as SAP or whatever.

Here is a screenshot with the end-result:

addressdetails

Comments

Application Def file link missing

I can't find the link for the BDC app def xml file for your CRM data access?  The article says link is at bottom?
THanks for the awesome article!
at 29/02/2008 15:08

The file '/_layouts/CRMAccountControl' does not exist

Hi Patrick,

I tried the code provide by you to test, and follow the deployment procedure, I have DLL in my GAC at "D:\WINDOWS\assembly" , UC in Templates floder , fldtypes_crm_account.xml in XML folder.
But as soon i go to "New Site Column" and select "CRM Account field..." I get "Unknown Error" below is the log entry.
 
SharePoint Services   General                       8dzz High    Exception Type: System.Web.HttpException  Exception Message: The file '/_layouts/CRMAccountControl' does not exist.

Please help!!! Thanking in advance,
ntronixs@gmail.com
at 25/01/2009 22:47
Captcha

Enter the code shown above: *

(Note: If you cannot read the numbers in the above
image, reload the page to generate a new one.)