Software Information

How to Upgrade Dexterity Customization - Tips for IT Manager


If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity - you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE.

Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics.  Today it is legacy and Microsoft Business Solutions is phasing Dexterity out.

However Great Plains 7.5 and even 8.0 is Dexterity based application, so you have to deal with it and it's customization.

 

Good news.  Prior to version 7.0 Great Plains had plans on expanding GP functionality and so was changing tables structure - forcing Dexterity customization to be analyzed and partially rewritten with each upgrade.  Not any more - GP structure stays the same - Microsoft is doing new modules acquisition and unifying it's graphical interface to move all it's ERP packages: Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal.

 

Still pain.  Dexterity has possibility to customize existing Great Plains screens, so called Alternative Great Plains forms.  This was upgrade problem in the past and it stays now - there is no way to do it in house (until you are willing to pay for full-time internal developer - who is usually in the learning curve).  You got to bring in consultant.

Recommended approach.  You should have the strategy to migrate Dexterity customization to SQL, Crystal Reports, custom web publishing - Visual Studio.net and slowly abandon Dexterity customization

  • SQL Stored procedures - performance improvement.  Consider replacing dexterity data manipulation with SQL stored procedures.  Dexterity is cursor-driven language and it is not efficient when processing huge datasets.
  • Crystal Reports.  Take advantage of open and leading technology.  Crystal Reports will eliminate the need in the future for painstaking Dexterity reports upgrade.  Base you Crystal report on the SQL view or stored proc
  • Do direct web publishing off your GP database.  Use Visual Studio - it is easy to find specialists and have them in staff.  We are in the World when web publishing is very easy.
  • Good luck and if you have issues or concerns - we are here to help! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.


    MORE RESOURCES:

    ChattahBox

    Facebook Co-Founder To Leave For Own Software Startup
    InformationWeek, NY - 1 hour ago
    Now, he plans to launch a software startup, according to reports on the Valleywag.com Web site. The Silicon Valley publication said that CEO Mark Zuckerberg ...
    Facebook Cofounder Leaving To Start New Company NewsFactor Network
    Facebook co-founder quits Siliconrepublic.com
    Facebook co-founder calls it quits ITWeb
    VentureBeat - LinuxInsider.com
    all 50 news articles


    GameSHOUT

    Sales of RealDVD movie copying software halted by judge
    Dallas Morning News, TX - 4 hours ago
    Software to do that has existed almost as long as DVD discs, but this is one of the first efforts by a mainstream American company to try to make such ...
    RealDVD Sales Suspended In Tinseltown Showdown CRN
    RealNetworks Halts Sales of RealDVD PC Magazine
    RealDVD sales suspended under court request ITworld.com
    Forbes - ZDNet
    all 28 news articles


    Patterson Cos. acquires supplier, software maker
    CNNMoney.com - 1 hour ago
    based Patterson said it was acquiring software company Odyssey Veterinary Software LLC. Patterson shares fell $1.20, or 4.1 percent, to $27.67 in afternoon ...
    Patterson Companies Acquires Leading, Value-Added Distributor of ... MarketWatch
    Patterson Cos. acquires Columbus Serum Bizjournals.com
    Patterson buys Ohio veterinary company Bizjournals.com
    all 23 news articles


    Callidus Software Names Jimmy Duan Senior Vice President of Mid ...
    MarketWatch - 7 hours ago
    There are tens of thousands of companies in the mid-market segment, which represents a great opportunity for Callidus Software. We are pleased to have Jimmy ...
    Callidus Software Schedules Third Quarter 2008 Financial Results ... Business Wire (press release)
    Callidus Software Names Jimmy Duan Senior Vice President of Mid ... TMC Net
    all 19 news articles


    Visual Analytics Achieves Protection Level 3 Certification for its ...
    MarketWatch - 4 hours ago
    The certification allows the software to operate under DoDDIS, which is managed by the Defense Intelligence Agency (DIA). Under the certification process, ...
    Tableau Software and AHIMA to Offer Visual Analytics Software to ... MarketWatch
    all 19 news articles


    TopCoder Joins Lineups for SD Best Practices and Software Business ...
    MarketWatch - 3 hours ago
    TopCoder, Inc. today announced its participation in two premier software industry conferences scheduled for the end of October. In Boston, TopCoder will ...


    Dividend.com

    SAP Announces 2008 Third Quarter Preliminary Software and Software ...
    MarketWatch - 3 hours ago
    announced today that after a preliminary review of its 2008 third quarter revenues, it expects third quarter 2008 US GAAP software and software-related ...
    Europe's largest software company SAP warns on profits guardian.co.uk
    SAP's Third-Quarter Revenue Growth Trails Forecast (Update2) Bloomberg
    SAP: first to hit the buffers ZDNet
    Reuters UK - guardian.co.uk
    all 151 news articles


    Snap-on Announces New Diagnostic Software for Navistar(R) Engines
    MarketWatch - 53 minutes ago
    NAVPAK replaces the current Navistar MD32 Master Diagnostics Fleet software. Technicians using NAVPAK will benefit from a PC-based application that supports ...


    Given Imaging Launches RAPID(R) 5 Access Software
    CNNMoney.com - 7 hours ago
    Given Imaging Ltd. (NASDAQ: GIVN) today announced the launch of RAPID 5 Access, new software that facilitates physicians' reading PillCam videos anytime, ...
    Given Imaging Launches RAPID(R) 5 Access Software MarketWatch
    Given Imaging Launches RAPID(R) 5 Access Software International Business Times
    all 11 news articles


    Healy Hudson Teams With IBM for Software as a Service Solution
    MarketWatch - 4 hours ago
    have signed a five-year, five million euro Software as a Service contract. As part of the agreement, IBM will support Healy Hudson's e-placing solution ...
    Healy Hudson Teams With IBM for Software as a Service Solution International Business Times
    IBM opens Scottish data centre CRN - UK
    IBM Invests £2 Million in Scotland for New UK Services Business ... International Business Times
    all 22 news articles

    Software - Google News

    home | site map
    © 2006