Chapter 1. Getting Started with the Data

In this chapter, we will cover the basic tasks related with extracting data into a Qlik Sense application:

• Extracting data from databases and data files
• Extracting data from Web Files
• Activating the Legacy Mode in Qlik Sense^? desktop
• Extracting data from custom databases
• Invoking help while in the data load editor or the expression editor
• Previewing data in the Data model viewer
• Creating a Master Library from the Data model viewer
• Using a Master Library in the Edit mode

Introduction

Data is the core aspect of any Business Intelligence application. It provides information that helps organizations to make decisions.

A Qlik Sense application is based on the data extracted from various sources, such as relational databases, CRM systems, ERP systems, and data files.

This chapter introduces the user to various methods of extracting data into a Qlik Sense application effectively. It is assumed that the reader is already acquainted with the concepts of ODBC, OLEDB, and relational databases. The chapter also provides an essential recipe for fetching the data into Qlik Sense from a SAP system. The SAP connector can be downloaded from the Qlik website and installed before working on the recipe. You need to acquire a valid license enabler file beforehand, in order to download the SAP connector.

The later part of the chapter focuses on a few recipes regarding the creation of a library and content.