Andy Klier

Andy is an experienced software developer with a track record of driving innovation, growth, and successful outcomes. He currently works as a DevOps Manager at Zuar.

AWS monitoring using CloudWatch, SNS, Lambda & Slack for EC2

Databases

AWS EC2 Monitoring With CloudWatch, SNS, Lambda & Slack

Learn how to subscribe a custom Lambda function, that formats a slack message and makes a POST request to a slack channel.

Learning

How to Embed Raw Code From Github in Ghost Posts

Embed Github raw code into a Ghost post. This is an integration-free solution, using only HTML and Javascript.

Tableau

Export Tableau Dashboards to PDF Using Tabcmd

Learn how to use tabcmd for Tableau to export dashboards, views, workbooks, and data to PDF.

How to fix tableau trusted authentication

Tips and Tricks

Troubleshooting Tableau Trusted Authentication

Trusted Authentication is one method that Tableau Server customers use to embed dashboards into their applications. If your trusted tickets aren't working, this article will help.

Rclone OneDrive and SharePoint integration

Mitto

Using Rclone for SharePoint Shared Files

Use Rclone for Sharepoint Shared Files. In this example, the Sharepoint user doesn't own the files shared with them, so Rclone does not show them...

Mitto

Python with Virtualenv in Mitto

Mitto is Zuar's data pipeline solution. Learn about importing a Python package we don't have installed on Mitto, such as pandas or numpy.

Mitto

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.

Mitto

Automate Bash, R, and Python Scripts With Mitto

In this blog post we will discuss the Mitto command line job, and then walk through examples of automating scripts from various languages: * Bash * R * Python With Zuar's Mitto platform, you can automate your ELT/ETL processes and have data flowing from hundreds of potential sources into a single destination.

Mitto

How to Manipulate Excel Data for Analytics Using Mitto

Recently at Zuar [https://www.zuar.com/], we had a user that needed to pull a subset of data from a Microsoft Excel [https://www.microsoft.com/en-us/microsoft-365/excel] spreadsheet, and pivot that Excel data to create a new table with a specific data structure. Our approach to Data

Mitto

Adding Custom Plugins to Mitto

Learn how to add and use custom plugins in the Mitto ELT platform.

Mitto

Mitto and Rclone - Custom Jobs

Rclone 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 rclone plugin provides an rclone job