Turned a Scrappy Startup into a Polished Engine
April 18, 2019

Turned a Scrappy Startup into a Polished Engine

Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

We are using Matillion as a way to automate our manual ETL processes for getting a wide variety of data loaded into Snowflake on AWS. It is a core piece of our Data Engineering and works for us as it generates SQL (no lock-in) and works great for a startup given the low-cost profile (pay-as-you-go).

Pros

  • Transformation Jobs as a way to build up complicated SQL
  • Variety of data source connectors - we didn't think we'd need them but turns out we did
  • The ability to call out to bash or python as needed

Cons

  • Security (Auth/Azn) - auditing is really good
  • Difficult to structure job flow sometimes (unconditional vs failure-to-exit - which takes place first)
  • Management of Job variables and environments
  • Very quickly lets us move from manual scripts to a more automated event-driven architecture
  • Ability to support multiple clients more easily
  • Integration to data sources that would take us a long time on our own
There are some aspects to developing transformation jobs (being able to sample and see the data / SQL) that are really helpful. But there are some other features that we know that they will improve upon.
Able to get it up and running very quickly. I did have to do a bit of reading to understand the big picture, but some of the online videos got me up and running instantly. We completely evaluated what it could and could not do in about 2-3 weeks.
We've not pushed this but they also have the ability to scale to a cluster of servers.
Talend has a much steeper learning curve. SnapLogic was too expensive but had the best set of features. We did not try Pentaho but that was next on our list.
Matillion is great if you need a low-cost profile. It is extremely easy to learn and online documentation and videos are very helpful.

If you need something that fits a deeper level of integration (in terms of CI/CD), then it can add to cost (multiple instances) or just won't give you what you need.

Matillion Feature Ratings

10.0
Connect to traditional data sources
10
Connecto to Big Data and NoSQL
10
10.0
Simple transformations
10
Complex transformations
10
3.0
Data model creation
5
Metadata management
2
Business rules and workflow
2
Collaboration
4
Testing and debugging
2
Data Governance ()
Not Rated

Comments

More Reviews of Matillion

  1. Home
  2. Data Integration Tools
  3. Matillion Reviews
  4. User Review of Matillion