Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Master II
Master II

Hi,

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

Thanks Deva

View solution in original post

15 Replies
ArnadoSandoval
Specialist II
Specialist II

Hi Yaman,

This video could help you: Qlikview EXECUTE SQL Stored PROC with Parameters in Qlikview by RFB 228

HTH

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
Anonymous
Not applicable
Author

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

ArnadoSandoval
Specialist II
Specialist II

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

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
devarasu07
Master II
Master II

Hi,

Check my previous reply in below thread. Thanks

Execute PL\SQL Procedure in QlikSense

ArnadoSandoval
Specialist II
Specialist II

Indeed Devarasu, we are giving Yamal the same solution.

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Thanks Devarasu

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

store * from student into....

devarasu07
Master II
Master II

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;

Anonymous
Not applicable
Author

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