How to use stored procedures in Tableau?

0 votes
How to use stored procedures in Tableau?
Jun 10 in Tableau by sindhu
112 views

1 answer to this question.

0 votes

Hi Sindhu,

Stored procedures are used to write once run anywhere technique that allows programmers to use the same definition of code with different parameters.

Follow the below steps to use stored procedures in tableau,

1. Connect to the database (Ex: MYSQL)

2. Once you connect to the database, you can see a list of tables and stored procedures in the database.

3. Drag the stored procedure that needs to be used and drop it in the sheet.

4. A parameter dialog box opens, you can either manually enter or use or create tableau parameters to give values dynamically.

5. Click ok.

For more information, visit this page,

https://onlinehelp.tableau.com/current/pro/desktop/en-us/connect_basic_stored_procedures.htm

Hope it helps!

answered Jun 10 by Cherukuri
• 21,150 points

Related Questions In Tableau

0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sale ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
122 views
0 votes
6 answers

How to use COUNTIF in Tableau?

I'll give you a brief idea on ...READ MORE

answered Dec 10, 2018 in Tableau by Haider
6,977 views
0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by Atul
• 5,530 points
546 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,550 points
912 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,606 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
62 views
+2 votes
1 answer
0 votes
1 answer

how to use/access Json data in Tableau?

Hi Sindhu, 1. Double click on Json on ...READ MORE

answered Mar 19 in Tableau by Cherukuri
• 21,150 points
30 views
0 votes
1 answer

How to install Tableau Desktop/Public in Windows?

Hey, it is a simple and easy ...READ MORE

answered Feb 27 in Tableau by Cherukuri
• 21,150 points
77 views