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.

window of 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.

select database

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

data link

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.

test connection

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

    Confirm box
     
  • Then click on the OK button.

    ok box

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.

SQL server

  • Then this window will be opened.

    edit

Step 7: Create select statement

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

select statement

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

    create select

Step 8: Code of edit script

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

reloading


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..

Script execution

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:

    main sheet

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

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.