Overview

Matillion is an extract, transform, load (ETL) platform for cloud data warehouses (CDWs) like Snowflake, Google BigQuery, and Amazon Redshift. This centralized system allows you to automatically schedule orchestration projects and tasks at regular pre-decided time intervals. Its key functionalities include task management, data import/export, auditing, versioning, and live collaboration.

Matillion permits you to remove/add users from the local directory and provide role-based access across SSL certificates or Active/LDAP directories. In addition, you can browse through several projects and notes to locate specific results utilizing the search feature. The software integrates with a range of third-party tools like Elasticsearch, Salesforce, Hubspot, Amazon RDS, MailChimp, and others.

Benefits

Designed for CDWs

Matillion is a data transformation platform created for CDWs. It can handle the load and extract of business information into a CDW, offering the required performance and scale to facilitate data-based analytics. The software can join together different data sources via its robust transformation features, completing the procedure to make data fully ready for analytics.

Search Tool

Matillion allows you to collect data from different sources and deliver them in semi-structured and structured formats using the system’s data transformation tools. Its search capability allows you to locate specific results across components, jobs, and notes within projects via term-based searches.

Data Security

You can utilize the automation functions to schedule several orchestration tasks against a project at pre-determined time intervals. Admins can make sure of data security by controlling user access across authentication, SSL certificates, and Active/LDAP directories for utilizing data from the local directory.

Integrations

Matillion integrates with third-party programs like Marketo, Jira, Google Analytics, Facebook, and others to assist in data management across cloud warehouses. The platform also offers an API query element that lets you integrate the application with any XML-based or JSON API.

Product Features

Pricing

Matillion Data Loader 

• Free
• Load millions of rows of data for free
• Create data pipelines at zero cost to support your data migration initiatives
• Connect to leading data sources

Matillion ETL 

Medium

• Starting at $1.37/hr
• Estimated annual charge of $12K, assuming 24/7 usage.*

Large

• Starting at $2.74/hr
• Estimated annual charge of $24K, assuming 24/7 usage.*

XLarge

• Starting at $5.48/hr
• Estimated annual charge of $48K, assuming 24/7 usage.*

Enterprise

• Custom pricing based on expected annual consumption.

Note: *Estimate does not include infrastructure costs and additional fees.