|
Microsoft Dynamics GP 10.0: Integrating with legacy database eConnect, Alba Spectrum
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
When we are talking about Microsoft Great Plains integrations, we recommend you to think about pushing and pulling approach and connection tools. In this small article we would like to give you the scenarios to integrate your legacy database or business application with newest version of Dynamics GP Great Plains 10.0. Interesting scenarios when you have non Microsoft legacy application: Oracle, Lotus Notes Domino, DB II, Sybase, Progress, Pervasive SQL, Ctree/Faircom, and Java applications. Microsoft Dynamics GP is SQL based ERP application, so the easiest way is to deploy SQL Server 2005 or 2000 tools:
1. Linked Server. This concept allows you to create a link to your external database. The most common scenario is ODBC, in some Java specific case it might be JDBC connector (including the simplest JDBC ODBC bridge). Please be careful about jumping immediately into Linked Server world. If your third party application has its own SDK (Software Development Kit) first, you should research it and decide if you would like to go directly to SQL queries via ODBC connection. Linked Server allows you to create heterogeneous SQL queries, where you join cross-platform data in one select or insert statement. Linked server allows you to realize two-way integration (pull and push), however again you have to do all the DB scripting on the low level, where you should expect a lot of debugging and QA work
2. eConnect. When pushing and pulling to/from Great Plains, you can obviously appeal to direct SQL scripting. However we recommend you first to analyze if eConnect is the way to go. eConnect is written in its core business logic in SQL stored procs and it resolves such complex issues as extracting, creating, modifying GP objects: master records and work transactions. All you need to do is to provide parameters to eConnect stored procedures and interpret results. eConnect doesnt post transactions in GP, such as SOP invoices, when you need automatic posting we recommend Albaspectrum posting server
3. Direct SQL scripting. If you think that eConnect is too heavy for you and it is easier to do direct SQL coding, please research GP tables structure in Microsoft Dynamics GP->Tools->Resource Description->Tables. Microsoft Dynamics GP records distribution in the tables is defined by Microsoft Dexterity architecture, so dont expect it to be too easy. Try intended transactions entries in GP and research how records flow into the tables
4. Great Plains Dexterity integrations. Dex is relatively difficult to learn from zero, however it has unlimited control over GP MRP. Typically you customize DYNAMICS.DIC, adding new Dex modified logic there and then extract and package it in the form of Dexterity chunk
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
Company: Alba Spectrum Group
|
| Related press releases |
Web Design for Microsoft Dynamics GP: custom ecommerce solutions Alba Spectrum [2007-08-18 05:19:13]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
More articles are published about Microsoft Great Plains Dynamics GP 10.0. Very hot topic is e...
|
|
Microsoft Dynamics GP 10.0: Integrating with legacy database eConnect, Alba Sp... [2007-08-12 04:09:50]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
When we are talking about Microsoft Great Plains integrations, we recommend you to think about ...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Microsoft Dynamics GP 10.0 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
Great Plains Dynamics GP: Programming, Integration, Customization Alba Spectru... [2007-12-21 09:47:23]
Microsoft Great Plains ERP is wide spread in USA and Canada, as well as in English speaking countries. As we see XXI century progressing, more technical skills are becoming the norm and so to say req...
|
|
Microsoft Great Plains eCommerce Web Design & Autoposting Alba Spectrum [2007-08-24 06:18:59]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP Great Plains is MS SQL Server 2005 application, current version in 10.0. ...
|
|
Dynamics GP eConnect a tool for integrating data sources to Great Plains [2008-09-04 16:25:11]
Microsoft Dynamics GP or Great Plains eConnect is a very convenient tool for integrating various data sources to Great Plains modules. The main components and interfaces include .NET managed code as...
|
|
Microsoft Dynamics GP 10.0 Great Plains: Renaissance of GP Dexterity Alba Spec... [2007-07-30 04:56:04]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP Great Plains version 10.0 is now released and available to GP customers a...
|
|
Old Great Plains Dynamics versions support, recovery and upgrade Alba Spectrum [2007-08-29 05:31:43]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 10630-961-5918
In best case scenario you as Microsoft Dynamics GP customer who is following the recommended ve...
|
|
|
|
| VintaSoftTwain.NET Library |
 Control a scanner or camera from your .NET application. VintaSoftTwain.NET Library allows to control the image acquisition process, use automatic documents feeder, save acquired images to disk or into SQL database, upload them to Web or FTP servers. |
|
| The Collectors Crown |
 A database for discerning collectors of Antiques, Art, Books, Ceramics, Carnival Glass, Coins, Gems, Genealogy, Maps, Notes, Stamps, Software, Videos, CD's, DVD's or Photos. |
|
| Dutch Duck Cache and History Reader |
 Dutch Duck Cache and History Reader shows Microsoft Internet Explorer's History, Cache, Cookies, and Favorites in a very accessible, spreadsheet-like format. You can selectively remove items, and sort, group, search, print, and export everything. |
|
| Wondershare QuizCreator X'mas Offer |
 Wondershare QuizCreator is a robust solution designed for making highly customized flash quizzes without programming. Users can publish their quizzes to LMS (AICC/SCORM), and pass test results to Web database for learning evaluation. |
|
| 123 Flash Chat Software |
 123 Flash Chat Server Software can add a chat room to your website in minutes. It is a live chat solution for networking. It has multiple skins & mutiple chat client, such as iPhone Chat, Avatar Chat, offering seamless integration to your database. |
|
| egrID3 COM Add-In for Microsoft Excel |
 egrID3 COM Add-In for Microsoft Excel adds functionality to fast mp3 ID3 v1.x, v2.3, v2.4 tag reading and altering, playlists generation, FreeDB querying, file names handling and full Unicode support on all operations. Handle compressed v2.x frames. |
|
| WhatDisk |
 WhatDisk is an easy-to-use program with an Explorer-like user interface that helps you categorize your disks (CD's, DVD's, ZIP disks, external hard drives, USB sticks, MP3 player, iPod etc.) into a single, searchable database. |
|
|
Latest press releases
