How to integrate Mondrian in Microsoft SQL Server

Discover how to integrate Mondrian and Microsoft SQL Server and instantly get access to your data.

WITH PIPES OR PIPES PROFESSIONAL
How to integrate Mondrian in Microsoft SQL Server with Pipes
WITH THE LOGICAL DATA WAREHOUSE
How to integrate Mondrian in Microsoft SQL Server with Logical Data Warehouse


About Mondrian

Mondrian is an open-source Business Analytics engine that enables organizations to give business users access to their data for interactive analysis. Users can build Business Intelligence solutions with Mondrian as an Online Analytical Processing (OLAP) engine, enabling multidimensional queries against their business data, using MDX query language.

About Microsoft SQL Server

Microsoft SQL Server is a popular relational database management system. As a database server Microsoft SQL Server stores and retrieves data which may run either on another computer across a network or on the same computer, requested by other software applications.

What is Data Virtuality?

Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to Mondrian, Microsoft SQL Server and more than 200 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the Data Virtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.

IMMEDIATE DATA ACCESS

Connect over 200+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data directly with your favourite business intelligence and analysis tools.

CENTRAL DATA MODEL

Build your single source of data truth and set uniform definitions for your data. Connect your business intelligence tools to Data Virtuality and make sure everyone in your organisation works with the right data.

ALL IN SQL

With Data Virtuality you can query all data sources with SQL regardless of the file format. NoSQL, CSV or XML File: We transform any connected data source in SQL.

REAL-TIME REPORTING

Data Virtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in your organization get the right information, in real-time if needed.