Connect to SQL Server in QlikView

By | June 12, 2016

As business intelligence solution developers, we should not limit ourselves to using tools from specific vendors instead we should try and explore as many data visualization tools as we possibly can. In this article, we illustrate using screenshots on how you can connect to SQL Server from QlikView to visualize SQL Server data.

How to connect SQL Server from QlikView

Create new document

QlikviewNewDoc

Close “Getting Started Wizard”

QlikviewNewDoc1

Edit Script

QlikviewNewDoc2

Connect to an OLE DB source

QlikviewNewDoc3

Choose SQL Server provider and click Next to configure the connection

QlikviewNewDoc4

Once you are finished configuring your SQL Server connection, an OLEDB CONNECT TO command will be added into your script as shown below.

QlikviewNewDoc6

How to load SQL Server into QlikView

Click Select… button to configure your select statement.

QlikviewNewDoc10

Choose your columns. In our example, we have chosen data from our fictitious FruitSales view.

QlikviewNewDoc7

When you are done configuring a Select statement, it will be added into your script page as shown below:

QlikviewNewDoc9

Reload your document to refresh dataset

QlikviewNewDoc8

My first-ever QlikView report

Once you have configured your connection and dataset, you can create a report based off your FruitSales dataset as shown below:

QlikviewNewDoc11

Sifiso Ndlovu (55 Posts)


Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.