![]() If a stored procedure has output parameters, Tableau filters out the stored procedure. If a stored procedure returns more than one result set, Tableau reads the first one and ignores the rest. If you use stored procedures to define a data source for Tableau, keep the following in mind: They are represented in a single logical table in the logical layer, and don't allow opening the Join/Union canvas (physical layer). Stored procedures don't support federation, relating, or joining. If you then expose the Tableau parameter in the view, users are able to change the value of the parameter in the procedure interactively. Instead of entering a value, you can use an existing Tableau parameter, or create a new Tableau parameter for the value: If parameters are available in the procedure, the Parameters dialog box automatically displays. ![]() ![]() 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:įrom the left pane, drag the procedure to the canvas or double-click one of the listed procedures. Oracle table functions act similarly to stored procedures and are listed under Stored Procedures on the Data Source page. 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.įor Oracle, you can use a table function to define the connection. A stored procedure is a subroutine available to applications that access a relational database system. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |