Load Store Procedure In qlik Sense

[#1]

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.

[shraddha_g]

Try

Connect to database and then

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

[#3]

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

but i see this window

[#4]

where i must insert my database name?

[#5]

dear shraddha.g can you share your script?

[rittermd]

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';

[shraddha_g]

have you created database connection?

[#8]

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

[#9]

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?

[shraddha_g]

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