Sequences Sequences Mitto allows you to run jobs in batches. These batches are called Sequences. You can imagine a sequence as a job full of jobs. To create a sequence, hover over the "+ Add" button
Jobs Scheduling How to Schedule a Mitto Job?Every Mitto job can be scheduled to run at specific times. On any individual job page, click on the orange edit button under SCHEDULE to open a
UI Stage Since Mitto is a data staging platform, where your data can be stored and interacted with in one place, your Mitto front page is called the Stage. This is where all your favorited
Analyze Connect DataGrip to Mitto DataGrip is an IDE that you write out and test your SQL queries in prior to using them in Mitto. Since Mitto does not check the validity of a SQL query statement, it
FAQ Flat File Basics The Flat File connector is a collection of connectors – CSV, Excel, JSON, etc. Adding and creating a Flat File JobSimilar to adding a CSV file, adding a flat file database to your Mitto
FAQ Mitto Best Practices SQLUse an IDE for testing SQL statementsUse an IDE like DataGrip to test your SQL statements prior to running them in Mitto SQL jobs. Include the table schema in SQL statementsIt is a
Inputs - Flat Files JSON OverviewMitto's JSON plugin pipes data from any JSON file into a relational database. Example use caseLet's take a simple JSON file with nested data and convert the data into tables in a relational
Jobs Notifications You can have Mitto notify you on the status of your job. 1. Navigate to Settings on the left hand panel. Learn more about the Settings page. 2. Click on Configure. 3. The
Inputs - Flat Files CSV By adding this CSV file to your Mitto instance, you will see this CSV file as a table in your designated database. It can then be viewed in the database with a BI
Inputs - APIs Netsuite OverviewThe NetSuite plugin enables Mitto to pipe data from NetSuite and store the data in a database. NetSuite Credentials StepsNetSuite setup instructions for Mitto here. Steps to create NetSuite jobs in MittoSelect Add
Analyze Connect Tableau to Mitto Tableau is a powerful data visualization software. You can take the different sets of data you have staged in Mitto and use Tableau to analyze that data in a uniform way. You will
General Automation Email (Incoming - IMAP) - Old Mitto allows you to grab files from UNREAD email attachments and download them to Mitto's file manager. The files can then be used in subsequent jobs (CSV, Excel, JSON, etc) to create the
UI Database The database tab is where you can view information about your Mitto instance's database. This information can be used to connect other services to Mitto, e.g., Tableau, DataGrip, etc. Database Connectivitya. Connection:
Job Types Tableau Export UpdateThe Tableau Export job was introduced to Mitto in early 2019. It allows Mitto users to create Mitto jobs that use the the Tableau cli command tabcmd to create reports in PDF, CSV,
UI History The History section shows a running total of jobs that were run. Number: Number of jobs that ranStatus: Status of the jobJob: Name of the jobStarted: The date and time of when the
UI Settings The Settings page is where you can find more details about your Mitto instance. Let’s dive into the different sections of Settings. About TabProduct Configuration This section shows the version of Mitto