About Tableau Prep Conductor
Tableau Prep Conductor enables you to seamlessly publish flows from Tableau Prep Builder to Tableau Server or Tableau Online, then leverage the scheduling and tracking functionality available in those applications to run your flows automatically to update the flow output. Tableau Prep Conductor is part of the Tableau Data Management Add-on introduced in Tableau Server version 2019.1 and must be enabled for the features to be available.
Publishing flows is similar to publishing data sources and workbooks with Tableau Desktop. You can package files with the flow or specify a direct connection to data sources to update the flow input as data changes. If your flow connects to databases, specify the authentication type and set credentials to access the data.
You can also publish a flow to share it with others. For example, publish an incomplete flow to Tableau Server or Tableau Online and then download it to another computer to continue working on it. Create a flow with only Input steps (that are properly configured) and share it with co-workers who can then download the flow to their computers and create and publish their own flows.
Flows can only be run in Tableau Server or Tableau Online if the flow includes output steps and the flow has no errors or incompatible features. For more information about publishing a flow, see Publish a Flow to Tableau Server or Tableau Online(Link opens in a new window). For more information about incompatibility, see Version Compatibility with Tableau Prep(Link opens in a new window).
Keeping track of the health of your flows is easy. With Tableau Prep Conductor, you can:
View and monitor the details about your flow, including recent activity in the Content pages.
View the results of the flow runs and any errors in the Run History tab.
Use Administrative Views to monitor server and site activity including a new view that tracks flow performance history.
View detailed alerts for failed flow runs.
Set up email notification alerts to send emails to flow owners notifying them when the flow failed to run and why.
For more information about setting up alerts, see Monitor Flow Health and Performance(Link opens in a new window).
If a flow fails to run due to connectivity errors, you can fix the error right in Tableau Server or Tableau Online by editing the connection. If a flow fails to run due to errors in one or more of the flow steps, such as a calculation that isn’t valid, simply download the flow to Tableau Prep Builder, fix the problems and then republish the flow to Tableau Server or Tableau Online to pick up where you left off.
Enabling Tableau Prep Conductor
Tableau Prep Conductor is available with the Data Management Add-on and can be installed with Tableau Server or Tableau Online or added to an existing installation of Tableau Server or Tableau Online version 2019.1 or later. For more information about how to install and enable Tableau Prep Conductor, see Enable and Configure Tableau Prep Conductor on Tableau Server(Link opens in a new window) or Enable Tableau Prep Conductor on your Tableau Online Site(Link opens in a new window).
Tableau Prep Conductor is designed to work with Tableau Prep Builder version 2019.1.2 and later. You must install or upgrade Tableau Prep Builder to use version 2019.1.2 or later to be able to publish flows to Tableau Server or Tableau Online. For information about how to install Tableau Prep Builder, see Install Tableau Desktop or Tableau Prep Builder from the User Interface(Link opens in a new window).
Getting to know the flow workspace
After you publish your flow you can schedule tasks in Tableau Server or Tableau Online to automatically run your flow on a regular basis to keep your output data fresh.
Tableau Prep Conductor leverages much of the same functionality for managing flows that you might see when managing workbooks or data sources from Tableau Desktop in Tableau Server or Tableau Online. For example, just like extract refreshes, scheduled flow tasks and on-demand flow runs are queued as background tasks. But when it comes to working with flows, there are a few differences.
Flow Overview page
The flow Overview page is the main landing page where you can view data about your flow and schedule, monitor and maintain running the flow.
Open the flow Overview page by clicking on a flow in your list. You can navigate there from Content > Explore > All Flows or by opening the project that contains your flows.
The header lists the name of the flow, the flow owner and the date that the flow was last modified.
Add a flow to your favorites, or from the More actionsmenu you can also download the flow, set permissions, change the flow owner, restore previous flow versions, and more.
View and edit the flow description and set tags to help others find the flows they are looking for.
View the output steps for a flow along with the status of the last update, any schedule the output is assigned to, and any errors from the last flow run. You can also click the Runbutton to run all output steps or individual output steps on-demand.
If the flow has errors, the flow run will fail. Connectivity errors can be resolved directly in Tableau Server or Tableau Online by navigating to the Connections tab for the flow and editing the input connections. To resolve any other flow errors, from the More actionsmenu select Download to download and open the flow in Tableau Prep Builder. Edit the flow then republish it and try running the flow again.
After a flow has run successfully, outputs that are data sources become links that you can click to open the Data Source page to view more information about the data source or edit the flow input connection.
In the Schedule field, view the scheduled tasks that the output step is assigned to. A flow output can be assigned to one or more tasks.
If no schedule has been assigned yet, click Create new task to add the output step to a schedule. To immediately run the flow to update a specific output step, click the Runbutton on the left-hand side of the row.
View an image of the flow.
Flow Connections page
View both the input and output locations for a flow, connection types, authentication settings, input and output steps and any connectivity errors. You can set authentication settings when publishing a flow. For more information, see Publish a flow(Link opens in a new window).
For database input types, click the More actions menu for an input connection to edit the connection and change the server name, port, user name and password.
Flow Scheduled Tasks page
View any schedules that the flow is assigned to and the outputs that are included in those schedules. Click the schedule link at the top of the task card to open the Schedules page and see a list of flows that are assigned to that schedule. For more information about assigning flows to a schedule, see Schedule a Flow Task(Link opens in a new window).
You can also add new tasks or manage existing ones from this page. To take action on an existing task, select the check box on a task card then click the Actions drop-down menu to run, edit, or delete the task.
In Tableau Server, if the flow fails to run after a configured number of consecutive attempts, the flow is automatically suspended. In Tableau Online, if a flow task fails to run after 5 consecutive attempts, the flow is automatically suspended.
You can see that status on the Overview tab as well as this tab. You can resume suspended tasks from this menu.
For information about how to set the threshold for suspended flow tasks, see Step 5: Optional Server Configurations(Link opens in a new window). For more information about suspended flow tasks, see View and resolve errors.
On the Schedules page, you can view the flows assigned to a schedule and the details about the flow runs. You can run the schedule on-demand and run all flows assigned to it. You can also select one or more flows, then use the Actions menu to change the flow schedule or priority, delete selected flows from the schedule or resume suspended flows.
For information about how to set up a schedule, see Step 3: Create Schedules for Flow Tasks(Link opens in a new window).
Flow Run History
See, search, and sort through a list of historical runs for a flow. This page also includes details about the flow run such as run type, duration and number of rows that were generated.
If the flow output has an error, hover over the error to view the messages. If applicable, click the Go to Connections link in the error message to navigate to the Connections page to fix connectivity errors. If shown, click the Download the Flow link to download the flow to fix flow errors in Tableau Prep Builder, then republish the flow to continue to manage it using Tableau Prep Conductor.
Note: The run history for a flow will persist unless the flow is deleted.
Flow Revision History
If you need to revert a flow to a previous version, from the More actions menu for the flow, select Revision History. On the Revision History dialog, select the flow version from the list that you want to revert to.
Server Administrators can activate Data Management Add-on license keys.
Server administrators can enable Tableau Prep Conductor.