Are your data integration (ETL) estimates accurate?
Do your data loads correctly transform business rules?

Implementing a new software system or data warehouse is a major investment for any business. Companies invest millions in planning, developing, and implementing a new IT project. What will the data look like in the new system? What should it look like? Many underestimate the transformation requirements and their impact on migrating or converting transactional data into a new environment. As a result, many implementations fail to evaluate all of the business rules for their data migration, i.e., they cover the 80 percent that occur in the majority of cases but miss up to 20 percent of highly specialized business rules. Our experience is that completely evaluating source business data and correctly modeling it to meet target requirements will significantly reduce the effort, duration, and lowers the total cost of the implementation as well as reduce risk of bad implementation.

CAI developed a highly focused methodology for capturing the business requirements of our clients’ data. Our Data Mapping Tool, Data PRIME, enables shortened implementation and dramatically increases quality of the data migration. By focusing on and automating this aspect of the implementation, Data PRIME reduces the time required to capture data mapping requirements by up to 50 percent. This reduction of effort ripples throughout the project timeline as it increases accuracy, enhances understanding of the business meaning of data in source and target systems, and reduces the number of iterations needed to complete the conversion.

About Data PRIME


Data PRIME is a browser-based product used to capture all transformation requirements for business data. We use it to ensure comprehensive tracking of source data. This enables our clients to account for all data elements in their data conversion projects. Data PRIME is independent of the ETL tool selection, allowing a project to begin mapping before the ETL tool is selected.

Data PRIME

provides a simple, effective framework for documenting extract, transform, and load (ETL) rules and allows us to present them to the user and technical community in terms that they understand.

Our Process

CAI uses a business driven source-to-target mapping process to document the meaning of data. Data PRIME provides an efficient and effective framework for documenting data integration requirements. The process begins with loading the tool with the source and target data element information. The data elements are then mapped and transformation rules are documented. We iteratively present the results to the user and/or technical community in terms they understand until consensus is achieved. Finally the source-to-target requirements are imported into technical specification documents and coding can begin. You can be confident that all data elements are accounted for during the requirements phase.

Features include:

  • Map source-to-target for tables and columns
  • Mapping View Options
  • Supports 1:1, 1:M, and M:M mapping

Data PRIME is technology-neutral and accepts standard data definitions derived from industry-leading tools and database management system catalogs such as:

  • erwin Data Modeler
  • Microsoft SQL Server
  • IBM DB2
  • Oracle RDBMS

Data PRIME in Action


There were 4,000 tables to address for conversion for the project and mapping was accomplished using Data PRIME. With a mapping speed of roughly 1,000 tables per week, Data PRIME kept us organized and ahead of schedule.
Data PRIME was the key in this conversion and assisted our efforts immensely. As a result, mapping requirements were delivered to the client 1 month prior to the deadline. Data PRIME’s comprehensive tracking promoted good discussion with the client and the end result was a solid reference for our developers as well as the client.
Data PRIME’s value continued to deliver as we rolled through conversion. All information for reporting was easily identified within Data PRIME and grouped by subject matter area. I had never used Data PRIME or the erwin Data Modeler application before but due to the ease of use and the value in return, I could not image this project without Data PRIME.