White Paper - Qlik Sense on Microsoft Azure SQL Data Warehouse
The purpose of the document is to provide a step-by-step guide of how to get Qlik Sense working with the Azure SQL Data Warehouse solution on the Azure platform.
Azure SQL DB:
General-purpose managed relational database service in Azure. This means Microsoft handles all patching and updating of the underlying infrastructure while you get to just use the database. It delivers dynamically scalable performance allowing you to scale database performance up/down and only pay for what you need. It shares a code base with Microsoft SQL Server and supports structures such as relational data, JSON, spatial, and XML.
Azure SQL DW:
Cloud-based managed data warehouse that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. Azure SQL DW is a key component of an end-to-end big data solution in the Azure cloud. Like with Azure SQL DB, Microsoft handles all patching and updating of the underlying infrastructure. It also delivers dynamically scalable performance allowing you to scale data warehouse performance up/down in minutes. In addition, you can independently scale compute and storage, and pause and resume the data warehouse to match the rhythms of your business.
Why Qlik Sense
Qlik Sense gives you data superpowers. Easily combine all your data sources, no matter how large, into a single view. Qlik’s Associative engine indexes every possible relationship in your data so you can gain immediate insights and explore in any direction your intuition takes you. Unlike query-based tools, there’s no pre-aggregated data and predefined queries to hold you back. That means you can ask new questions and create analytics without having to build new queries or wait for the experts.
Interactive analysis, without boundaries
Ask any question and quickly explore across all your data for insight, using global search and interactive selections. All analytics update instantly with each click, no matter how deep you go, furthering analysis or pivoting your thinking in new directions. There’s is no limit to exploration and no data left behind.
Simply smarter visualizations
Innovative visualizations put your data in the right context to answer any question. Explore the shape of data and pinpoint outliers. Use advanced analytics integration and geographic calculation to broaden insight. And it's fully interactive - easily pan, zoom, and make selections to find insights visually.
Create and explore on any device
Explore, create, and collaborate on any device, directly at the point of decision. Qlik Sense is built from the ground up with responsive mobile design and touch interaction. Build analytics apps once, and they’ll work everywhere, on desktop, tablet, or mobile devices.