Basically, MetaRecon provides exhaustive statistical analysis of the tables or databases and does not need to know anything about the database other than table or column names. We reverse engineer the meta data from the actual source "data" and then we provide the following information. MetaRecon completely automates and integrates the process of building an EDM system.
MetaRecon employs a sophisticated reverse engineering process to allow the user to load raw data into our software and automatically receive a complete analysis of the source data. MetaRecon analyzes the source data, providing recommendations for the target database, such as primary keys, foreign keys, table splits, normalization, dimensions, measures, and views of the data.
MetaRecon uses this information to build a model of the data.
The result is the optimal target database for the EDM application.
MetaRecon automatically generates an extraction, Transformation, and Load (ETL) job for loading the target database from the source.
MetaRecon allows a user to generate the application in their familiar EDM tools, but from a single environment.
MetaRecon allows users to integrate multiple disparate systems by providing a complete understanding of the meta data and generating the ETL programs to merge the data.
Since the application is automatically generated, the speed of implementation is dramatically increased.
Because the meta data is based upon the actual source data, accuracy is 100%, avoiding the code, load, and explode phenomenon.
MetaRecon's tight integration with MetaTrans allows for integration of data from legacy systems.
The outcome is an implementation that avoids the problems commonly encountered by EDM projects.