Data Mapping Utility

Map product data files from any source

epaCUBE Data Mapping Utility is a data transformation tool designed for the business end user to easily map product data files from any supplier or from any other ASCII data source into the epaCUBE Product Data Management system.

As a distributor have you ever faced these challenges when loading in product data into your systems?

  • IT personnel are the only ones in your organization with the technical ability to use mapping tools
  • Losing time and productivity as older processes require excessive collaboration between IT and business users
  • Mistakes made as the technical person loading product information does not understand the context or use of data
  • Traditional ETL tools are too complex for the business user
  • Tools available are not designed specifically to map data originally developed with the intent of being read manually

Most distributors face the same problems. Fortunately, epaCUBE Data Mapping Utility has the answer.

"The DMU (data mapping utility) has made our jobs much easier as well. Where we used to update our price and cost for each of our branches separately (7 branches) we now can update all 7 at one time. Plus again, the ability to scrub and correct data across multiple records versus one record at a time is much easier." -- Industrial and Electrical Distributor

epaCUBE Data Mapping Utility helps you solve these data mapping problems and more.

  • Graphical Point and Click ETL Tool for Business Users (those closest to understand the product data) can use.
  • Easily load data from one system to another, from flat files into a system, or to generate flat files for complete portability.
  • Transformation functionality can be further enhanced by the use of simple Microsoft Excel, Access, or Visual Basic commands
  • Built-in wizards support the transformation of data with point-and-click functionality covering:
  • Save Time for both Business Users and IT
  • Uniquely and Specifically Designed for transforming Product Updates
  • Relieve mapping burden from IT for day to day vendor cost update files

Here’s how epaCUBE Data Mapping Utility delivers real results to distributors

  • Built-in wizards support the transformation of data with point-and-click functionality covering:
  • Text Case (UPPER, lower, Proper)
  • Field Length
  • Parsing
  • Character Padding
  • Left, Right, Mid functions
  • Rounding
  • Convert Data Types
  • Joining Multiple Fields
  • Default Fields / Values
  • Field / Value to use when chosen field is blank (null)
  • Cost Cascades…Aligning Price and Qty Break data with target system configuration
  • Work with aggregate values, such as Min, Max, Avg, First, Last…
  • With multiple values available, work with only the current effective date, next effective date, earliest effective date, etc.
  • Fill blank fields with values from previous, valid records
  • Character Stripping Character Substitution (Replace)
  • Supports any ODBC compliant system
  • Transports data / creates flat files to and from:
    • Fixed Length Files
    • Delimited Files
    • ODBC connected tables
    • ODBC Pass-thru queries
    • XML / XSD Tables
    • Excel (Multiple worksheets concurrently)
    • Access databases
    • User-defined queries

Learn how the epaCUBE Product Data Management Suite can help you keep all your systems running smoothly with “clean burning fuel” in the form accurate, up-to-date product data.