2 Replies Latest reply on Jan 5, 2019 6:04 AM by Ritesh Bisht

    How to connect Store procedure from Tableau desktop

    Manoj Kumar

      Hi experts,


      Is it possible to connect stored procedure from tableau desktop.


      Kindly suggest me.




        • 1. Re: How to connect Store procedure from Tableau desktop
          Naveen B

          Hi Manoj ,


          You can connect to Stored procedure from Tableau Desktop


          Check the below link --> Once after you connect to data source --> you will find the stored procedures whatever available in you DB .


          Stored Procedures - Tableau


          Hope this helps.

          Plz mark this answer as correct or helpful to close the thread




          • 2. Re: How to connect Store procedure from Tableau desktop
            Ritesh Bisht

            stored procedure is a subroutine available to applications that access a relational database system. When you connect to a SAP Sybase ASE, Microsoft SQL Server, or Teradata database with Tableau, you can use a stored procedure to define the connection.

            For Oracle, you can use a table function to define the connection. Oracle table functions act similarly to stored procedures and are listed under Stored Procedures on the Data Source page.

            When you create a data source using one of these data types, available procedures are listed under Stored Procedures, as shown in the Microsoft SQL Server example:

            From the left pane, drag the procedure to the canvas or double-click one of the listed procedures. If parameters are available in the procedure, the Parameters dialog box automatically displays.

            Instead of entering a value, you can use an existing Tableau parameter, or create a new Tableau parameter for the value:

            If you then expose the Tableau parameter in the view, users are able to change the value of the parameter in the procedure interactively.