Appolis, Inc.

Our Appolis Experience with Microsoft Dynamics Connector

Email | Print

Appolis has developed an iOS based Sales Order Entry System we call “WoW Order”. The need for order entry in the field is alive and well and we continue to get requests for this capability all the time. This article explains our experience with the V2 release of Microsoft Dynamics Connector which was made available to the masses in December 2011. For information about the SDK which is used to create your own custom adapters, check out the Microsoft Dynamics Adapter SDK. (you’ll need login credentials as a partner or customer).

As a WMS provider, order entry is an interesting adjacency for us and Microsoft Dynamics Connector is a technology that we wanted to get real world exposure to.   The Microsoft Dynamics Connector is a free Microsoft integration tool that began as a replacement for Microsoft Dynamics CRM integration to Dynamics GP. Once the Connector architecture was proven out, the Microsoft team continued to build Adapters to integration between CRM, GP, AX, NAV, and SL. Appolis has always been an early adopter of web services for Dynamics GP and the Connector was a technology that we could create an efficient integration strategy with ALL Dynamics products by leveraging existing Adapters that were initially built out for CRM integration. If successful, it opens up a whole new market space for our products and services.

For out WoW Order application, we created a custom adapter that would be used by both Microsoft Dynamics® NAV and CRM to create sales orders, return order statuses, order history, pull master lists of items, and customers.

For our application we used 3 new technologies:

1) Microsoft Dynamics Connector for CRM/GP/NAV/AX 2) Apple iOS based Sales Entry App with Barcode Scanning and WCF integration 3) Appolis WoW Framework

The documentation provided for custom adapters is limited. Our main source of information was the Connector Blog, the SDK, and some internet content.

When investigating how the Connector architecture works, you will discover how easy custom Adapters are to create and to work with. The challenge resides in the business rules around the data that is transferred from one system to another.  In the SDK there is a Visual Studio template to create new adapter project or mapping functions.  Our initial load testing showed very positive results when importing our data from Dynamics NAV for our Customers and Items. We were seeing .01 seconds per item and although many factors impact performance results, our integration is running seamlessly without any manual intervention. It just runs!

Obviously there are many technical tips and tricks to success that we have discovered which are not covered here, but we believe that it opens up new doors to integrated systems for Microsoft Dynamics customers,  partners and companies like us… Independent Software Vendors (ISV’s).

We plan on continuing our R&D investment in this area and believe that it will play a significant role in our future product strategy!

Posted in Microsoft Dynamics|Tagged barcode scanning, iOS, Microsoft Dynamics Connector, ordering|Leave a comment

By Travis Smith, CTO/Founder – Appolis

Related Posts

Ask This Expert a Question or Leave a Comment




Get New Posts:

Distribution Software Logo