Learn How to use subscriptions to deliver reports via e-mail tableau
Using subscriptions to deliver reports via e-mail
The Subscriptions feature is considered to be one among the most important features in Tableau’s interactive data visualization product. It is by far the easiest way to ensure that you review the most critical and valuable information on a regular basis. The information is shared via email once you have subscribed to a dashboard.
In Tableau, you can easily subscribe to reports that you need on a recurring basis. Subscribed dashboards/sheets will be delivered to your inbox in the form of a PNG image linked to jump directly to the interactive version of the dashboard.
Busy managers sometimes like to have their reports delivered. Tableau supports this through subscriptions. The user will be notified via e-mail when the report is updated. These schedules are defined by a server administrator, allowing administrators to ensure that any additional server load is balanced appropriately. Subscription e-mails also contains links to their live and interactive counterparts located on the server.
To subscribe to a report, a user follows these steps:
- Log into tableau server.
- Open the view or dashboard to which you wish to subscribe, or subscribe to an entire workbook by opening a single view or dashboard belonging to that workbook.
- Click the subscribe icon on the top right corner of the dashboard. This is represented by the small e-mail icon on the left side of the download link.
- This causes the subscribe dialog box to appear.
Select or enter the following values:
- To – verify the e-mail address associated with your account.
- Subject – enter the desired subject for the subscription e-mail.
- Schedule – select the schedule you’d like your snapshots to send on. These schedules are created and maintained by tableau server administrators.
- Content – choose whether to subscribe to the current sheet only or all sheets in the workbook.
- Click on subscribe to finish.
Requirements
For TABLEAU SERVER users to receive subscriptions, the following things need to be in place:
- Email settings configuration: As the system administrator, you can configure the basic SMTP server settings for subscriptions on the Alerts and Subscriptions tab in the Configuration dialog box, which is available during Setup. This is the “from account” Tableau Server uses to email subscriptions to server users.
- Credentials embedded or not required: From Tableau Server’s perspective, a subscription includes a workbook, data, and a schedule. To deliver the data piece, Tableau Server needs to be able to access the data with no end-user involvement. This can be accomplished by using either a workbook with embedded database credentials, a Tableau Server data source, or by using data that doesn’t require credentials, such as a file that’s included with the workbook at publish time. Workbooks that prompt for credentials for live database connections can’t be subscribed to.
- User requirements: If a user can see a view or workbook on Tableau Server and it has the subscription icon () in the upper right corner, he or she can SUBSCRIBE TO IT. The ability to see a view or workbook is controlled by the View permission. A user must also have an email address. If Tableau Server doesn’t already have an email address for a subscribing user, it prompts for one at subscription sign-up time. Users can change their delivery options, unsubscribe, or update their email address on their USER PREFERENCES PAGE.
- Trusted authentication: If you are using a restricted ticket (the default) to render an embedded view, subscriptions are disabled.
How To Configure and Subscribe to Tableau Views & Workbooks
Step 1: Configure the Simple Mail Transfer Protocol (SMTP) server in Tableau from the Configuration Alerts and Subscriptions Section. Restart the server once the configuration is done.
The following screenshot shows a configuration for Gmail.
The following screenshot shows a configuration for Gmail.
.png)
Step 2: Login to the Tableau Server and Create a New Schedule (Admin > Schedules >New).
.png)
Step 3: Open the workbook you wish to subscribe. Click on the subscribe icon (email icon just beside the download link on the top left of the screen).
Select the desired schedule from the drop down menu.
The content will give you two options:
Select the desired schedule from the drop down menu.
The content will give you two options:
- current sheet
- entire workbook.
Select the one you need to view on a regular basis. You can view the option from the image below:
.png)
Administrators subscription management
Allowing subscriptions on tableau server requires a few additional steps to be performed by an administrator. You can change these in the tableau server configuration to enable subscriptions using the following steps:
- Log into the tableau server machine, stop the server, and open the tableau configuration utility.
- Click the e-mail alerts/subscriptions tab.
- Check the enable email subscriptions.
- In the SMTP server section, ensure that an SMTP server and port is specified. Enter a username and password if required by your SMTP server.
- Enter a send e-mail from an address. This e-mail will send out all subscription e-mails.
- Enter your tableau server URL
- Click ok to finish.
- Start the server.
Visit For More Information: How to use subscriptions to deliver reports via e-mail tableau
Comments
Post a Comment