How to use stored procedures in Tableau?

0 votes
How to use stored procedures in Tableau?
Jun 10, 2019 in Tableau by sindhu
1,508 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, 2019 by Cherukuri
• 32,460 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_sal ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,820 points
383 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
15,318 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
1,202 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
2,404 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
3,981 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
250 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, 2019 in Tableau by Cherukuri
• 32,460 points
589 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, 2019 in Tableau by Cherukuri
• 32,460 points
444 views