Data Collection

The key to a successful information delivery system is the ability to combine data from disparate sources for access by a variety of users. The first step to achieving this goal is to identify and collect the different data sets together into one common format.

The Diver Solution provides the ability to extract data from any source system. Virtually any data format, including text files, Oracle™ tables, SQL™ tables, MySQL™ tables, DB2™ tables, MSSQL server, and many other leading database and application formats can be accessed. Dimensional Insight allows administrators to clean and transform the data for building multi-dimensional Models.

Dimensional Insight's Extraction, Transformation and Loading (ETL) tool prepares data to be transformed into a Model. It alleviates the need for writing complex SQL scripts or queries, and allows administrators to seamlessly manipulate and integrate flat or relational files from disparate sources. Once the production environment is defined and scheduled, the files will automatically extract data from multiple data sources, run the calculations and processes, and transport the cleansed data to be transformed into a Model.