icCube server
A high-performance 24/7 production-ready real-time Analytical Server with an ETL layer. Designed for multi dimensional analysis and MDX++ standards.
If you’re a Software/SaaS solution wanting to embed analytics into your application(s), you’ll love it as icCube is MADE FOR YOU!
SUPPORT
Our team is dedicated to providing you with an excellent experience- Swiss quality support
- Zero open bug policy
- Best time to market for new user features
- Community support on stackoverflow
ARCHITECTURE
An architecture ready for Enterprise Integration- Single Java process running on any OS with JRE 8+
- Hot restart
- All user interfaces web enabled
- Build to be integrate into existing solutions (Embedded Analytics)
- Plugin framework to add custom data connectors and new MDX functions.
- Integration with all XMLA compatible reporting tools
- Limit resources allocation by role / users.
- Remote maintenance over XMLA protocol
- Customizable Authentication/Authorization
- Native integration with Excel Pivot Table (Windows only)
REAL TIME OLAP SERVER
High quality real time OLAP Server supporting standard MDX/XMLA- Real-Time Multidimensional Server made for very sparse & high dimensionality systems
- Powered by a modern JAVA Real Time In-Memory OLAP aggregation and calculation engine with focus on Quality of Services (QoS)
- Multi-threaded calculation engine
- Smart caching, dynamic code compilation and optimization
- New NON EMPTY crossjoin algorithm with multithreading support
- Partitioning → breach the 1 billion facts barrier
- XMLA protocol support
- Over 150 standard MDX functions implemented
- 18 native aggregation types (sum,min,avg, distinct,vector…)
- Over 300 MDX compliance tests
DATA INTEGRATION
Integrate multiple data sources in one schema- Relational databases
- AWS Amazon Redshift
- Generic JDBC driver
- IBM db2
- MySQL
- Oracle
- PostgreSQL
- Snowflake
- SQL Anywhere
- SQL Server
- Sybase ASE (jTDS)
- Access (JDK JDBC/ODBC Bridge)
- NoSQL integration
- MongoDB → native JSON many-2-many
- Hadoop/Impala
- Hadoop/Hive
- Google
- Google Analytics
- BigQuery
- Google GDrive (Sheets)
- Storage (CSV)
- Files
- CSV (File/HTTP)
- Excel files (CSV)
- Excel files (xls)
- JSON (File/HTTP)
- Others
- In-Memory tables (CSV)
- SPSS (sav) – Beta
- Custom connectors on demand
TRANSFORMATION LAYER
ETL: Combine and transform any icCube tables from different data sources into a new table (view)- Classic transformations
- Columns to Rows
- Row to Columns
- Group by
- Sort
- Parent/Child sort
- Union
- Join
- Column Rename
- Source Code
- Java
- Java Simple Row
- Javascript (deprecated)
SCHEMA / SEMANTIC LAYER
Define your business concepts- Define your semantic layer using icCube’s thin client IDE
- Many-to-many relation
- Unbalanced dimensions (ragged, parent/child)
- Asymmetric dimensions
- Direct definition of many to many relations when using no-sql datasources as MongoDb
- Create calculations using standard MDX language
- Localization of the semantic layer (e.g. country names on different languages)
ADVANCED ANALYTICS / MDX++
MDX+ is icCube’s extension package to the standard MDX language- Over 50 new generic MDX functions
- 45 Time Intelligence functions to manage date/time dimensions
- Categories
- Vector and Matrix syntax
- Dynamic creation of new classifications/hierarchies (Real Time)
- Non additive, vector (e.g. to support VaR, indirect many-to-many) aggregation types
- Direct access to Java from MDX
- Unique patented MDX debugger and profiler
- Native R integration for advanced statistical modeling