Executing Stored procedure in QlikView

In certain business environments all the complex business logic is implemented in a stored procedure.

This usually happens when the source system is a huge transactional database system and data warehouse is not available.

In such scenarios you have two choices

–     load all the tables in QlikView and recreate stored procedure logic

–     execute the stored proc and get the required data

Here we will discuss if you have to opt for the second choice.

Executing Stored procedure in QlikView

In QlikView executing stored proc is very simple, see below i am running a stored proc named SalesByCategory

which accepts two parameters CategoryName and OrderYear

StoredProc11

the output of this stored proc will be created as a table in QlikView which can be used as any other table in Qlikview

StoredProc12

You can execute multiple stored procedures and join the resulting tables as needed.

8 thoughts on “Executing Stored procedure in QlikView

  1. Hi. If I will opt. for the First choice ?

    • Chandraish Sinha says:

      UKD:
      If you will opt for the first choice then you will load all the required tables , create your data model by joining tables etc.
      and recreate the stored proc logic.
      Stored procs are used when logic is already implemented in the stored proc.
      It is your choice either to use stored proc or recreate it in QlikView.

  2. Can this be done with Oracle Stored Prodcedure.. using OUT sys_refcursor.. ??

  3. Can I rename a column with this method? Please help

  4. Hi
    i have given like
    SQL exec Store_proc_name ;

    but its giving error as syntax error or access violation.

    please help me to load stored procedure into qlikview from oracle db via odbc connection

    • Chandraish Sinha says:

      Please check if you have permission to execute the stored proc.

  5. Javier Frank says:

    Hi, i have the problem execute the stored procedure with oracle, this stored procedure have two parameter, one parameter is input and second parameter is output. In Qlikview i am using this sentence:

    Table1:
    Sql call Rehabilitacion.sp_help1(‘hola’);

    But it shows me the following error:

    wrong number or types of arguments in call to.

    Thanks for you help

Leave a Reply to varsha Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.