3 Ways To Import Data Into Microsoft Dynamics GP – Integration Manager, eConnect & Web Services


A powerful capability of Microsoft Dynamics GP is the ability to integrate data from other sources into GP.   Microsoft offers a couple technology solutions; some ISVs have leveraged those to provide tools with more sophisticated front-ends.   Microsoft tools for importing data into GP include: the Integration Manager, eConnect, and Web Services. 
The Integration Manager (IM) is offered as a separate application from GP and is used to import data into GP. IM is a graphical application and is designed to be easy to use. Programming skills are not required to define data integrations.  IM might be considered a “power user” tool (specifically when designing and mapping integrations), although any user can run integrations that have been defined. 
eConnect is a set of files, tools, and services that allow applications to integrate with Microsoft Dynamics GP data.  eConnect contains a special set of SQL stored procedures that are installed in each GP company database.  These stored procedures enforce the business rules and logic in GP to ensure that only valid data is imported.  Other data integration options, such as Web Services for Microsoft Dynamics GP and Integration Manager, use eConnect to provide their core capabilities.  Several standard programming interfaces are included with eConnect: eConnect .NET Assembly (the .NET interface used to interact with eConnect), BizTalk Adapter (the interface that allows eConnect to be accessed by Biz Talk), Message Queueing (MSMQ) (provides a loosely-coupled, message-based interface for eConnect), and SQL Stored Procedures (the stored procs defined by eConnect which can be accessed directly). 
Web Services for Microsoft Dynamics GP provides a standard Web service interface to access data in GP. Web services use standard Internet transport protocols such as Hypertext Transfer Protocol (HTTP) and standard XML-based document formats such as Simple Object Access Protocol (SOAP) to exchange information. ASP .NET is used as the foundation to implement the Web Services for Microsoft Dynamics GP. The GP Web services use eConnect to provide access to the GP data. 
ISVs such as Scribe Software and eOne Solutions have developed integration tools (Scribe and SmartConnect) that leverage eConnect and provide “friendlier” interfaces and better error reporting (without coding) versus working directly with eConnect. 

Comments

Post a Comment

Popular posts from this blog

How Understanding Cloud Computing Saved a Million Dollars!

Image
  Ever wondered how a deeper understanding of Cloud Computing could not just be a technological advantage but a game-changer for your finances? As we dive into the transformative realm of the Cloud, we’ll explore its multifaceted benefits and how I aided a client in saving a whopping million dollars within a year, all thanks to the power of serverless computing. Whether you’re a tech enthusiast, an entrepreneur, or someone simply curious about Cloud Computing, this article promises a trove of insights for you. 1. My Revelation from the Module: While going through the recent module on Cloud Computing, I was astounded by the depth and the potential of the cloud. It’s not merely about storing data; it’s a paradigm shift in how we perceive and utilize technology. 2. The Cloud Computing Conundrum: So, what exactly is  Cloud Computing ? Imagine not having to own a physical storage device but still being able to access all your data from anywhere, anytime. That’s the magic of the cloud! It’s
Read more

Some mistakes to avoid while looking for a job

Communicate well, don't fabricate information on resume during an interview.  Whether you are a fresher or a seasoned professional, there's always room for improvement, especially during an interview. Because of the mistakes one commits during his/her interview, employers often don't turn up with a positive response or a job offer. TimesJobs.com approaches some of the industry experts to find out those mistakes that any job seeker can avoid.  Poorly written resume  In order to stand out among the thousands of resumes that recruiters receive every day, a candidate's resume must represent the best that he/she has to offer and why they are right for the job. However, most job seekers spend tremendous energy, time, and effort to create an impactful resume, but send out multiple copies of the same to various recruiters instead of customising it for each position. For every job application, one should send a customised resume highlighting key strengths and capa
Read more