Mail Scheduler - Tableau Server Mail Schedculer for Windows

MailScheduler One-Click Installer Guide

Install MailScheduler on Windows with a single click

The following guide provides extra context to the One-Click Installation Wizard for MailScheduler, getting you on the way with advanced Email based reports as soon as possible!

Prerequisite

There are a few prerequisites and things you’ll need before the installation:

  • A web domain, for example, <https://extension.company.com> (create a DNS entry) which points to the host of MailScheduler.
  • SSL certificates for the above domain (the installation requires the domain’s `.crt` and private `.key` file, or a `.pfx` file).
  • Server Resources: 4 vCPU, 8Gb, 50Gb application disk space, 100Mbps or 1Gbps network-interface
  • Firewall rules permit access on the port the application will run on. Both internal, external, network and server-firewall.
  • SMTP setting which the application can use to send emails.

Please note that Tableau requires extensions to be running on HTTPS/SSL connection and therefore required!

Pre-installation Checklist

Before starting the installation process, the following items should be collected and stored in a way they can be accessed during installation.

The executable and license file can be downloaded from the Apps for Tableau portal (https://my-appsfortableau.infotopics.com).

A HTTPS webdomain is required, and in turn requires a SSL certificate. Both the .key and .crt or PFX files are required in the installation process.

The last requirement is a running database that will function as a repository database for MailScheduler. This is a MySQL (min 5.7), SQL Server (min 2016) or PostgreSQL database.

We require temporary internet access during the installation procedure.

The Microsoft Visual C++ Redistributable software package needs to be installed before starting the installation.

Requirements:

  1. One-Click installer executable
  2. MailScheduler License
  3. SSL Certificates (.crt and .key)
  4. Credentials to a running database
  5. Temporary internet access
  6. Microsoft Visual C++ Redistributable

Installation Steps

The installation wizard for MailScheduler consists of several steps guiding you through the installation process. For further details, please follow the descriptions below.

MailScheduler License

When starting the installation process, the first step is to provide the subscription license downloaded from the your personal download page in our Apps for Tableau Portal. Either click the upload area to find the license file in your storage, or drag and drop the file directly into the installer.

Database Setup

Currently, the following databases are able to serve as a repository database for MailScheduler:

  • SQL server
  • MySQL
  • PostgreSQL
  • SQLite

Below is the specific setup required for each of these databases.

Information and credentials required for a MySQL database to function as repository database are:

  1. Database host:
  2. (Optional) Database port:
  3. Database name:
  4. Database username:
  5. Database password:

In order to use SQL Server, a SQL-srv account has to be used as opposed to a Windows-authenticated (AD) account. Furthermore, the following is required:

  1. Database host:
  2. (Optional) Database port:
  3. Database name:
  4. Database username:
  5. Database password:

PS: Using a host with like machine01instance?
Write it like this: machine01instance

Required connection information for a PostgreSQL database are:

  1. Database host:
  2. (Optional) Database port:
  3. Database name:
  4. Database username:
  5. Database password:
  6. (Optional) Default schema:

To use SQLite for a local flatline database, a database name must be defined. If this database name is already present, the existing database will be reused for MailScheduler. SQLite is a local flatfile database. This database should be used for testing only as you can’t connect to it from Tableau.

Create a User

The next step is to create an admin user for MailScheduler. This user will be used for the initial login into the application. Make sure to write down or remember the login information (this can be changed in the application after logging in).

SMTP Setup

In order to send an email, you have to configure your mail server to send out your Tableau dashboards. Required for this step are:

  • Host
  • Port
  • Encryption protocol
  • Username/Password

 

Furthermore, a default “From” and name should be configured. This is the contact information that will be visible to receivers of any mail sent by MailScheduler. The “From” address and name can later be configured for each individual task.

MailScheduler API

Enabling the MailScheduler API allows for advanced configuration and automation between MailScheduler and other services within your environment.

URL & SSL Certificate

Next is the configuration of the domain the application will be run on. The protocol (e.g. http:// or https://) can be skipped. You can specify a port number at the end (e.g. mailscheduler.company.com:8080).

If the application is running behind a proxy or load balancer, be sure to check the box and fill in the following details:

Background Service

Register MailScheduler as a background service through the installer. This automatically launches the application when the system is rebooted. This is optional, but recommended when using MailScheduler in any scenario except trial.

Upgrading MailScheduler from 2.x to 3.0

The greatest part of MailScheduler 3.0 is that it has a built-in webserver. In other words, it does not need to have IIS or XAMPP for serving the application anymore.

This guide will explain how to transfer configuration to the new MailScheduler 3.0 application and how to disable/remove the current webserver to be able to reuse the system ports.

The upgrade setup of MailScheduler 3.0 requires the following information:

  • The .env file of your current installation.
  • The LICENSE file (downloaded from our portal or copied from your current installation)
  • The URL and port that is used by the current installation.
  • The SSL Certificate (in .pfx or .crt & .key format) that is applicable to the forementioned URL

In this guide we will extract this information from the current installation.

Lets get started!

  1. Create a backup of the installation directory of MailScheduler.

You will need the .env and LICENSE files that are in there for the new installation.

Your current version of MailScheduler can be served by either XAMPP or IIS. Follow the steps for your type of installation in the appropriate section below.

Internet Information Services (IIS)

We need to do 3 things:

  • Export SSL Certificate
  • Retrieve the URL and port