Creating a Microsoft Dynamics GP Integration with eConnect and a SQL Stored Procedure

This is third in a series of articles covering eConnect for Microsoft Dynamics GP. Part 1 explained that the business logic for eConnect exists in stored procedures within the Dynamics GP company database.  Part 2 created an eConnect integration utilizing the .NET API's within Visual Studio.

This post examines using eConnect directly from a SQL stored procedure.  The stored procedures are utilized by the .NET APIs to perform business logic verifications on the data being integrated.  Next, transactions that pass the verification are inserted into the appropriate transaction work tables within Dynamics GP.

...

Requires FREE Membership to View

Login
Become a Member Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Gloria Braunschweig

Gloria has experience across the full spectrum of business operations and management. Decades of experience are documented in the book Rapid Implementation, establishing Gloria as a specialists using Microsoft SQL tools for implementation, integration, and business intelligence related to Microsoft Dynamics GP.

Gloria writes and presents on lean implementation concepts and business management systems for small and mid-size businesses. 

Read full bio...

About W. Mike Harris

Mike brings strong data integration and conversion skills to Computeration.  His "can do" attitude gets data integrated into new systems quickly and cleanly.  He has delved into multiple legacy accounting products to retrieve data, utilizing Microsoft Access, Excel, Visual Basic, and SQL tools to convert and integrate data.

Mike utilizes his technical skills to develop efficient and economical customizations for clients.  He works with SharePoint, Business Portal, Web Services, SQL Reporting Services, and other legacy databases and reporting technologies. 

Mike's goal is to aid clients in their day-to-day processes.  His proficiency with the tables and fields in Dynamics, along with the process flows within all the modules, facilitates his ability to quickly and efficiently complete the migration of data.

Read full bio...