A transactional data store (e.g. MS SQL Server, Oracle, etc.) typically handles high data volumes and enables flexible analysis, whereas multi-dimensional architectures (like Jedox, TM1, etc.) are optimised for write back, simulation and modelling.

This multi-tiered approach typically results in integration challenges, when a combined view is required. Extensive ETL (Extraction, Transformation and Loading) processes have to be developed which require extensive consulting or internal development efforts.

The new Managility PowerSync framework addresses this challenge with a one click solution that converts and synchronises OLAP sources into a relational dimensional model.

This enables:

• A one version of the truth Data warehouse that integrates all BI architectures for example easily create a Power BI dashboard with your Jedox data
• Complete control of of all transactions for audit and restore purposes
• Access with nearly any BI front end/ reporting tool that supports relational access (Power BI, YellowFin, Tableau, etc.)
• An easy integration of external cloud based data streams
The PowerSync framework is currently available to Managility clients with every project implementation. A stand-alone, public available software version will be released soon. Please contact Managility to discuss partnership and early adopter options.

Specifications:

Platform: Windows .NET Server component or Python Service for Linux

Supported RDBMS: MS SQL Server, Oracle

Supported OLAP: Jedox Base and Premium and Palo. TM1 support coming soon.