Matillion Data Productivity Cloud Review

As businesses continue to understand the importance of data, there has been a greater emphasis on data productivity and analysis tools. Data assists in gaining insights into markets, running targeted ads, and making better decisions. Expectedly, data productivity tools should have features that facilitate these business operations.

A company that has been making strides in that region is Matillion. With its Data Productivity Cloud, the company empowers businesses to operate against a backdrop of data, providing more realistic expectations. This article explores Matillion Data Productivity Cloud and analyzes its most notable features.

Matillion Overview

Matillion is a technology company aiming to simplify how businesses analyze and process data. The company’s goal is to get businesses data-ready by reducing the time it takes to process data and increasing their impact. Since its establishment in 2011, Matillion has helped numerous businesses load, transform, and orchestrate their data for various purposes. The client list includes Cisco, Slack, DocuSign, and Pacific Life.

The company has six core values under which it performs its operations and activities. These include confidence, innovation, being people-focused, caring about society, integrity, and eliminating biases. Guided by these values, the company has created the Data Productivity Cloud, which has numerous solutions that help you perform various operations with data. These solutions include the ETL, Reverse ETL, Data Ops, Change Data Capture, and Database Replication.

The company prioritizes inclusivity and has offices in different European regions. To build corporate culture, it ensures that its employees meet once a year for corporate planning at its Manchester headquarters. 

• Established: 2011
• Founder: Matthew Scullion
• Offices: UK, USA, Spain

5 Core Features of Matillion data productivity cloud

Expert Opinion

Rating: 4.5/5

Matillion Data Productivity Cloud assists businesses in building data pipelines for informed business decisions and operations.

The Data Productivity Cloud delivers as Matillion advertised and promised on its website. Right from the registration and account creation stage, processes are smooth and easy to perform. 

After signing up, you can almost immediately start building data pipelines by connecting to a data warehouse or other data sources. Initially, it was impossible to import data directly from Excel. However, you can now use the Excel Query component in ETL for Matillion Snowflake to connect to an Excel file and pull data.

The pay-as-you-go approach to plans and pricing ensures no business is cheated, and each only pays for the needed services. However, this removes the “unlimited” benefit associated with the time-based pricing model. You may consume all your credits quickly and find yourself buying multiple credits within a short time. With a monthly plan, though, regardless of how much you use the platform, payment isn’t until the beginning of another month.

Customer support can also be more responsive and easily accessible. Overall, the Data Productivity Cloud is a multi-featured platform for all a business’s needs and wants.

Notable Features

The Data Productivity Cloud provides an entire suite of features for effective data reporting and analysis. Here are the core ones:

1. Generative AI

Matillion becomes the first company to unify pushdown ELT and pushdown AI to make working with data pipelines easier. As a result of this innovation, data teams can feed enterprise data into artificially created data pipelines to develop a form of data sandbox. 

These teams can perform various experiments on this data, contextualizing it for use in large language models. Ultimately, this drives the team to build faster and better. Matillion also incorporates a Copilot into the platform that receives plain language instructions to complete simple tasks or perform complex transformations.

2. Advanced Data Pipeline Operations

The Matillion Data Productivity Cloud platform allows you to perform every basic and advanced operation associated with a data pipeline. Matillion can import data from any cloud data platform in just a few simple steps and clicks and add it to your project list. You can add your project environment to the explorer to build your data pipeline. 

From the workspace called Designer, you can quickly connect to a different software program or app, import and extract your data, and then open it. At this stage, the platform cleans and transforms the data by filtering, sorting, and modifying it so that transferring it to its destination is easy. The platform utilizes a distributed visual ecosystem that connects to all the different data pipelines to improve visibility.

3. Simple, Low-code Solution

Using Matillion Data Productivity Cloud requires little to no coding expertise or experience. The platform’s interface is intuitive, and data building is straightforward. It features a batch loader that enables you to automate data pipelines and handle schema drift and table selection without writing a single line of code.

Its data change capture functionality assists with replicating database changes as they occur with log-based data capture without impacting database performance. You can also access over 150 connectors or use a Java Database Connectivity (JDBC) to connect to and access other databases. Finally, this platform also has a custom connector to connect seamlessly with any application using a no-code open REST API.

4. In-platform Data Warehouse

A data warehouse refers to a database management system where an organization houses its data and analyzes it for quick, important decisions. The Data Productivity Cloud connects seamlessly with any platform or app and allows you to transport your data to start building a data pipeline.

However, if you do not have one, you can also build one easily on the platform. This in-platform data warehouse contains the regular features of a standard data warehouse. Since this is also an additional feature within the Data Productivity Cloud, it makes building data pipelines much easier.

5. Data Source Unification

Regardless of whatever platform you use for your data source, the Data Productivity Cloud provides exceptional flexibility. You can connect to popular sources such as SAP, Salesforce, Workday, and Oracle.

Its unique, low-code value proposition makes it easy to load data from these different sources into a single unified platform. As a result, a business’ data team can make actionable, informed decisions. With a business’s entire data in a single location, the Data Productivity Cloud provides an additional feature to make collaboration better through integration with Git.

6. Robust Security Measures

Matillion has placed sufficient safety and security measures in its platform to prevent personal and business data from falling into the wrong hands. Firstly, access to the Data Productivity Cloud requires a username and a password. You can also enable multi-factor authentication to prevent unauthorized access to your projects, even if someone steals your password.

7. Data Reporting and Auditing

The Data Productivity Cloud has reporting and auditing capabilities that management and C-suite executives can find beneficial. It enables data processing via reports and visualizations like graphs and charts. It also records historical data for auditing and ensuring the correctness of any analyzed data.

8. Functional Hybrid Deployment

Matillion takes a hybrid cloud-native approach with the Data Productivity Cloud. It uses a stateless micro-services architecture to run in full SaaS or hybrid SaaS mode. This means its architecture stores no records or memories of previous transactions. Massive amounts of agents can work in parallel to process data operations faster. Alternatively, you can use fewer agents for a longer time if you’re not in a hurry to get results.

Plans and Pricing

Matillion utilizes a pay-as-you-go pricing approach for its Data Productivity Cloud. This model ensures that businesses pay for what they need rather than what the platform or its provider offers.

This consumption-based pricing model makes moving, transforming, and orchestrating data at scale easy. You can also use any credits you purchase across any other Matillion tools that you use. The absence of monthly-based payment eases the pressure on data analysis and development tools. The cross-platform applicability further strengthens this and provides a high level of flexibility.

Below are the three major plans that are available for the Data Productivity Cloud:

Basic Plan

Subscribing to the basic plan enables five different editors to collaborate on a single project. As the name suggests, it can serve most of a business’s basic needs and is suitable for startups and similar businesses with a sizeable amount of data. This plan also has other features, like:

• Unlimited read-only users
• Real-time validation and sampling components
• Move, transform, and orchestrate pipelines
• Matillion-hosted deployment
• Job automation and scheduling

Advanced Plan

This plan provides every feature that the Basic plan offers. It’s suitable for rapidly growing companies and businesses looking to scale their data operations. Here are some of its defining features:

• Auto-generated documentation and audit logs
• Project-level permissions
• Seamless integration with your data warehouse and Matillion ETL
• Unlimited users

Enterprise Plan

The recommended plan for any large-sized organization with massive amounts of data. Subscribing to the enterprise plan helps you enjoy all the features of the basic and advanced plans. That means there’s no limit to the number of users on a project, and there’s permission management for individuals and groups. Additionally, this plan also offers:

• Hybrid cloud deployment
• CDC pipelines
• Git repository
• Pre-built and custom connectors
• Option to include Mission Critical Support or Mission Critical Support Plus

Plans and Features Comparison Table

Below is a comparison table of the Data Productivity Cloud’s different plans and features:

Terms and Policies

Matillion’s terms of service provide a detailed overview of how the company expects users to relate to its products. This is obtainable for free on the company’s website. These terms appear first on the screen whenever a user installs any company’s products. It’s a must to accept them in order to have access to the desired platform.

Any intended user must create an account with the company to use the Data Productivity Cloud. After that, the user should obtain the license for that software and abide by any copyright protection rules. If the person breaches an agreement, the company reserves the right to terminate their access to the said platform.

Matillion is a privacy-focused company, and this shows in its privacy policy. The company collects various data from you and uses this to improve its service delivery. It can collect personal information, like names, email addresses, and billing information. Matillion is a global organization with offices in different regions worldwide. The data protection laws that the company follows typically depend on the region of operations.

Customer Support

Matillion’s support offerings are multi-faceted, typical of a company of that size. There are three different support offerings, and the level of support you get depends on which offering you purchased. Below is a brief overview of the different levels of support that Matillion offers:

Standard

This is the base level of support and is included in every tool or software program from the company. It’s free and offers the following:

• 8×5 Support hours
• 4 Customer Support Contacts
• 24×7 Support Portal

Mission Critical

This is an upgrade over the first plan and expands on the support benefits it offers. It costs an undisclosed amount and provides the following:

• Premium Support Team
• 12×5 Support hours
• 8 Customer Support Contacts
• 24×7 Support Portal
• 24×7 Critical Support (Priority-1)
• Accelerated Response Time
• 2 Expert Sessions /year
• 1 Support Service Reviews /year

Mission Critical Plus

This is the highest level of support that any user can get from the company. It provides the following:

• Premium Support Team
• Technical Account Manager
• 24×5 Support hours
• 20 Customer Support Contacts
• 24×7 Support Portal
• 24×7 Critical Support (Priority-1)
• Accelerated Response Time
• 4 Expert Sessions /year
• 2 Support Service Reviews /year
• Proactive Case Monitoring
• Developer Support
• Health Assessment
• Release Guidance
• Escalation Management
• 2 Weekend Support /year

Matillion organizes training and consulting packages via its Professional Services to assist its customers in their cloud data journey. If you also need to contact the customer support center to find out both technical and non-technical information, you can follow these channels here:

Support Portal

support.matillion.com

Manchester, UK

Station House, Stamford New Road
Altrincham WA14 1EP

Denver, USA

675 15th Street, Floor 21
Denver, CO 80202

Madrid, Spain

Paseo de la Castellana 77, Suite 06.105
Madrid, 28046

Conclusion

The Data Productivity Cloud is recommended for any business transitioning to data-focused operations. It makes it easy to build data pipelines, and its pay-as-you-go subscription model means it’s relatively cheaper than similar tools in the market today. You can request more information by submitting your details at their “Contact Us” webpage.