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.

       

      Thanks

      Shiv

        • 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

           

          BR,

          NB

          • 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.

             

            Thanks,

            Ritesh