Fivetran vs. Matillion vs. Sigma Computing

Fivetran's business model justifies the use-case where we require data from a single source basically a lot of data but if the requirement is not on the heavier side, Fivetran comes to costly operation when compared to its peers. Otherwise, I'll recommend Fivetran for stability and update and seamless service provider.

Incentivized

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.

Incentivized

We were able to set up client-facing embedded reports with ease and security. The interface is not difficult to learn, although we may not be aware of or lack the necessary expertise to utilize more advanced features that would likely benefit us.

Incentivized

• Easily connects to source data using delivered connectors
• Transforms data into standard models and schemas
• Has very good documentation to help quickly setup connectors

Incentivized

• The user interface of your data pipelines makes it easier for people who aren’t as techy as data engineers to observe what's going on.
• Customer support is quick, not always as efficient as you would want it to be, but still.
• Nice documentation available.

Incentivized

• Allows end users to easily dive into the data without having direct access to the table in our database management software.
• Can easily turnaround dashboards that are detailed and visually pleasing.
• Sigma is intuitive and as new features are rolled out it is easy to adopt and incorporate them into new and existing dashboards.

Incentivized

• Very difficult to get connectors enhanced if a specific needed object is not supported by them
• Depending on the edition needed and the data volumes, can get quite expensive

Incentivized

• 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.

Incentivized

• Sigma Computing does not allow custom ordering of pivot fields in pivot tables easily
• Sigma Computing lacks functionality for creating tables or sections that dynamically adjust to the browser window's height while maintaining a fixed height textbox at the bottom
• Sigma Computing does not provide straightforward options for formatting totals in tables, such as renaming 'Total' to 'Average', 'Team Total', etc
• Sigma Computing does not support searching by individual tab names within a workbook

Incentivized

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.

Incentivized

Sigma has helped us a lot and has become an integral part of our daily workflow. It would be difficult to switch to another platform and have to rebuild the numerous metrics and performance reports that we have already established

Incentivized

Very easy and intuitive to setup and maintain as there usually are not that many options. Very well documented (e.g. how to setup each connector, how the schema looks like, any specific features of this connector etc.). Also the operation is intuitive, e.g. you have status pages, log pages, configuration pages etc. for each connector.

Incentivized

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.

It has a clean and modern interface. However, it is not completely intuitive. I think it would be better and easier to navigate with more Windows style drop down menus and/or tabls. There is a significant learning curve, but that may be due in part to the technical nature of this type of software tool.

Incentivized

Yes, as long as you don’t conduct user error sigma is always up and running and waiting for you to complete your dashboards

Incentivized

It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.

Incentivized

It depends, it loads quickly for smaller dashboards but when loading larger amounts of data it takes more time to do so

Incentivized

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.

Incentivized

They are very friendly and informative. They are quick in resolving our queries and help us understand very minute things as well. They are quick in creating feature tickets based on our custom requirements, and they would also create a bug ticket if there is any discrepancy and get that checked on time.

Incentivized

We were able to control on access and built various enviroment for implementation

Incentivized

Was not involved in implementation

Incentivized

We never seriously considered using anything else. Our data engineers had used Fivetran extensively in previous roles so when it came time to make a decision, there wasn't much of a process. They gladly signed the contract with Fivetran pretty quickly.

Incentivized

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.

Incentivized

With Looker, to be effective, a substantial amount of coding & modeling needs to happen in LookML. Being another language to learn, users have to context switch again from at a minimum either SQL or Python into LookML. The concept of being able to source control, code review, and deploy your models is a plus though.

Tableau is the gold standard for data visualization, no question. Power users will be able to create dazzling content that Sigma won't necessarily be able to easily match. However, since development usually happens via an extract, helping other users troubleshoot is an arduous process. Trying to re-do or un-do all the transformations and calculations that cause a certain number is very difficult.

With Sigma, all the queries happen directly against Snowflake and you can see the query logs. The data modeling happens right in a tabular, spreadsheet-like manner, so within only a few minutes, substantial transformations can happen, with visualizations just a few more clicks away.

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.

Incentivized

It is a cloud service offering that is able to expand based on your usage

Incentivized

• It has been very positive in serving BI team with new source requests
• It has been OK at scaling to match as data volumes as source data size grows

Incentivized

• Matillion has been the backbone of my company's analytical functionalities for 10+ years, so it has a good ROI.
• The price is ok for what our company built with it, but it starts to be less competitive if the tool is not used at its fullest.

Incentivized

• Monitoring health of cloud platform has allowed the company to anticipate issues before they affect customers – Sigma prompted us building a canary monitoring process that provides customer container health.
• Customer success has used an activity report to discover customers running runaway processes that they were unaware of, creating an alert to contact the customer and prevent an embarrassing situation.
• Customer success uses the activity report to prompt conversations regarding increases or declines in behavior that led to increasing contract limits or addressing churn concerns.

Incentivized