How to use stored procedures in Tableau?

0 votes
How to use stored procedures in Tableau?
Jun 10 in Tableau by sindhu
179 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
• 25,900 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
139 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
7,824 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
608 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
1,032 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,805 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
77 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
• 25,900 points
35 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
• 25,900 points
103 views