Item: Matillion
Rating: 7
Author: Verified User

Use Cases and Deployment Scope

The main issue at innova is manual process. With matillion we implemented automated data flow for disposal data to Google BigQuery

currently
We have near 50 automated jobs that runs every 5am and finished at 5.30am.

Also we matillion for extract data from HubSpot, zoom, brighspace, PostgreSQL, MySQL, cloud storage.

Pros and Cons

Integration
Performance

Job developing ( if you have complex jobs, design the flow can be expensive)
Cost
Flexibility

Key Insights

Do you think Matillion delivers good value for the price?

Not sure

Are you happy with Matillion's feature set?

Yes

Did Matillion live up to sales and marketing promises?

Yes

Did implementation of Matillion go as expected?

Yes

Would you buy Matillion again?

Yes

Return on Investment

Automated jobs
Faster etl workloads

Usability

No code is nice but sometimes require add pythons code. Somethings documentation is not enough

Time to Value

Currently we have 50 data jobs. That took at least 3 months(preparing connections, flows, integrations)

Scalability

The tools have a good performance, however time designing is high

Other Software Used

Google BigQuery, Microsoft Power BI, Looker Studio

Likelihood to Recommend

Performance is nice, but if you need creating a complex pipeline, you required long hours for developing the job can be really expensive, every minute is billed in design phase.

On the other hand. Matillion help us for integrate data sources like netsuite, HubSpot and others.

A Necessary tool

Overall Satisfaction with Matillion