Solution Synopsis :: Data Migration

The following are selections from Symmetry’s data migration and conversion projects. This synopsis summarizes solution highlights and salient information. Detailed case studies with solution details are available on request.

Migration of Everest Enterprise Data to Ofbiz

The client, a chain of eCommerce stores, planned to move their SQL Server-based eCommerce platform from Everest to Ofbiz, a popular web-based, open-source, eCommerce software. The client had over 10 years of application data - 50,000 products, over 900 vendors and 10,000 customers. Since the product structure and configuration was the lifeline of the business, it was critical that the data migration to OfBiz was seamless and complete. The client extensively used configurable products, matrix-type items, price levels and multimedia elements, all of which had to be accurately and completely brought into Ofbiz.

Before migration, the legacy data structure was first mapped to the different tables and data in Ofbiz. A mirror of Ofbiz’s products, customers and supplier tables were created in SQL Server. Legacy data was first ported to the Ofbiz tables in SQL Server. The data was then converted to XML using one of Symmetry’s database utilities. The XML files generated were imported into Ofbiz using Ofbiz’s XML import tools.

Data migration from Everest Standard to Everest Enterprise

Symmetry managed the data conversion of a client’s customer, vendor and accounting data from its legacy DBF/CDX database to SQL Server. After an exhaustive analysis of client data, Symmetry created a data conversion utility that ported the data to Everest’s SQL Server database.

Data migration from Everest Standard to NetSuite

The client, a firm distributor of computer hardware, planned to move their business software to NetSuite. The client was using a tier-2 accounting software product that ran on Advantage and were in the process of migration to the NetSuite platform. The client had 3 years worth of data and wanted to move all existing customer and order data to the NetSuite platform. NetSuite allows import of legacy data from CSV files. Symmetry analyzed the client’s customer, order, address, sales tax, items and other data for relationships. Symmetry also performed an analysis of the CSV structure required by NetSuite. The Advantage database was then mapped to fields required by NetSuite. There were areas such as sales tax codes and tables where a straightforward mapping was not possible. The client’s existing business software had a multi-level tax structure based on US zip codes. Symmetry had to devise the business rules to map the existing sales tax structure to NetSuite’s tax codes. After the analysis, Symmetry developed a data conversion utility that converted data in the Advantage tables to CSV files which were then imported into NetSuite.