This documentation describes a release under development. Documentation for the latest release, 3.6.2, can be found here.

Tableau Export¶

The Export job performs exports using either the Tableau Vizql API (PDF exports) or the Tableau REST API (CSV, XLSX exports), both of which support user impersonation.

Beginning in 2.7.8, any new jobs that are created to generate and email reports should use the Export job. To avoid breaking existing jobs with the new release, the Tableau Export job remains in Mitto, though it should be considered deprecated.

The Export job is a single job that combines the functionality offered by the Vizql Export and REST Export jobs.

You can learn more from the technical documentation here: Mitto Export Job

Create a Tableau Export Job¶

To create a Tableau Export job:

Click the +ADD JOB button in Mitto
Select Generic Job
Give the job a name like [Tableau Export] Sales Data
Choose export from the TYPE dropdown menu
Paste the following configuration into the CONFIG editor:

Example CSV Export

{
    /* Tableau server credentials (named credentials supported) */
    "credentials": {
        "username": "<username>"
        "password": "<password>"
    },
    /* Tableau server configuration */
    "server": {
        "server": "https://tableau.zuar.com",
        "site": "",
        "user_id_to_impersonate": "5cf3542a-0c46-42fb-b6a5-27a96e41054a",
    },
    "export": {
        "full": true,
        "name": "example-csv",
        "type": "csv",
        "view_filters": {
            "State": ["Louisiana", "Texas"],
            "Category": ["Office Supplies", "Furniture"]
        },
        "view": "Overview",
        "workbook": "Superstore"
    }
}

The above configuration will export all views in the Superstore workbook as csv files and place all files in a single ZIP archive. The export will be saved in /var/mitto/data/example-csv.zip.

To export just the Overview view, change full to false. The export will be saved as /var/mitto/data/example-csv.csv.

For more examples, please visit the technical documenation here!

Tableau Subscription¶

A Tableau subscriptions job emulates the subscription functionality inside of Tableau. It allows user to configure custom subscriptions on a schedule that can send information from a dashboard to a data consumer via email. This is all configurable through a Mitto job.

You can learn more from the technical documentation here: Mitto Subscription Job

Create a Tableau Subscription Job¶

A Subscription Job’s configuration comprises three sections: subscriptions, mail, and tableau. The subscriptions and mail sections work the same, no matter the type of report being exported. The tableau section section contains Tableau server credentials as well as defaults that are used for export jobs. Values provided by subscriptions always override default values that may be present in the tableau section.

To create a Tableau Subscriptions job:

Click the +ADD JOB button in Mitto
Select Generic Job
Give the job a name like [Tableau Subscription] Sales Data
Choose subscriptions from the TYPE dropdown menu
Paste the following configuration into the CONFIG editor:

{
    "mail": {
        "server": "smtp.zuar.com",
        "port": 25,
        "require_tls":  true,
        "credentials": "zuar-smtp-creds",
        "mail_from": "operations@zuar.com",
        "text": "email body text",
        "attachments": []
    },
    "subscriptions": {
        "subscriptions_input": {
            "dbo": "postgresql://localhost/analytics",
            "schema_name": "public",
            "table_name": "subscriptions"
        },
        "subscription_status_input": {
            "dbo": "postgresql://localhost/mitto",
            "schema_name": "public",
            "table_name": "subscription_status"
        }
    },
    "tableau": {
        "credentials": "zuar-tableau-creds",
        "server": {
            "server": "https://tableau.zuar.com",
            "site": ""
        }
    }
}

For more information about how to create a subscription table, what the key value pairs mean, and more sophisticated configurations, please review the technical documentation here!