topic Re: SQL Server with QlikView in QlikView

SQL Server with QlikView

mahendragaur — Wed, 25 Nov 2020 16:16:04 GMT

Hello Experts,

I have some tables stored at SQL Server and I want to use them as my data source. Please guide me how can I proceed to connect it to QlikView.

Thanks in Advance!!!

Re: SQL Server with QlikView

Anonymous — Mon, 27 Mar 2017 14:24:44 GMT

Hi Mahendra,

First of all, an ODBC/OLEDB connection is needed.

Then use the information mentioned here‌. Once the connection is created script like below

Tablename in QlikView:

Load *;

SQL Select .

from SQL table.

Whatever you write after SQL will be evaluated in QlikView and will be executed in SQL server.

Hope it helps.

Re: SQL Server with QlikView

vishsaggi — Mon, 27 Mar 2017 14:26:23 GMT

You have to create an ODBC Driver and add it to DNS if you have one just use that.

Give you connection string and pull the data. Eg:

ODBC CONNECT32 yourdatasourcename;

LOAD *;

SQL SELECT .....

FROM table1

INNER JOIN

table2 ....

WHERE .....

;

Something like this. Need more info for further help.

Re: SQL Server with QlikView

awhitfield — Mon, 27 Mar 2017 15:48:11 GMT

Hi,

check out:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Loading_data_from_databases.htm

Andy

Re: SQL Server with QlikView

mahendragaur — Tue, 28 Mar 2017 06:22:35 GMT

Hello Nagaraju,

Thanks for your response. How can I create ODBC driver and add it to DNS. I know this is basic question but I'm not aware of this.

Re: SQL Server with QlikView

Anil_Babu_Samineni — Tue, 28 Mar 2017 06:37:35 GMT

PFA and download and hit two times you will get it

Re: SQL Server with QlikView

ramasaisaksoft — Tue, 28 Mar 2017 07:27:02 GMT

Hi Mahendra,

Fetching data from any database into Qlikview we need different types of connectors

-->ODBC/OLEDB connection for RDBMS databases(Oracle,SQL server,My sql..etc)

-->Separate connectors for Sales Force,SAP,Hyperion Essbase..etc

Coming to your point you need a OLEDB/ODBC connector for your database.you need to install either Server or Client edition database software in your machine.

once it is installed you need to create a connection

windows button-->Control Panel-->Administrative Tools-->Data sources (ODBC)-->in USER DSN tab --> click on Add button

Create New database source-->select you database type-->and give your server and user credentials -->check the Test connection at the end.

so that your ODBC connection is created now

Now go to the Qlikview

open new QVfile-->Go to Edit script-->at the end of left hand side in script you can find

Connect Button click on that one and choose your database connection

now in your script you can find a new line code added for ODBC connection

after that click on Select button now you can choose the tables from that database click on OK and now your script will add that table code also.

if you feel you got solution for your issue,please close the thread by clicking "Correct Answer".

Re: SQL Server with QlikView

Miguel_Angel_Baeyens — Tue, 28 Mar 2017 07:49:04 GMT

Please don't attach any executable files here, first because it can be considered dangerous by some browser policies, second because they will become obsolete.

In this case, the way of creating user or system DSNs is not using that package but the ODBCAD32.exe file available in Windows

C:\Windows\SysWOW64\odbcad32.exe for 32 bit connections
C:\Windows\System32\odbcad32.exe for 64 bit connections

That package will allow you connect to several sources (drivers)

Re: SQL Server with QlikView

mahendragaur — Tue, 28 Mar 2017 08:17:21 GMT

Can you please mention the name of connector and also if possible explain with the help of screenshots how can I connect to SQL Server?

Re: SQL Server with QlikView

mahendragaur — Tue, 28 Mar 2017 08:32:22 GMT

I'm getting above error when trying to connect with SQL Server. What may be the reason for this?

Re: SQL Server with QlikView

Miguel_Angel_Baeyens — Tue, 28 Mar 2017 09:02:17 GMT

It seems that the driver is configured to connect to SQL Server using SSL, you will have to disable that or ask which server name and port you need to use in the driver.

On a separate note, I would not use Qlik's connectors especfically for SQL Server since they are built in the Windows operating system, more updated and if anything, you can download the most updated version, which matches with your server version here: SQL Server Drivers | Microsoft Docs

Re: SQL Server with QlikView

mahendragaur — Tue, 28 Mar 2017 09:15:39 GMT

As you said "It seems that the driver is configured to connect to SQL Server using SSL, you will have to disable that". How can I disable that?

Re: SQL Server with QlikView

Miguel_Angel_Baeyens — Tue, 28 Mar 2017 09:34:41 GMT

I should see the interface where the connection is created, sometimes you must specify SSL as a different checkbox, sometimes using certain ports implies the use of SSL. Without having it in front of me, or know which port should I use it's impossible to say.

Re: SQL Server with QlikView

mahendragaur — Tue, 28 Mar 2017 10:04:25 GMT

I'm using the correct port which is specified by my Admin. You can tell me where I should check for SSL connectivity.

Re: SQL Server with QlikView

Miguel_Angel_Baeyens — Tue, 28 Mar 2017 11:39:53 GMT

I suggest you to check the Advanced options of the DSN and check with your database administrator or IT team who can help you setting that up correctly. Again, not having the driver interface in front of me I cannot guess where that SSL property is