Last Modified Date: 25 May 2018
- Tableau Desktop
- It is currently not possible to use a Stored Procedure from an Oracle datasource in Tableau Desktop, but a Table Function can be used instead of a Stored Procedure.
- For a Table Function to be displayed under the 'stored procedures' section in Tableau Desktop:
- the Oracle user whose credentials are being used to connect must also have permissions to access the Table Function,
- the function must not be created in the SYS schema.
CauseA stored procedure does not return data in a format compatible with Tableau, where a Table Function does. Oracle users must be given permission to Table Functions just like to regular databases.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials