Data Migration for Acumatica

Import Data

Import and generate master records, opening balances, and handle relationships between your data when you import from your legacy ERP into Acumatica.

eOne’s SmartConnect provides a no-code interface that lets you handle the details for custom requirements and generate data with the right transformations from any source to any destination.

Archive to Data Lakes

Your accountants and team will need access to your ERP data history, but ERP history is really complicated to move to a new ERP environment. This is mainly because of two things.​

First, data is related (items, salespeople, customers, transactions). All the related data needs to be associated correctly.​

And second, every transaction you move needs to be brought into your new accounting system unposted and then re-posted down to the cent.  20 years (-ish) of history requires a really expensive effort to map and move the data to your new ERP and just is not recommended. ​

The good news is that Popdock provides a better strategy to archive and provide data access to historical data.  Popdock includes the tools to make a copy of specific data sets, attachments, and your entire database to store in either your Microsoft Azure Data Lake or your Amazon Web Services S3 cloud storage account.  With the Popdock Data Upload Tool (link page), you have a configurable interface to select the data set you want to archive, optimize the performance, and organize your data for reporting.​

​This is a fast and affordable strategy to manage your historical data and allows you to retire expensive legacy servers and environments.

Access History

Whether your data is archived to a data lake or stored in an older environment, Popdock provides an interface for users to access history.  ​

​Allow users to search, query, view attachments, and create reports that include your history from within Acumatica or via the Popdock app.

Report on History + New ERP Data

Access reports from your legacy ERP environment and create reports that combine new Acumatica and legacy ERP data. Popdock’s custom lists provide options to join, merge, compare, and summarize data from multiple sources into one custom list.