Capabilities > Data Integration

• capabilities
• about 6.2
• data modeling
• data integration
• dashboards
• analytics
• reporting
• alerts
• on-demand

Click HERE to download a PDF of DI's Capabilities Data Integration data sheet.

Click HERE to download a PDF of DI's Model Construction data sheet.

You will need Adobe's Acrobat Reader to view the data sheets listed above. To download a copy of Adobe's Reader for FREE, click GET READER now.

data integration

DERIVE THE 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 lay the foundation for fast, insightful reporting and analytics.

SEEMLESS INTEGRATION TOOLS FOR VIRTUALLY ANY DATA SOURCE Whether your data resides in SQL tables, flat files, spreadsheets or proprietary vendor formats, 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 that contains 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 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 dialogs 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").

According to the Aberdeen Group's Business Intelligence: Reporting and Analytics AXIS report, Dimensional Insight customers possess data integration capabilities that rank with best-in-class, thanks to Data Integrator's extensive and robust functionality. Click here to download the report.