querona-logo Request a live demo

Our product

Querona is a virtual database that seamlessly connects any data source with Power BI, Microsoft Excel or others. It lets you build your own universal data model and share it among reporting tools. Querona does not create another copy of your data unless you want to accelerate your reports and use built-in execution engine created for the purpose of Big Data analytics. Just write a standard SQL query and let Querona consolidate data on the fly, use one of the execution engines and accelerate processing no matter what kind and how many sources you have. querona-scheme querona-scheme Querona simplifies architecture comparing to classical data warehouses. It eliminates time-consuming ETL and enables data consolidation on the fly. The data model is separated from the execution engine and the BI front-end. It lets business users use their most appreciable presentation tool.
Compare to a classical data warehouse

Querona works nicely with others

 

We integrate data from 128+ types of sources

Multiple data sources have become increasingly common. Business user need to mix and match data from many internal and cloud sources of different types and vendors. And they need to get immediate results.

Querona provides a set of connectors to more than 100 types of data sources and makes them connected in a few clicks. No matter what kind and how many sources you have, you get secure and real-time data access using the standard SQL dialect.

1

We accelerate query execution with leading data engines

When dashboards slow down, you can retarget queries to another execution engine. Just indicate where to prepare data extract and let Querona do the rest. Leverage the built-in big data engine Apache Spark 2 or use external data processing engines like Microsoft SQL Server, Azure SQL Data Warehouse, Apache Spark on Hadoop or a combination of 15 supported data engines. Improve reporting performance by enabling caching and preaggregation. Eliminate connectivity bottlenecks, data processing overheads and benefit from columnar data processing instantly.

2

We present results on any reporting tool. No drivers needed

Marketing teams are using Power BI, finance QlikView and sales teams are allergic to anything but Excel? We’re fine with that. Any presentation tool can be used and no drivers are needed on user’s machines. Querona fully emulates Microsoft SQL Server, lets you build a central data hub, and present dashboards in any tool that supports standard Transact-SQL. Just connect to Querona using Windows Integrated authentication or standard authentication mechanism as if it was SQL Server.

Let your users use what they are familiar with. They will love that flexibility.

3

How does it work?

screen
1

Import all data sources

Your business decisions depend on data from multiple data sources. Simply import all your databases, CRM or ERP systems into one virtual database. Just a few clicks, no ETL involved. Now you have access to all data from a single data hub.

Access all data sources in real-time

Real-time analytics is crucial for business success but hard to achieve for multiple data sources. Querona enables live access to any data using just standard SQL. Cloud applications, databases, CRM-s, and ERPs unified.
2
screen
screen
3

Consolidate data across data sources

Have you ever tried to join ERP and CRM data and had to wait until your data sources are included in a data warehouse? Simply build a data consolidation layer using our self-service interface. Now you can consolidate data in real time.

Accelerate reports and queries

Data volumes are rising, dashboards slowing down. You need a Big Data capable SQL Engine, but data loading to Hadoop is a complex task. Querona has replaced ETL with just a single click to cache data in Hadoop. Offloading query execution and data loading to a cloud or on-premise SQL engines like Apache Spark SQL is not a challenge.
4
screen
screen
5

Apply data security

It is never easy to enforce secure access to all data sources. Securing a cloud data warehouse or a Hadoop Data Lake is an even bigger challenge. Querona is a central data hub to your data sources. You can easily apply access rights at any level to any data. With single-sign-on using NTLM and Kerberos, row and column security and dynamic data masking you have it all in one place.

Access data from any client tool

Access to real-time data depends on the driver setup on client machines. Querona emulates the Microsoft SQL Server protocol which means you simply use any client tool that supports SQL Server. Imagine that you create an Excel worksheet connected to Querona and distribute the file throughout the company, allowing any user, limited only by their access rights, to query data on-the-fly.
6
screen

Features to explore

Data Hub
Data Hub
Big Data enabled
Big Data enabled
One-click data loading
One-click data loading
One-click data loading
Query acceleration
One-click data loading
Real-time data access
One-click data loading
Any BI client connectivity
One-click data loading
Data security
One-click data loading
Self-service
One-click data loading
Cloud offloading

Data hub


Querona is a virtual database that allows pass-through access to all corporate data sources from one place – now reporting is simpler. There is one place to find all data sources.


Querona accepts standard SQL (compatible with SQL Server) and translates queries to run them on other databases. You can run full SQL on any data source, no matter if it is SQL Server, Oracle or a cloud applications like SalesForce or Marketo. Data exploration, data preparation and report prototyping are available instantly.

Big Data Enabled


Querona combines traditional Business Intelligence with Big Data processing. The Logical Data Warehouse may now grow following the increase of the data volume in the future. You can build a future-proof Data Lake.


The integrated Apache Spark engine makes it possible to start processing Big Data just 5 minutes after setting up Querona. Migration to a Hadoop cluster on-premise or in the cloud is just a configuration change. The Querona price does not depend on the data volumes or the Spark cluster size.

One-click data loading


Data preparation for reporting always depends on building ETL processes that load data to a data warehouse. The Logical Data Warehousing architecture in Querona simplifies the process just by simply selecting which source tables should be cached, when and where. Data analysts may prepare reports faster and benefit from rapid prototyping.


Querona additionally enables data loading to Hadoop clusters. No need to hire Hadoop experts and wait several weeks for a project that uploads corporate data to a Data Lake.

Query acceleration


Querona accelerates queries using dynamic query rewriting. It is now possible to build an efficient cube and cache pre-aggregated views on any SQL database. Existing dashboards may be instantly accelerated by defining pre-aggregates. Now a report that was querying 100M rows would process just a few thousand rows in a cached preaggregate and therefore a slow report will show with no delay.


Internally Querona processes data in columnar format. Direct integration with Apache Spark and an end-to-end columnar processing enables unmatched performance.

Real-time data access


Querona enables secure and real-time access to all data sources. All data sources may be queried using the SQL dialect compatible with SQL Server. Now users can get live data no matter where it is stored. Querona supports predicate push-down, join push-down and the best execution plan is selected by our cost-based optimizer.


Of course some data sources or OLTP databases are too slow or too busy to be queried live. Querona solves the issue by caching data on a selected SQL database or on Apache Spark. Caching supports partitioning and high availability refresh to enable fast query execution, with non-stop access to the cache.

Any BI client connectivity


Querona emulates SQL Server and exposes a SQL Server compatible interface. Any SQL Server driver (ODBC, JDBC, ADO.NET) can connect and execute queries without the need to install vendor specific drivers.


This feature allows expansion of Business Intelligence to all users in the company. Secure, cached or live data access to all corporate data sources may be possible even from Excel.

Data security


Querona supports Windows Integrated authentication and fully integrates with Active Directory. Over 50 types of access rights may be assigned at multiple levels and are enforced in one place over all on-premise and cloud data sources.


Role based security, column data access, row data access and dynamic role based data masking enable unified access to any data source. A cloud data warehouse or a Hadoop cluster may be easily integrated and exposed to users without risk.

Self-service


Querona data modeling interface is fully web-based and designed for self-service activities. Business users, business analysts, and data scientists can easily find and query any data source needed. With Querona a company may build a central reporting data model. Now a business user can connect to Querona using Excel and retrieve data from the reporting model directly.


Data sources, tables or even columns may be tagged with business terms. With Querona it is easy to find any tables from any data sources that contain customer details. Querona users may collaborate and build a corporate data hub.

Cloud offloading


Querona integrates cloud data warehouses into the corporate network. Data from on-premise and cloud data sources may be easily uploaded to a data warehouse hosted in the cloud. Now offloading to Azure SQL Data Warehouse or HDInsight is simplified and some activities may be delegated to business users or data scientists.


Querona has a high-availability integration with Hadoop and Apache Spark using Zookeeper. Integration of a Hadoop cluster is safe and reliable.

Request a live demo


Tell us a bit about your challenge so we can tailor the demo accordingly.
Request a live demo