Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yamananalytic
Contributor II

I have a problem while connecting to store procedure

Hi guys,

i would ask you that i have a question regarding a store procedure

Error :

Error.png

and my procedure is :

Help.png

1 Solution

Accepted Solutions
devarasu07
Honored Contributor II

Re: I have a problem while connecting to store procedure

Hi,

Can you help me to close this thread by marking correct. it might useful for others who is having similar issue.

Thanks Deva

15 Replies
tinaco110
Contributor III

Re: I have a problem while connecting to store procedure

yamananalytic
Contributor II

Re: I have a problem while connecting to store procedure

Thanks Arnaldo,

i saw the video but actually the problem is not solved because i could fetch the data by executing Stored Procedure but i could not see where are the data ??

ice_screenshot_20170820-040806.png

tinaco110
Contributor III

Re: I have a problem while connecting to store procedure

Hi Yamal,

I am uploading two screenshots; I have an empty MS SQL Server Express database, its table: Users contains 3 records, so I used it to create the store procedure that illustrate how Qlik Sense load data from MS Sql Server Stored Procedures:

This is my data connection; I am using a SYSTEM DSN based on the ODBC Data Source Administrator (32-bits)

DC-ODBC-MS-SQL-Server.png

Now this is the script; note: I loaded the User table just to get Qlik Sense to tell me how to reach the object (table, procedure or view) at the database.

You should have a LIB CONNECT TO ... ; very similar to the one shown below.

The main difference is with the SQL EXECUTE, here I had to spell the database name: "ReportServer$SQLEXPRESS2008R2" followed by the name of the stored procedure: dbo.List_Users

DC-ODBC-Stored-Procedure-Script.png

NOTE:

My test was using: StandardReload=0;

My second test without StandardReload, worked fine as well.

HTH

devarasu07
Honored Contributor II

Re: I have a problem while connecting to store procedure

Hi,

Check my previous reply in below thread. Thanks

Execute PL\SQL Procedure in QlikSense

tinaco110
Contributor III

Re: I have a problem while connecting to store procedure

Indeed Devarasu, we are giving Yamal the same solution.

yamananalytic
Contributor II

Re: I have a problem while connecting to store procedure

Thank you all for your response but i use user dsn to connect with sqlserver

i uploaded these screen shot in order

1.png5.png3.png

yamananalytic
Contributor II

Re: I have a problem while connecting to store procedure

Thanks Devarasu

i opened your file but could not understand what this line means?

store * from student into....

devarasu07
Honored Contributor II

Re: I have a problem while connecting to store procedure

Hi,

Your DSN name not found. refer to the attachment for the DSN and import stored procedure from SQL server. Thanks

from your screen shot i can see one more DSN call "sqlserver" can you try with that.

LIB CONNECT TO 'sqlserver';

Students:

load *;

SQL exec dbo.Students;

yamananalytic
Contributor II

Re: I have a problem while connecting to store procedure

Hi bro,

as you said i used sqlserver DSN and i rename it to sqlserver1

now the data has been fetched and true result is 5 records

but where can i find the data to  start make some visualization

22.png