|
 |
| BI Data Extraction, Transformation & Cube Management and ETL |
 |
|
|
|
|
|
Next-generation Platform for BI Data Integration
Taking your data that resides in multiple data sources, transactional applications or any other legacy database system; Web-based ElegantJ BI Data Integration delivers meaningful information to all users presenting them with reliable, accurate information for their enterprise reports, business intelligence analysis and business dashboards.
Makes for a more
confident business intelligence! |
 |
|
|
|
|
|
|
|
In the information era, data volumes continue to grow exponentially with enterprise data within an organisation coming from any source - including data warehouse, data marts, ERP/CRM and any number of operational system databases. Enterprise data management and making sense of it has in itself become a formidable task.
Data Extraction software and Cube Management solution ElegantJ BI allows companies to Extract, Load and Transform ( ETL ) through easy to use graphical interface. They can extract value from data that today can be inaccessible within your various business applications. While providing you the desired flexibility through a single, powerful web-based unified ElegantJ BI’s Business Intelligence Platform, you can have integrated views of business intelligence data from across heterogeneous data. By easy-to-use interactive wizard or through SQL query, different sources can be mapped to multi-dimensional ‘cubes’ from practically anywhere. |
|
|
Business Benefits At A Glance |
|
|
|
| › |
Web-based Configuration Anytime, Anywhere |
| › |
Easy-to-create, easy-to-maintain and easy to use 'cubes' |
| › |
Flexible, Self-service data manipulation |
| › |
Integrated data from spreadsheets and other common databases for reporting |
| › |
Scheduled data extraction for periodic updates from data sources |
|
|
|
| Key Features Of Data Extraction, Transformation And Cube Management |
|
| Powerful Cube Management, Usable, Reliable Data |
| Data Extraction software and Cube Management solution ElegantJ BI’s Data Integration and Cube Management provides data access solution to extract, aggregate, transform and load across multiple disparate data sources from databases, applications, as well as spreadsheets and other common databases and documents. The ElegantJ BI Cube repository serves as the enterprise-wide uniform information repository that enforces common view of business intelligence data throughout the organisation. |
| |
| Simple, web-based wizards used to create multi-dimensional cubes opens up the integration environment to all types of users – from technical IT to non-technical and business users to be able to more easily access the information they need from within different transactional or operational business applications. |
|
| |
| Single, Meta-data Layer |
|
| Data Extraction software and Cube Management solution ElegantJ BI’s Unified Business Intelligence Platform draws data from a single data repository for consolidated, rationalized analytics for business users and data architects. The single, ElegantJ BI metadata layer helps build a standard data access framework as well as provide end-users with ad hoc query capabilities. |
| |
| Fast Data Access |
| Unlike ODBC connectivity that link to different data sources dynamic cubes allow you to pull and cache data from your operational databases on a scheduled basis specifically for reporting. Data Extraction software and Cube Management solution ElegantJ BI’s Cubes combine data sources on time for better, faster enterprise reporting depending on user needs. |
| |
| Feature Highlights |
|
|
- Connect & extract data from JDBC manageable Relational Databases and Data files (CSV files)
- Configurable database connection profiles
- Create cube with easy to use interactive wizard, or through SQL query
- Command line interface to create and update cube
- Scheduler support to refresh cube automatically
- Refresh cube with incremental update option
- Email notification on various cube events for failure or success
- Prior verify cube size before creating cube
- Compress cube to reduce size
- Dimension map and logical hierarchies
- Multi-node multi-hierarchical dimension map
- Automatic multiple time dimension generation
- Financial Year and Calendar Year within Time Series
- Create Linked cube from existing cubes by supporting JOIN and UNION
- Create Multi-DB cube from multiple data sources
- Single cube repository listing of all cubes
- Cube Repository Objects for Custom Measures, Custom Dimension Values, Spot Lighters, Data Value – Display Value Mapping
- Automatic Time Series on date fields with Year, Quarter, Month, Week, Day, Hour, Minute and Second hierarchy
- Cube rebuilt right for non administrative users
|
|
| |
|
|
|
| |
Learn about our world-class Business Intelligence Architecture and how your business can benefit from Enterprise Data Management and ETL from ElegnantJ BI. |
|
|
|
|
