Integrations

Introduction

Mammoth supports a variety of integrations with external platforms. These integrations fall into the following categories.

  1. Sources
  2. Destinations

Sources

A source is a platform that Mammoth can get data from. Here are the list of sources Mammoth supports

  1. Mixpanel
  2. Google Analytics
  3. Google Ads
  4. Salesforce
  5. Segment
  6. PostgreSQL
  7. MySQL
  8. SQL Server
  9. Webhooks

Destinations

A destination is a platform to which Mammoth can send data to. Here are the list of destinations on Mammoth.

  1. Google sheets
  2. PostgreSQL
  3. MySQL
  4. Elasticsearch
  5. Power BI

Mixpanel

Mixpanel is a business analytics platform. It tracks user interactions with web and mobile applications and provides tools for targeted communication with them.

Its toolset contains in-app A/B tests and user survey forms. Data collected is used to build custom reports and measure user engagement and retention. Mixpanel works with web applications, in particular SaaS, but also supports mobile apps.

Mixpanel import screen

You can add your mixpanel data as a dataset in Mammoth from the add data dialog. This will get all the raw data from mixpanel into Mammoth and you can either use Mammoth as a warehousing solution or as a reporting solution.

Google Analytics (Beta)

Google Analytics is a web analytics service offered by Google that tracks and reports website traffic.

Google Analytics is the most widely used web analytics service on the web. Google Analytics provides an SDK that allows gathering usage data from iOS and Android app, known as Google Analytics for Mobile Apps.

Google analytics import screen

Mammoth allows you to query Google Analytics API. You can configure the metrics, dimensions and segments in Mammoth’s user interface and get any report you need from your Google Analytics Data.

PostgreSQL

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!

PostgreSQL import screen

Mammoth allows you to connect to your PostgreSQL database and get that data into Mammoth. Once the connection is successful, you will be presented with a list of tables and views in that database. You can also write a custom SQL query if you so choose.

Once the data is in Mammoth, you can transform and analyze that data without writing a single line of SQL. This will empower business and non-technical users in your organization to gain insights from your database

Mixpanel import screen

Mammoth also allows you to send data to a PostgreSQL database from any view. This is done through the export functionality on Mammoth.

Note: Make sure that Mammoth’s public IP address is added to your whitelist. Mammoth’s public IP is displayed on the create connection window.

MySQL

MySQL is the world’s most popular open-source relational database management system. With its proven performance, reliability and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter, YouTube, Yahoo! and many more.

MySQL import screen

Mammoth allows you to connect to your MySQL database and get that data into Mammoth. Once the connection is successful, you will be presented with a list of tables and views in that database. You can also write a custom SQL query if you so choose.

Once the data is in Mammoth, you can transform and analyze that data without writing a single line of SQL. This will empower business and non-technical users in your organization to gain insights from your database

MySQL export screen

Mammoth also allows you to send data to a MySQL database from any view. This is done through the export functionality on Mammoth.

Note: Make sure that Mammoth’s public IP address is added to your whitelist. Mammoth’s public IP is displayed on the create connection window.

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.

Microsoft maintains at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

SQL Server config screen

Mammoth allows you to connect to your Microsoft SQL Server database and get that data into Mammoth. Once the connection is successful, you will be presented with a list of tables and views in that database. You can also write a custom SQL query if you so choose.

Once the data is in Mammoth, you can transform and analyze that data without writing a single line of SQL. This will empower business and non-technical users in your organization to gain insights from your database

Note: Make sure that Mammoth’s public IP address is added to your whitelist. Mammoth’s public IP is displayed on the create connection window.

Salesforce

Salesforce is a cloud-based customer relationship management (CRM) platform for every part of your company that interacts with customers — including marketing, sales, commerce, service, and more.

Salesforce provides companies with an interface for case management and task management, and a system for automatically routing and escalating important events. The Salesforce customer portal provides customers the ability to track their own cases, includes a social networking plug-in that enables the user to join the conversation about their company on social networking Web sites, provides analytical tools and other services including email alert, Google search, and access to customers’ entitlement and contracts.

Salesforce export screen

Mammoth allows you to query data from the Salesforce API. After OAuth, you will be presented with a list of Salesforce objects. You can get data from these Salesforce objects into Mammoth and do any analysis & reporting you would like to perform on your Salesforce data.

Segment

Segment is a popular data collection framework that can help you collect data from your website, mobile apps, servers, CRM etc and route that data into hundreds of destinations. It significantly reduces the development time you need to spend on your tracking and can help you understand your users better.

Mammoth and Segment

You can read more about Mammoth’s Segment integration here: Connecting Segment data with Mammoth.

Webhooks

A webhook is a user-defined callback over HTTP. Using Mammoth’s webhook functionality, you can send data from a variety of SaaS services and custom code into Mammoth.

Read more about webhooks here: Webhooks.

Elasticsearch

Elasticsearch is a highly scalable open-source full-text search and analytics engine. It allows you to store, search, and analyze big volumes of data quickly and in near real time. It is generally used as the underlying engine/technology that powers applications that have complex search features and requirements. Elasticsearch provides a distributed, multitenant-capable full-text search engine with an HTTP web interface and schema-free JSON documents.

One of the most popular frontends for elastic search is Kibana. Using Kibana you can create a visualisations and dashboards. ELK stack (elasticsearch, logstash and kibana) are really popular in the developer community.

Elasticsearch export screen

Mammoth allows you to send data to an elasticsearch cluster from any view. This is done through the export functionality on Mammoth. You can build dashboards on the data using Kibana.

Power BI (beta)

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

Power BI comes in mainly two variants.

  1. Desktop
  2. Cloud
Power BI export screen

Mammoth allows you to send data to Power BI cloud from any view. This is done through the export functionality on Mammoth.

Read more about how this integration works here

Google sheets (Beta)

Google Sheets is a spreadsheet program included as part of a free, web-based software office suite offered by Google within its Google Drive service. It has become the defacto spreadsheet program for many small businesses and has reduced the dependency on excel while adding collaboration into the mix.

Live link Config screen

Using the live link functionality in Mammoth, you can easily sync your view data into a google sheet. You need to use the IMPORTDATA formula in a new sheet.

Import data usage in google sheets

Once the data is in Google Sheets, you can share the sheet with any stakeholders. You can also make Google Data Studio dashboards on the other side of the Google Sheet.

Notes:

  1. Google will update the sheet every 30 minutes.
  2. Maximum number of cells in your view should be less than 160000.