 |
Microsoft Great Plains Integration Manager 10.0 Technical Notes
Author: Andrew Karasev  | Posted: 17-11-2007 | Comments: 0 | Views: 25 | Rating: (52)  (?) 
 Microsoft Dynamics GP version 10.0 advanced such new technologies as eConnect in and this seems to be general trend to walk away from proprietary tools, such as Microsoft Dexterity to Microsoft specific platforms, such as .Net, COM+ and MS SQL Server Stored Procedures, as you know eConnect core contains encrypted stored procs. Historically Great Plains IM was based on OLE technology, where GP workstation was used as OLE server and business logic validation was done in GP forms, where OLE mechanism was entering fields values. Let’s take a look at new and traditional features available in IM version 10.0, it is in our opinion in transition to be rewritten completely in eConnect, but at this time it is available with both traditional and eConnect connectors:
1. eConnect connector. For GP consultants, you should be aware that eConnect connector requires specific company, if you remember how OLE connector works – it recognizes the company, from where you call Integration Manager and so you do not need to specify the company in integration settings. eConnect requires the company target to be specified. eConnect integration performance should be higher comparing to traditional connector, as eConnect doesn’t use slow OLE technology and imitates business logic (or in other words it replicates Dexterity functionality) in SQL stored procedures (which are performed on the server). Typical GP integrations involve Sales Order Processing module (this includes eCommerce scenarios) as well as Purchase Order Processing module (where you integrate EDI vendor invoices, for example) and at this time, GP IM 10.0 eConnect connector enables these integrations, which is very optimistic note
2. IM upgrade. Typical scenarios are when you are upgrading skipping two versions, let’s say from GP IM 7.5 to 10.0. In this scenario you need to do two steps upgrade – first to GP IM 9.0 and then to 10.0
3. VBA programming for Integration Manager. This technology may seem outdated as VBA was popular in late 1990th to automate MS Excel and MS Access type of scenarios. However VBA and Modifier modules are still available with Microsoft Dynamics GP purchase or upgrade. VBA scripting is event driven one, so you should review the options to alter IM business logic on pre and post integration, pre and post document. This article format is short and we can not give you sample VBA scripts here, however if you have development budget and would like to get advanced technical and programming help, we would be happy to assist you
4. GP IM advanced techniques. Translation technology. Each field is available for translation logic. You can load Excel translation table to IM directly. Translation logic allows you to map external item number id to your internal one, or in collection agency example it allows you to translate vendor it to customer id, as collection business is reversed one, where sales means collection
5. IM in cross platform integrations, here we need to stress ODBC standard and advanced integrations. Microsoft SQL Server 2000 and 2005 linked server construction allows you to deploy either direct SQL select statement or OPENROWSET one. Now is you are coming from Oracle and Oracle EBusiness Suite world, similar integration concept is available from Oracle EDI. If you are on Linux Red Hut and PHP and MySQL, please consider ODBC bridge or appeal to Java technology. If you PHP is sitting on MS Windows platform you can deploy direct call to MS SQL Server 2005 or 2000
6. GP data conversion and Integration Manager. Legacy data massage, conversion, is available and IM usage is very helpful. Microsoft Dynamics GP offers IM installation or initial migration license, which is limited to the number of days
7. The most popular Integration Tables in Great Plains: SOP10100, SOP10200, RM00101, RM00102
8. Integration Manager and Great Plains Dexterity connections: DEX_ROW_ID is one of the most popular questions among the developers community. If you do direct SQL insert statement feed into GP tables, DEX_ROW_ID is outoincremental and so you don’t need to populate it
9. GP and MS CRM connector. It is outside of GP IM, so please do not be confused. MS CRM connection business is pretty much taken over by Scribe Software, so please check with these folks first. Also, SAP Business One is very popular small business ERP and MRP (Manufacturing module and extensions) platform, where you can have Microsoft CRM to be integrated. From Microsoft Dynamics CRM side you can use SQL views and stored procedures to store exported data in the custom database, and from SB1 side you use Sap B1 SDK to program SB1 integrated objects: Sales Orders or Sales Invoices
10. XML Web Service Approach. As XML is in essence text, it is the platform independent data (or text files) stream. To open Web Service to UNIX client, from GP side you typically involve C3 or VB.Net developer
11. IM closing remarks. Great Plains Integration Manager is both end user and developer friendly tool. If you are VBA or Microsoft.Net programmer you should be able to build sound integration on IM platform. eConnect will more likely be the main IM transformation technology, so if you are deploying IM integrating techniques, you should follow eConnect news
Rate this Article:
Current: 0 / 5 stars - 0 vote(s).
Article Source: http://www.articlesbase.com/software-articles/microsoft-great-plains-integration-manager-100-technical-notes-261751.html
About the Author:Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com - help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale.
|
Submitting articles has become one of the most popular means of generating quality backlinks and targeted traffic to your website. Join us today - It's Free! |
|
Related Articles
Deciding on a New ERP Solution? Choosing Working With the Right Microsoft Partner Could Make the Difference in your Systems Success
By: Monique Tatum | 05/09/2007 | Software
The right Microsoft Certified Partner will prove invaluable as your new ERP solution is implemented, but having your solution set up correctly in the first place is only half the battle. Your chosen consulting firm for implementation should do much more than integrate and optimize your solution.
Microsoft Great Plains Installation Highlights
By: Andrew Karasev | 04/11/2007 | Software
Current version of Microsoft Dynamics GP, 10.0 is available on Microsoft SQL Server 2005 and 2000. If you are on older version, we’ll also give you advise on where to find information.
Great Plains Microsoft Dynamics Gp Implementation in Florida
By: Andrew Karasev | 22/12/2007 | Software
Alba Spectrum Group, Microsoft Dynamics consulting partner in USA and Canada nationwide announces its workforce increase to serve GP customers in Florida.
Great Plains ERP in Ecommerce Environment: Combining Hosted Website With Business Portal
By: Andrew Karasev | 24/02/2008 | Software
After seeing reasonable and multiple concerns, we would like to give you some directions for your homework, when you consider transitioning for your let’s say “legacy” e-commerce website to new totally data driven eCommerce. Microsoft Dynamics GP 10.0 has pretty advanced Business Portal, where we recommend you to research Order Management module, which in turn is redesigned version of former eOrder. eOrder went to the history, the last version of the product was 7.5.
Microsoft Dynamics Gp 10.0 Great Plains Remote Support – Overview
By: Andrew Karasev | 24/09/2007 | Software
Microsoft Great Plains ERP has rich accounting and business processes automation functionality, however in this small article we would like to concentrate on remote support, version upgrade, technical problem solving scenarios and if you need to get info on specific GP modules features
Custom Sales Order System Integration With Great Plains Microsoft Dynamics Gp
By: Andrew Karasev | 12/11/2007 | Software
If your company is established business, which uses one or another in-house developed Business Management System and you are now in situation when you are moving the business to the new phase, where you need industry strength ERP system behind, or how now they name it accounting backoffice, you may be interested to read on how Microsoft Dynamics GP Great Plains can do the job for you
Great Plains Reports – How to Create and Typical Design Tools
By: Andrew Karasev | 25/12/2007 | Software
Microsoft Dynamics GP reporting is essential part of GP implementation and post production ERP support. As for typical mid-size MRP application, you should expect multiple reporting tools, especially if you think about reports genre: financial reporting, business processes specific reports, etc.
Great Plains Dexterity – Microsoft Dynamics Gp Customization Technology
By: Andrew Karasev | 26/09/2007 | Software
If you remember ERP players in 1990th, you would probably remember the technology trends and stakes: nobody could really say which OS will win: MS Windows, MAC, SUN Solaris, UNIX; plus nobody could also predict which DB platform will stay: MS SQL Server, Sybase, IBM DB2, Oracle, or somebody else
Got a Question? Ask.
Ask the community a question about this article:
Frequently Asked Questions
Do we have adapter for Project Accounting in GP ...
By: GPIM | 16-10-2007
Do we have adapter for Project Accounting in GP Integration Manager Ver 10.0 ?
Q&A Powered by: 
Latest Software Articles
Great Plains Consultants Chicago, San Diego, Houston and Nationwide Support
By: Andrew Karasev | 24/07/2008
Microsoft Dynamics GP software licenses sale, implementation, data conversion, user training, customization, integration, reporting, version upgrade.
Statistical Process Control by Hertzler Systems Impacts Leading Flavor Manufacturer
By: Thomas Cutler | 24/07/2008
Statistical Process Control by Hertzler Systems Impacts Leading Flavor Manufacturer
How to Convert Nsf Archives to Outlook Pst File ?
By: Evan Swans | 24/07/2008
How to fix corrupt views of Lotus Notes NSF Archives? How to convert Lotus Notes NSF Archives to MS Outlook PST file? Export Notes is powerful software to migrate Lotus Notes to MS Outlook. Convert Lotus Notes emails, calendar, contacts, and journals, to do list to Ms Outlook with SysTools Export Notes. If you face any problem converting Lotus Notes NSF archive to MS Outlook PST file due to corrupt views of NSF file, try using IBM Data Fixup Utility.
Seo and Keyword Analysis
By: Kanwaljit Kaur | 24/07/2008
Targeted keywords are hard to ignore in search engine optimization. Keywords play vital roles in optimizing a website, ranking on the search engines and reaching target market. Keywords have loads of benefits if you know how to find them.
Building a Flexitime Management System - Challenges Faced
By: Mike R Turner | 24/07/2008
When asked to adapt our time-recording software so it can be configured to account for flexitime, there were number of questions that needed to be resolved. We explain the issues we considered.
Customized User Interfaces for Multi Function Printers
By: Mike Nicholson | 24/07/2008
By their nature, MFPs are complex devices. Many MFPs now include high resolution screens and other user interface aids. Generally, most office MFPs contain advanced LCD panels resembling a custom computer-like user interface.
Get Free Registry Repair Solution From Internet
By: Arvind | 24/07/2008
Registry is an integral part of the Windows based computer. Windows creates and uses the registry file to store all the vital data about the hardware and software configuration, system settings, network settings and user account details of the computer.
Quickbooks Means Accounting Simplified
By: markoriks | 23/07/2008
Managing a small business is tough. It needs knowledge, money, dedication and time. The successful small businesses are those that are financially on top position. Keeping a track of from where money comes and to where it's going is absolutely necessary. One way to effectively keep this track is to use QuickBooks accounting software.
More from Andrew Karasev
Great Plains Consultants Chicago, San Diego, Houston and Nationwide Support
By: Andrew Karasev | 24/07/2008 | Software
Microsoft Dynamics GP software licenses sale, implementation, data conversion, user training, customization, integration, reporting, version upgrade.
Microsoft Dynamics Gp Great Plains Consultants With Industry Expertise
By: Andrew Karasev | 23/07/2008 | Software
Microsoft Dynamics GP Great Plains certified consultants with average 10 years of experience are available for GP implementation, customization, data conversion, integration, user training and ongoing support. We have experience in such modules as General Ledger, Accounts Payable, Accounts Receivables, Sales Order Processing, Purchase Order Processing, Project Accounting, Fixed Assets, Payroll, ReportWriter, FRx, Crystal Reports for GP, Microsoft Dexterity, eConnect and GP Integration Manager
Great Plains Consultants and Integrators With Emphasis in Technology
By: Andrew Karasev | 22/07/2008 | Software
Microsoft Dynamics GP functional and technical consulting requires strong backing in technology experience, background, training and certification. Modern ERP consultant should be familiar (or be capable to involve fellow consultants) with industries, managerial and financial accounting, be reasonable good in reports design, system modification, have some knowledge and be aware about specific programming techniques and customization tools.
Great Plains Consultant, Specializing in Technically Challenging Projects
By: Andrew Karasev | 22/07/2008 | Software
Microsoft Dynamics GP implementation, data conversion, reports design, user training, integration with legacy system and possible modifications and customizations should be entrusted into the hands of professional certified Dynamics GP consultant
Great Plains Consultant in Chicago, San Diego: Nationwide Support
By: Andrew Karasev | 19/07/2008 | Software
Microsoft Dynamics GP ERP is the member of Dynamics product family. If you decided to implement Great Plains in your organization, you probably came through the process of corporate ERP selection and decided to trust Microsoft Dynamics brand.
Great Plains Dynamics Gp Reseller: Nationwide Support
By: Andrew Karasev | 18/07/2008 | Software
If you are looking for new implementation of Microsoft Great Plains, you need first to locate Dynamics GP (which is new name of this ERP product) VAR, who will become your consulting and implementation partner. VAR selection should be based on your criteria.
Great Plains Customization: Reportwriter Modified and Custom Reports Overview
By: Andrew Karasev | 17/07/2008 | Software
In Microsoft Dynamics GP Report Writer is integrated reports modification tool, where you can modify such reports as Blank SOP Invoice form or Purchase Order to place your company logo there.
Great Plains Consultants and Developers Provide Nationwide Support
By: Andrew Karasev | 16/07/2008 | Software
If you have Microsoft Dynamics GP installed and implemented in your organization, and you are looking to get second opinion on your current system setup, customization, integration projects
|
|
Computers 
