Select Sifiso

Connect to SQL Server in QlikView

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

Leave a Comment

Your email address will not be published.