Matillion is a data pipeline platform used to build and manage pipelines. Matillion empowers data teams with no-code and AI capabilities to be more productive, integrating data wherever it lives and delivering data that’s ready for AI and analytics.
$2.50
Pay as you go per user
Zoho DataPrep
Score 10.0 out of 10
N/A
Zoho DataPrep is an ETL platform with advanced data preparation capabilities that help move, cleanse, transform and enrich data quality.
$0
per month for processing 20,000 rows per month
Pricing
Matillion
Zoho DataPrep
Editions & Modules
Developer: For Individuals
$2.50/credit
Pay as you go per user
Basic
$1000
per month 500 prepaid credits (additional credits: $2.18/credit)
Advanced
$2000
per month 750 prepaid credits (additional credits: $2.73/credit)
Enterprise
Request a Quote
Standard
$50
per month 3 users
Enterprise
Contact Sales
Starts from 100 Million scales to billions of rows per month & 10 users
Offerings
Pricing Offerings
Matillion
Zoho DataPrep
Free Trial
Yes
Yes
Free/Freemium Version
No
Yes
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
No setup fee
Optional
Additional Details
Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.
Great: Need to query simpler APIs, or utilize well known services such as GSheets etc.? Matillion has got some of the best and easiest to use connectors out there. Not so great: Do you need have a competent CI/CD flow that you will be able to update / compare from Matillion as well as other sources at the same time? Good luck, you will need to be extra careful, as you might have to have a deeper dive into your servers Terminal each time you have a git conflict.
Scenarios where it works well: 1. Preparing reports like CRM, Marketing, and sales for monthly reports. 2. Cleaning CSV files with inconsistent format 3. Removing of duplicates and finding error values 4. Enabling non-technical people to manage data preparation without coding. Scenarios where it is less appropriate: 1. Processing real time data and large scale data needs 2. Deep customization at code level 3. At advanced predictive modeling
Matillion is brilliant at importing data -- it would be amazing to have more ways to export data, from emailed exports to API pushes.
Any Python that takes more than a few lines of code requires an external server to run it. It would be great to have more integration (perhaps in a connected virtual environment) to easily integrate customized code.
Troubleshooting server logs requires quite a bit of technical expertise. More human readable detailed error handling would be greatly appreciated.
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.
We are able to bring on new resources and teach them how to use Matillion without having to invest a significant amount of time. We prefer looking for resources with any type of ETL skill-set and feel that they can learn Matillion without problem. In addition, the prebuilt objects cover more than 95% of our use cases and we do not have to build much from scratch.
I would rate Zoho DataPrep a 10/10 for its usability because I feel it is very easy and intuitive platform and even non-technical people can access it easily without coding knowledge. Also, its workflow builder is very straightforward, once we create any data pipeline then we can reuse it easily.
Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum is essential to deciding which tool fits better. For the transformation part, dbt is purely (SQL-) code-based. So, it is mainly whether your developers prefer a GUI or code-based approach.
Zoho DataPrep is much easier to use and quick to set up. It user interface is very user friendly, even people with no technical knowledge can use it easily to transform the data. It creates the repeatable workflows easily and more cost-effective for small to mid-size teams. We selected it because it aligns with our business needs and goals perfectly like fast, easy, and efficient for everyday use.
We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.
