Last Modified Date: 20 Jun 2019
- 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 keep the following two things in mind:
- 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.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials