Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Migrating data from SA...
Microsoft Dynamics GP (Archived)

Migrating data from SAP to GP

(0) ShareShare
ReportReport
Posted on by mmclane 140

I am working with a company who just recently moved from SAP to Microsoft Dynamics GP.  They started out with a fresh install of Dynamics GP and left their SAP system behind.  We would however like to get rid of the hardware that SAP is running on and would like to migrate the data into a separate GP installation for archive purposes.  

Can anyone point me in the direction of how to do this migration?  Are there tools available to help me migrate the data from SAP to GP?  Any documentation I can follow?  I am not familiar with either SAP or GP but I have been charge with figuring out how to do this.

Thank you in advance,

Matt

 

*This post is locked for comments

  • Daniel Cai Profile Picture
    Daniel Cai 935 on at
    RE: Migrating data from SAP to GP

    Matt, please also check out our solution that is built on top of Microsoft SQL Server Integration Services (SSIS) by utilizing SSIS capabilities. 

    The tool is available at http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-gp. Check it out and let us know if you need any assistance or anything. 

    Cheers,

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Migrating data from SAP to GP

    Matt, from a GP integration perspective, also have a look at Scribe and eConnect's SmartConnect.  Depending on the kind of data you need to migrate, Integration Manager might not cover it all.  I.e., if you have MFG or Field Service data to migrate, you'll need more than Integration Manager can offer.  Redbeard makes a great recommendation re: MFG tools.


    I cannot stress strongly enough that you will need a talented SAP resource to extract the data and a strong GP data migration resource to format the SAP data for import to GP.  Make sure you have those two individuals lined up and they can tell you what tools they prefer to use for the migration.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Migrating data from SAP to GP

    WilloWare.com has a number of really cool enhancements and tools centered around the Dynamics GP Manufacturing Suite - BOM Import is just one of them.

    willoware.com/.../bomimport

    I have a strong preference for WilloWare, they have deep roots in Dynamics GP manufacturing and a lot of consistency.

  • mmclane Profile Picture
    mmclane 140 on at
    RE: Migrating data from SAP to GP

    What are some of the 3rd party tools that are available?  I would like to go have a look.

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Migrating data from SAP to GP

    Matt,

    Frank is correct.   I worked on a similar project in 2012 - the fields in SAP have interesting names; like "Material Number = RC27M-MATNR" and "Standard Value

    = PLPOD-VGW03(01)").  SAP has templates, which translate these field names, and I have several, but I have no idea how useful they would prove.  

    The other side of this, of course is having an understanding of where this data resides in GP.  So, Jonathan gets a gold star for recommending Integration Manager as a means to getting the data into GP!

    If you look closely, Integration Manager covers a lot of integration points, but doesn't cover Manufacturing Modules, like Bill of Materials, Routing, Machines, Work Centers, etc.  There are other utilities meant to meet these needs.  There are also some cool 3rd Party tools available.

    Our project was successful because the client had resources on both the SAP and Dynamics side, who understood the tables of their respective tools.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Migrating data from SAP to GP

    If you can get the data from SAP into a txt or Excel file I would go with Integration Manager as it provides the most flexibility.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Migrating data from SAP to GP

    Matt, in my experience you need a SAP resource who can extract and re-format the data from SAP into a format that GP can use.  SAP table structures are totally different from GP tables.  It's a challenging exercise if you've never been through it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans