topic Re: Load Store Procedure In qlik Sense in Connectivity & Data Prep

Load Store Procedure In qlik Sense

Tue, 13 Dec 2016 11:36:51 GMT

hi to all.

I am new to SQL and Qlik Sense. I want make a dashboard by 5 Store Procedure by qlik sense.I cant load SP in qlik sense.just I know SP's name(rptSP_SaleDashboard_CustomerType) and parameters(@scuCompanyID=121////@scuCmpyID=66/////@UserID=181)

plz help me to done this task.

plz clearly explain how to i must write script by this information.

Re: Load Store Procedure In qlik Sense

shraddha_g — Tue, 13 Dec 2016 12:18:44 GMT

Try

Connect to database and then

SQL Exec StoredProcedureName(Parameter1, Parameter2,...etc)

Re: Load Store Procedure In qlik Sense

Tue, 13 Dec 2016 12:31:23 GMT

hi shraddha.tanks for your response. I do your guide like follow pic

but i see this window

Re: Load Store Procedure In qlik Sense

Tue, 13 Dec 2016 12:45:20 GMT

where i must insert my database name?

Re: Load Store Procedure In qlik Sense

Tue, 13 Dec 2016 12:51:50 GMT

dear shraddha.g can you share your script?

Re: Load Store Procedure In qlik Sense

rittermd — Tue, 13 Dec 2016 13:41:47 GMT

This is an example of what I am doing in one of my apps. I run the SP 3 times with different parameters.

Make sure that your data connection to SQL is working.

LIB CONNECT TO 'Prod_HHMapping (win-ivtiroi5taf_mritter)';

Functional_BM_CM:

SQL

exec dbo.batch_XML_CFORatings 1, '4/01/2016','4/30/2016','M','STR';

SQL

exec dbo.batch_XML_CFORatings 1, '4/01/2016','4/30/2016','S','STR';

SQL

exec dbo.batch_XML_CFORatings 1, '4/01/2016','4/30/2016','C','STR';

Re: Load Store Procedure In qlik Sense

shraddha_g — Wed, 14 Dec 2016 05:38:13 GMT

have you created database connection?

Re: Load Store Procedure In qlik Sense

Wed, 14 Dec 2016 06:03:29 GMT

No.I dont khnow anything about qlik.i want connect to 5 sp.plz explain for me step by step.tanks

Re: Load Store Procedure In qlik Sense

Wed, 14 Dec 2016 06:06:54 GMT

tanks Ritter. plz explain for me what is 'Prod_HHMapping (win-ivtiroi5taf_mritter)' and Functional_BM_CM? which one is server name and which one is database name?

Re: Load Store Procedure In qlik Sense

shraddha_g — Wed, 14 Dec 2016 06:34:00 GMT

Create OBDC connection to your Database in ODBC Data Source (64 Bit) - >System DSN of your Server

In load editor,On right side pane there is a option called Create Connection.

Select ODBC - > Choose Connection from List of ODBC Data Source as created previously. -> Provide Username Password - > Test Connection -> If Success then Give name for Connection and Click on Apply.

Insert

In Mark's Example Prod_HHMapping (win-ivtiroi5taf_mritter) is name of Database connection.

After that

to execute Stored procedure,

SQL

exec StoredProcedurename Parameter1,Parameter2,Parameter3 ...Etc

Re: Load Store Procedure In qlik Sense

Wed, 14 Dec 2016 06:53:30 GMT

I do this job. but it give me Connector reply error.

Re: Load Store Procedure In qlik Sense

shraddha_g — Wed, 14 Dec 2016 06:59:42 GMT

Connection is created successfully?

Are you able to fetch a table from database?

Before Executing a SP try to fetch a simple table to check whether your connection is successfully established with database

Re: Load Store Procedure In qlik Sense

Wed, 14 Dec 2016 07:02:35 GMT

i think connection is created successfully because i can insert tables by insert data.pls help me.i must do this tomarrow...

Re: Load Store Procedure In qlik Sense

shraddha_g — Wed, 14 Dec 2016 07:04:54 GMT

what script you have used for SP?

Can you take screenshot?

Re: Load Store Procedure In qlik Sense

Wed, 14 Dec 2016 07:12:11 GMT

188.75.73.74 is my server addres and MabnaERP is mu database name and rptSP_SaleDashboard_DailySale is my sp name and 121 and 66 and 181 is my parameters

Re: Load Store Procedure In qlik Sense

shraddha_g — Wed, 14 Dec 2016 07:54:20 GMT

Remove Load * and try Load Fieldname (Try with 1 fieldname)