ETL / Data Warehousing
Organizations of all sizes and industries seek to improve overall business operations through the consolidation and subsequent analysis of business data – referred to as business intelligence through data warehousing. Figures from the Data Warehousing Institute state that ETL development work normally consumes up to 80 percent of all business intelligence projects. With such an excessively expensive task for successful business intelligence, it is essential that the ETL portions of BI projects are built and maintained in a pragmatic way with easy-to-use tools that offer tremendous flexibility and design control.
Pervasive Software's solution for ETL and data warehousing provides a single easy-to-use development environment, named djCosmos, that will speed deployment, minimize the impact of system changes and new user requirements, and minimize project risk. djCosmos is a multipurpose and configurable data integration design and execution environment that enables the extraction, cleansing, and standardization of data from all sources throughout your organization, helping you to maximize the potential of your data in business decision-making processes.
Benefits
-
Easy to use and administer design interfaces, with instant debugging features that are accessible to users of all skill levels.
-
djCosmos offers unmatched data mapping and transformation strength and control through its Map Designer’s patent-pending event-driven data flow model.
-
More than 100 native data connectors for incorporating any data into the warehouse – including mainframe/legacy, relational databases, flat files, XML, native load utilities, Web, packaged applications, and much more.
-
A rich and powerful Rapid Integration and Flow Language (RiFL) for transforming and manipulating data and its flow throughout the ETL and integration process.
-
The only ETL and data integration tool set to save and store all design metadata in an open XML-based design repository for easy metadata interchange and reuse with other processes, and BI and modeling tools. |
-
High performance data throughput via configurable, multi-platform Integration Engines and Wrappers.
-
Real-time integration – Capture and update changes that have occurred in the source systems since the last load.
-
Decentralized execution of ETL processes -- the uniquely configurable Integration Engines allow data to be extracted and transformed at its source of origination for subsequent transfer and loading into the central data warehouse.
-
The only ETL solution that fully supports unstructured data. |
