Connectivity Of SQL In QlikView Application

Introduction

SQL connectivity is more important to access data in wide applications. It provides the best solution for data access in a class. It enables the development of high performance applications in various widely applications.

Use the following procedure to create a sample of connectivity of SQL Server.

Step 1: Open the QlikView application

It is the first step, in this step you need to open the QlikView application then go to File-> New then this window will be opened.

After clicking New option

Step 2: Open Edit Script

The second step is to open the edit script window from:

File-> Edit Script.

Then this window will be opened.

window

Step 3: Select Database

The third step is to select the database from the data tab and click on the Connect Button.

Step 4: Data link property window: In this window we select the SQL Server and click on the Next Button.

Step 5: Connection tab

In the connection tab, you enter the server name and user name and password and select the database from your server and click on Test Connection.

Then you find that the test connection has succeeded and click on the OK button.
Then click on the OK button.

Step 6: SQL Server login

Then they require a SQL Server login so you enter a valid login id and password and click on the OK button.

Then this window will be opened.

Step 7: Create select statement

When we click on the Select button on the data tab then this window will be opened.

Then this window will be opened and click on the OK button.

Step 8: Code of edit script

After login to the SQL Server, the edit script window will be opened and reload it.

Step 9: Save QlikView file: After reloading the edit script, the next step is to save the QlikView file and click on the Save button.

save file

Step 10: Script execution progress

Then the script execution progress window will be opened and requires a login Id and password and click on the OK button..

Step 11: Sheet property Window

After this process, the sheet property window will be opened. If you want to add a field then select a field from the available fields and click on the OK button.

Then this window will be opened:

Step 12: Final Window: Then it shows the following final window:

Summary

This article describes how to connect to SQL Server in a QlikView application and also introduces why SQL Server connectivity is important for widely applications.