Fivetran vs. Mode Analytics

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

Mode is a clear category winner for how it easy it is to go from interactive analysis to professional quality reporting. You can easily do all your SQL and quite a bit of R/Python. If you want to quickly go from your database to simple charts, this is your pick. If you need to do heavier data modeling, scheduling jobs, or ML, you'll need something else, like Databricks. In my opinion, the quality of visualizations and some developer/analyst features make Databricks an unacceptable substitute.

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

• It allows me to undertake data visualization tasks by creating really insightful charts and dashboards
• It allows for easy sharing and work collaboration on data analysis tasks
• Mode has an easier to use SQL editor as well
• I love how it organizes all our SQL data tables into easy-to-view data we can draw insights on

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

• Date ranges aren't always the most intuitive to set, strangely
• Faster refresh rates would be ideal
• Would love more dynamic mobile device integration (alerts, etc)

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

For the advanced user already familiar with Python. It is just the same tool, already managed and connected to the data.

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

Mode has dedicated agents who are online in a chatroom, ready to take on any questions and provide helpful feedback.

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

We used both Qlik and Mode at our organization. The mode was used a quick analysis SQL tool while Qlik was our enterprise BI solution.

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

• Extremely positive. It's a key feature in our application.
• Were it not for the account management bit, Mode would be hands-down our recommendation for anyone looking for cloud BI.

Incentivized