Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer > NetSparsh - Viral Content you Love & Share

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer


Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market. At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor to Oracle, PeopleSoft, SAP, IBM. This article is brief review of Microsoft Great Plains integration with Microsoft Access. This is also applicable to Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary - DYNAMICS.DIC and runtime DYNAMICS.EXE) and Great Plains Standard on MSDE or MS SQL Server.

If you are developer who is asked: how do we implement Great Plains integration/interface with your MS Access-based system ? read this and you will have the clues on where to look further.

  • Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. etc.) brings in transactions into work tables. The limitation of Integration Manager - it does use GP windows behind the scenes without showing them - so it is relatively slow - you can bring 100 records - but when you are talking about thousands - it is not a good option. By the way you can program Integration Manager with VBA. Microsoft Access is ODBC compliant and so you can do direct Integration Manager query to MS Access
  • eConnect ? it is type of Software Development Kit with samples in VB.Net. Obviously the development environment should be Visual Studio.Net. eConnect will allow you to integrate master records - such as new customers, vendors, employees, etc., plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or historical records - you need to post work records in Great Plains, the same limitation applies to Integration Manager above) eConnect is rather for ongoing integration. It was initially created for eCommerce application integration to Great Plains.
  • SQL Stored Procedures. Obviously you have unlimited control and possibilities with SQL queries. You need to know Great Plains tables structure and data flow. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ? it should be RM00101 ? customer master file. If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc. Do not change existing tables - do not create new fields, etc. Also you need to realize that each GP table has DEX_ROW_ID - identity column. Sometimes it is good idea to use inbound/outbound XML in the parameters - then you can deploy web service as a middle party between two systems.
  • Data Transformation Services (DTS) ? Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager. You can also deploy this tool for EDI export/import. You can have DTS working with Linked Server - SQL Server Construction for linking to Microsoft Access
  • Great Plains Dexterity Custom Screens. Sometimes users prefer to have seamlessly integrated into GP interface custom screens - for parameters settings and initiating integration. Dexterity is a good option, however remember - it is always better to create new custom screen versus customizing existing one - due to the future upgrade issues. Also - Dexterity is in phasing our by Microsoft Business Solutions.
  • Modifier/VBA custom buttons on the existing screens - alternative to Dexterity is you are comfortable with VBA and ADO.
  • SQL Linked Servers ? you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including Microsoft Access) - you may need to familiarize yourself with OPENROWSET command in Transact SQL. This is also good option if you need cross-platform Crystal Report - pulling data from SQL Server and third party databases on the same report.
  • Warning - do not place existing GP tables into Replication! - you will have upgrade issues.
  • Happy integrating! if you want us to do the job - give us a call 1-866-528-0577! [email protected]

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, New York, Florida, Georgia, Minnesota, Oregon, Arizona, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:

    This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

    TechCrunch

    ADP acquires workforce management software startup WorkMarket
    TechCrunch
    Payroll provider ADP said it is acquiring WorkMarket, a startup that specializes in workforce management software that operates across a wide range of employees and contractors, for an undisclosed sum. The software aims to create a kind of unified ...

    and more »

    War on the Rocks

    The Next New Military Specialty Should Be Software Developers
    War on the Rocks
    To be clear, cyber warriors are not software developers. A common misperception is that cyber refers to anything involving computers. Cyber teams design weapons, not user interfaces and reports. They write code, but not in MySQL, Python, or Ruby. They ...


    City to begin evaluation of software for financials, other data
    Hastings Tribune
    Both the city and utility have needed to upgrade financial software. So it only made sense to try to put those two together, plus get additional benefits. The ERP's modules also address many of the 79 recommendations included in the Novak Study β€” the ...


    AMD Releases Radeon Software Adrenalin Edition 18.1.1
    AnandTech
    Touching back on CES 2018, AMD gave a couple updates related to graphics software, in addition to many of the previously covered announcements – Radeon Vega Mobile, Radeon Instinct Vega on 7nm, February 12 launch of Ryzen desktop APUs, and the updated ...


    OregonLive.com

    Viewpoint Construction Software seeks to digitize the job site
    OregonLive.com
    Viewpoint Construction Software wants to bring a stubbornly old-school industry into the digital age. Portland-based Viewpoint says the construction job site remains awash in paper - from old-fashioned punch lists to manual timecards. The result, the ...


    CRN

    Pivotal Warns Of Spectre, Meltdown Performance Impact, Says All Versions Of Software 'Potentially Affected'
    CRN
    Pivotal Software released a high-severity advisory warning regarding the Spectre and Meltdown security issues, reporting that all versions of Pivotal software products could be "potentially affected" and saying it is waiting for Spectre patches to be ...

    and more »

    Business Insider

    The best tax software you can buy: TurboTax, H&R Block, and TaxAct
    Business Insider
    That may sound scary, but reputable tax software companies like TurboTax, H&R Block, and TaxAct take your security very seriously, so you can count on these services to protect your information. You can file your taxes electronically after using tax ...

    and more »

    Star Local Media

    New software means shorter wait times for emergency calls
    Star Local Media
    Frisco's emergency service dispatchers are using a new software system that is expected to reduce wait times for high priority incidents by 15-30 percent, Chief of Police John Bruce told the City Council Jan. 2. β€œIn working together, we have ...


    VentureBeat

    Indianapolis' Springbuk raises $20 million for its employer-facing health analytics software
    VentureBeat
    Springbuk, an Indianapolis-based provider of health intelligence software, announced today that it has raised a $20 million series B round. The round was led by HealthQuest Capital and Echo Health Ventures. St. Louis-based Lewis & Clark Ventures and ...

    and more »

    Infosecurity Magazine

    14 Flaws in Popular Software Are Putting ICS at Risk
    Infosecurity Magazine
    A variety of serious vulnerabilities have been identified in popular license management software used in corporate and industrial control system (ICS) environments to activate software on PCs and servers. According to Kaspersky Lab ICS CERT researchers ...

    Google News

    Collaboration Software: Index of Collaboration Software Technologies

    Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

    Make or Break Factors - When Considering Estimating Software

    Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

    What to Do if All Screensavers Fun is Grayed Out?

    Finally, you have some time to personalize your desktop with... Read More

    Reporting Tools for Microsoft Great Plains ? Overview For Developers

    Looks like Microsoft Great Plains becomes more and more popular,... Read More

    Helping Newbies Understand Professional Software

    The Windows registry is a huge database that ensures normal... Read More

    Three Steps To Windows Safety Heaven

    Now there are Three Steps To Heaven Just listen and... Read More

    Groupware Finds Home in American Business: Collaboration Tool Analysis

    What is Groupware?Have you ever had to manage document collaboration... Read More

    The Opera Alternative

    Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

    Understanding XML Server

    XML Server can be a Web Server that stores the... Read More

    Need of Document Management System (DMS)

    Document Management or Enterprise Information Management is perhaps one of... Read More

    Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

    Microsoft bought Navision, Denmark based software development company, along with... Read More

    Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

    Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

    Microsoft Small Business Manager Customization Options - Overview

    Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

    Professional XP Style Icons in Software and Website Development

    Using professional icons in your application or website can bring... Read More

    How To Choose A Fire Wall Software Program

    In the real world a "fire wall" is a fireproof... Read More

    Design a Web Album Using Adobe Photoshop- Part 2

    So let's begin crunching down these 300 images using Adobe... Read More

    Backing Up And Restoring Your MySQL Database

    If you've been using MySQL database to store your important... Read More

    How to Backup Windows XP Home Edition

    Your computer cost you from hundreds to thousands of dollars,... Read More

    Microsoft Business Solutions Partner ? How to Launch New IT Consulting Practice

    In the new era of internet marketing the problem of... Read More

    Spyware Protection: A Must for Any Home Computer

    Now that spyware is the single most dangerous threat to... Read More

    Getting Patched with Windows Service Pack

    Are you one of those people that keeps track of... Read More

    Microsoft Great Plains RW: Report Writer

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    Brand Your Websites URL With a Favicon

    Have you ever noticed that when you look at your... Read More

    Microsoft Small Business Manager eCommerce ? Overview

    Microsoft Business Solutions Small Business Manager is scaled down Great... Read More

    Is Your Computer Sick?

    Viruses and spyware usually show up on your computer one... Read More