Integration MOSS 2007 – Dynamics AX with BDC through a custom field ty

In this series of post, I’ll show how you can integrate Microsoft Office SharePoint Server 2007 with another line of business system, more specifically Dynamics AX. The purpose is to create a custom field type, which can be added as a column to a SharePoint list. This SharePoint column renders a dropdown box with values from a Microsoft SQL Server table’s column. As such, in stead of duplicating the possible values on your SharePoint box each time new values are added in your line of business system, the available values for this SharePoint column are always in synch with your line of business system. This first post describes how to create your connection between Microsoft Office SharePoint Server 2007 and Dynamics AX. In this post, I’ll describe how to create the custom field type. In a following post, I’ll describe how to make this custom field type more generic by using a dynamic where clause in the query.