How to integrate Elastic Search in Microsoft Azure SQL Data Warehouse

Discover how to integrate Elastic Search and Microsoft Azure SQL Data Warehouse and instantly get access to your data.

WITH PIPES OR PIPES PROFESSIONAL
How to integrate Elastic Search in Microsoft Azure SQL Data Warehouse with Pipes
WITH THE LOGICAL DATA WAREHOUSE
How to integrate Elastic Search in Microsoft Azure SQL Data Warehouse with Logical Data Warehouse


About Elastic Search

The cloud solution Elastic Search provides companies a tool for data management and analysis. Users can process, anylize and visualize their data using the open-source Elastic Stack. In addition, Elastic provides a range of security and monitoring tools, as well as web hosting for websites, data packages, and web shops.

About Microsoft Azure SQL Data Warehouse

Microsoft Azure is a leading cloud computing infrastructure and platform created by Microsoft for building, managing, and deploying services and applications through Microsoft-managed global  data centers. The offering of Microsoft Azure covers PaaS, SaaS and IaaS services and supports many different frameworks, tools, and programming languages, including third-party and Microsoft-specific systems and softwares. The SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to run complex queries across large sets of data.

What is Data Virtuality?

Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to Elastic Search, Microsoft Azure SQL Data Warehouse 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.