FAQ What's my Mitto Version? In Mitto, click on the Settings link. On the settings page, on the About tab, you will see the version of Mitto in the top left.
General Automation Rclone OverviewRclone is a program that can be used to transfer files to and from more than forty different storage backends (e.g., Amazon S3, Box, Dropbox, FTP, Google Cloud Storage, Google Drive, Microsoft
Features Mitto API Almost every action performed in the Mitto UI has a corresponding REST API endpoint. This means you can programmatically create and manage jobs and use Mitto as a data source. Base URLhttps://{mitto_
Pipe Excel Excel jobs in Mitto can be used to create database tables from individual sheets in an Excel (xls, xlsx, etc) file. Upload the Excel file:Click on the Files menu item in Mitto.
MJ Freeway MJ Freeway exposes analytics data to clients via Qlik reports. The Mitto MJFreeway plugin allows users to pipe the data from any chart or table in an MJ Freeway (Qlik) report. Mitto credentialsMitto
FAQ Security Mitto is an extremely flexible and extensible platform with extremely varied uses cases. The overall security standards of Mitto depend upon the choices users make. In every case, there is a secure option
Overview Overview Welcome to the help documentation for Mitto. Here are links to documentation for Zuar's other products: Rapid PortalCustom PortalWeb Application FirewallWhat is Mitto?Mitto is an automation platform. Conceptually Mitto consists of: one
Pipe Google Sheets The Google Sheets plugin enables Mitto to pipe data from Google Sheets and store the data in a database table.
Pipe Salesforce OverviewThe Salesforce plugin enables Mitto to pipe data from Salesforce and store the data in a database. Steps to create Salesforce jobs in MittoTo pipe data from Salesforce to Mitto, following the steps
Setup Hosting & Tech Specs Below are the hosting options (Zuar hosted or self hosted) and system requirements for Mitto. HostingZuar Hosted MittoServer hosted by Zuar in AWS. Two factor authentication: Username and password - Mitto UI and
Pipe Google Analytics OverviewThe Google Analytics plugin enables Mitto to pipe data from Google Analytics and store the data in a database. Steps to Create Google Analytics Jobs in Mitto Click +Add Job. Choose Google Analytics.
Pipe Generic OverviewThe Generic plugin provides a wizard for creating any custom job in Mitto. Create a Generic jobClick + Add Job. Choose Generic job. Fill out the form. Title - Title of the jobConfig -
Store Mitto Store Mitto has the ability to store source system data as JSON on the file system of the Mitto server. The data is stored in a RocksDB key-value store. Benefits of a Mitto StoreSeeing
Pipe Quickbooks Online OverviewThe Quickbooks Online plugin enables Mitto to pipe data from Quickbooks Online and store the data in a database. AuthenticationThe Quickbooks Online API requires username and password authentication. During the initial setup you
Pipe Mitto Store Input Once raw source data is stored in a Mitto store, the Mitto store itself can become a source (input) in an IO job. The primary use case for this is to create several
Transform SQL OverviewUse the SQL plugin to write, save, and automate SQL query jobs in Mitto. Mitto can send these queries to any database it has connectivity to. Typical use cases include creating schemas, tables,
Pipe Hubspot OverviewThe Hubspot plugin enables Mitto to pipe data from Hubspot and store the data in a database. AuthenticationThe Hubspot API requires an API key for authentication. Please see instructions from Hubspot for accessing
Pipe Query You can use Mitto's Query plugin to create a relational database table from any SQL query against any relational database. The source database and destination database can be Mitto's built in PostgreSQL database
Pipe RegEx The Regex plugin creates a single “union” table in a database from any files matching a regular expression (RegEx) by leveraging any of the flat file connectors (XSV, Excel, JSON, etc) as a base.
Store Database URLs What is a Database URL?The Database URL is the connection string of a database. By default in Mitto it is the local database (postgresql://localhost/analytics). The structure of database connection strings
General Automation Command Line You can run any command line command via a Mitto job. Steps:Create a generic job. The JSON config should look like this: { "cmd": "sleep 15", "shell": true } Any valid command line command
Transform Union OverviewMitto's Union plugin combines multiple database tables into a single "union" database table. The input tables all need to be from the same source database. However, the output database table can be a
Navigation Swimlanes OverviewSwimlanes is a visual representation of every job run in Mitto. Similar information about job runs can be found on the History page. Understanding SwimlanesThe Swimlanes visual is a Gantt chart. Summary MetricsAcross