How to use stored procedures in Tableau

0 votes
How to use stored procedures in Tableau?
Jun 10, 2019 in Tableau by sindhu
9,636 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!

For an in-depth explanation check out Tableau Training Course details.

answered Jun 10, 2019 by Cherukuri
• 33,030 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
1,949 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
36,350 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 ffdfd
• 5,550 points
2,934 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,560 points
6,894 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
9,933 views
+2 votes
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
1,617 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
• 33,030 points
3,860 views
0 votes
1 answer

How to install Tableau Desktop/Public in Windows?

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

answered Feb 28, 2019 in Tableau by Cherukuri
• 33,030 points
1,859 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP