QUICK FACTS

HEAD OFFICE

Kwitnącego Sadu
8
Warsaw 02-202
Poland

COUNTRIES SUPPORTED

Global

LANGUAGES OFFERED

English

category

CATEGORIES

Big Data, Analytics, Big Data Analytics, Data integration, Data Aggregation

INDUSTRIES

Any Industry

PRICING

Subscription

1000 EUR / power user / year

TYPE OF CUSTOMERS

For profit, Public

SIZE OF CUSTOMERS

Large, Global Enterprise, Small, Medium

 
Founders:
 
Year founded:01/01/2015
 
Awards won:1
Vendor size:small
 

Overview

Querona mission is simplification of data management and empowerment of business users and data scientists in data management activities.

In our vision, all enterprise data should be accessible from a single place. Users should have freedom to choose between real-time and cached data. Data should be available for consumption from any client tool. Queries should be accelerated by Big Data engines and support in-memory processing.

A traditional solution for a single view of all data is an Enterprise Data Warehouse, but EDW maintenance lacks agility when new data sources must be included or data marts modified when new reports are requested.

Querona solves the limitations by using Data Virtualization to set up a Logical Data Warehouse (LDW). Technically Querona is byte-wire compatible with SQL Server, accepts T-SQL, translates queries and executes queries on ~100 types of data sources (relational, non-relational, CRMs, marketing platforms, no-SQL). As a result, all corporate data sources may be connected to Querona and will be visible as virtual databases on a simulated SQL Server instance. Querona supports a full Transact-SQL dialect and translate queries on the fly. From the user perspective, Querona will look like a data warehousing server with all data already loaded.

The data cleansing and presentation layers in a Querona LDW is realized by creating views that may combine data from multiple sources on the fly. Those views may be virtual data marts, could be cached in the cloud or on a bundled Apache Spark engine. 

 

Less

THE 3 KEY BENEFITS

  • 01 Self-service data management that enables split of data management responsibilities between IT and data analysts or d...
  • 02 Instant customer 360-degree view by creating views that are augmenting a customer database with all customer relevant...
  • 03 High performance and simplified data warehousing by combining real-time analytics (pass-through) with caching on Apac...

THE 3 KEY BENEFITS

  • 01 Self-service data management that enables split of data management responsibilities between IT and data analysts or data scientists. A data science team may build their analytics data sandbox by simply picking the data they need. Data Virtualization decreases the time and effort of data management activities by 40%.
  • 02 Instant customer 360-degree view by creating views that are augmenting a customer database with all customer relevant information from other systems in the enterprise. CRM data may be combined with ERP data, relational databases or marketing platforms to offer a single customer view. The setup does not require creating additional tables and ETL processes that would load combined information into an EDW. Just a joined view created with our designer solves the need.
  • 03 High performance and simplified data warehousing by combining real-time analytics (pass-through) with caching on Apache Spark or on many other database engines (SQL Server, SAP HANA, Amazon RedShift, Oracle, IBM DB2 and others). Decrease the cost of data warehousing by using open source Big Data engines or offloading query execution to the cloud.
Less

PRODUCT FEATURES

  • Instant data warehousing on Apache Spark

    Querona is bundled with an Apache Spark engine, the most popular Big Data engine. 5 minutes after installation, Spark is exposed as a Data Lake and all corporate data may be loaded and cached. Spark changes into an efficient data warehouse, compatible with any BI tool (accessible as a virtual SQL Server), with Windows Integrated Authentication.

  • On-the-fly data consolidation

    Data from multiple sources may be joined on the fly. The data model from Business Intelligence tools may be centralized so that a customer view that augments a customer from another system is easy to design and executed in real-time on Querona.

  • Universal data security

    Querona transparently applies security on top of all connected data sources. Around 50 types of access rights may be applied on all levels. Role based row access security and dynamic data masking is supported on all data sources. Additionally all sensitive data that is cached in the cloud may be transparently pseudo-anonymized on-the-fly which means that personal information is never stored in clear text form.





In order to contact Querona, you have to be a registered Datafloq user

Register here or Login








REQUEST SUCCESSFULLY SENT!