The video tutorials below are for those looking to get started using Mitto or learn more about the available features. Start with the following topics:


Additional information about Mitto can be found in the Mitto Docs.

If you have a question that is not addressed through these tutorials or docs, try checking our Community Forum!

Overview

Creating I/O Jobs

Anatomy of a Mitto IO job | Zuar
This blog post is part 1 of a multi part blog series on understanding and customizing Mitto IO jobs. Mitto [https://www.zuar.com/products/mitto] comes with many different plugins [https://www.zuar.com/help/mitto/plugins/…
How to Manipulate Excel Data for Analytics
Recently at Zuar [https://www.zuar.com/], we had a user that needed to pull a subset of data from an Excel spreadsheet, and pivot that Excel data to create a new table with a specific data structure. Our approach to Data Value Chains helps companies refine and use their data to outperform their co…
How to Unzip Compressed Files in Mitto | Zuar
It’s inevitable that if you deal with enough data, especially exporting data from source systems, that you will eventually be required to deal with a .zip, .gz, or tar.gz file. To get this into a database, you will likely need to unzip the file and use the decompressed files inside. The following…

Creating SQL Jobs

Creating Sequences

Creating Schedules

Adding Tags

Creating Notifications

RCLONE Use Cases

Mitto and Rclone - Custom Jobs
Rclone [https://rclone.org/] 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 Azure Blob Storage, Microsoft OneDrive, Microsoft Sharepoint, SFTP, etc.). The Mitto…
Using Rclone for Sharepoint Shared Files | Zuar
Rclone [https://rclone.org/] is a very powerful, storage-agnostic tool for transferring files across the web. You can copy files to and from ~30 different storage providers including S3, FTP, Onedrive, and yes, you can copy files from Sharepoint sites using webdav. However, to automate the downloadi…

Advanced Use Cases

Adding Custom Plugins to Mitto
How to add and use custom plugins in Mitto.
Cloning a Private Github Repo on Mitto
Whether you have a repository of CSV files, command line scripts, or a custom Mitto plugin, cloning a private Github repo onto your Mitto will require a little setup. We recommend cloning the repo over SSH using a deploy key. To do this, you will need to upload your SSH key to the Mitto filesystem …
Automate Bash, R, and Python scripts with Mitto | Zuar
In this blog post, we will cover the Mitto command line job and then walk through examples of automating scripts from various languages: * Bash * R * Python Mitto command line jobs A powerful feature in Mitto is the ability to automate commands and scripts with command line jobs [https://www.zuar.com/help/mitto/command-line/…
Updating Multiple Jobs with the Python Mitto SDK
Mitto has an extensive API, allowing users to remotely interact with jobs, schedules, etc on their Mitto instance. We recently released a Python SDK for interacting with the Mitto API, available on the Python Package Index [https://pypi.org/project/python-mitto-sdk/]. # install with pip pip install…