AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
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
Read More
Leave a Reply. |