DERIVE MAXIMUM VALUE FROM YOUR DATA
To obtain actionable information from the disparate internal and external data sources available to decision makers, data has to be extracted from these source systems and converted into a streamlined format suitable for analysis. Our suite of powerful data integration and modeling tools lays the foundation for fast, insightful reporting and analytics.
Integration Tools for Virtually any Data Source
Whether your data resides in SQL tables, flat files, spreadsheets, or binary files, DI's Data Integrator and Builder can access and transform these sources into a Model.
PRODUCTS: DATA INTEGRATOR / VISUAL DATA INTEGRATOR
The Data Integrator is a robust Extraction, Transformation, and Loading (ETL) tool containing a large suite of powerful data manipulation functions including joins, table lookups, and filters
The Visual Data Integrator is a good starting point for new users who prefer to define data integration workflows using graphical objects, letting the application create the underlying script syntax.
PRODUCTS: BUILDER / VISUAL BUILDER
Builder transforms data by summarizing, indexing, and preprocessing it in order to create Data Models. Automatic Model builds can be set up using DI-Scheduler. The Visual Builder is a rapid prototyping tool that provides most of the functionality of Builder using wizards that help guide the user through the Model build process.
PRODUCTS: DOMAIN EDITOR
Domain Editor is an application designed to make the data discovery and initial phases of development simpler. It uses the standard Dimensional Insight data directory structure to place integrator scripts and builder description files in a Project (called "Domain") directory. It facilitates the creation of extract scripts (called "Extracts"), combination integrator scripts (called "Scripts"), and description files (called "Models").
Data Modeling
The Diver Solution centers on our patented data Model, a highly indexed data mart. Models are constructed by creating a binary file that indexes each dimension of your data with every possible permutation. This eliminates data hierarchies and other navigational constraints. Our preprocessed and cross-indexed data Models deliver blazingly fast analysis response times.
Derive Information from your Enterprise Data
Because DI Models integrate data from any number of disparate sources, users are able to compare, for example, data collected from transactional systems with information in the data warehouse and legacy data sources or in spreadsheets and flat files. The Model build process converts raw data into valuable information, regardless of where your data is stored.