TrustRadius: an HG Insights company

Hevo Data

Score8 out of 10

9 Reviews and Ratings

What is Hevo Data?

Hevo Data is a no-code, bi-directional data pipeline platform specially built for modern ETL, ELT, and Reverse ETL Needs. It helps data teams streamline and automate org-wide data flows to save engineering time/week and drive faster reporting, analytics, and decision making.

The platform supports 100+ ready-to-use integrations across Databases, SaaS Applications, Cloud Storage, SDKs, and Streaming Services. The platform boasts 500 data-driven companies spread across 35+ countries using Hevo for their data integration needs.

Key Differentiators:
  • Real-Time Data Pipeline
  • Automatic Schema Detection
  • Data Modelling Capability
  • Zero Data Loss
  • Private Hosting
  • Real-time Alerts
  • 24X7 Support

Media

Transformations
Pipeline Overview
Schema Mapper
Select Source Type
Query Editor
Transformations

1 / 6

Strategically Sound Approach for Data Enhancement and Complex Analytics.

Use Cases and Deployment Scope

Hevo Data is a highly coordinated data application, with numerous functionalities and approaches that increase the service issuance in the company. Hevo Data connects to different data sources, where it ensures every aspect is considered from the security part to the accessibility modalities. More so, Hevo Data is known to handle both complex and simplex transformations and analytical demands. The establishment of data models also increases the speed and the efficiency of the company's operations.

Pros

  • Hevo Data handles all forms of data transformation, from the simplex to the complex ones.
  • The available data models increases the credibility of the analysis.
  • The comprehensive and successful data sourcing and connectivity allows businesses to maneuver.

Cons

  • Hevo Data is slightly complex, in matters operations support.
  • Further, Hevo Data has a poor orientation, and this discourages new users.
  • Finally, Hevo Data requires proper price revision.

Most Important Features

  • Data integration and connectivity is one of the efficient services.
  • Complex and simplex analytics or transformation is another hefty benefit.
  • Credibility of the models developed by Hevo Data is another huge transformation.

Return on Investment

  • Comprehensive results from the data processing is a perfect approach from the tool.
  • Authentic data models brings a high automation process and more productivity.
  • Expansive data sourcing brings clarity and genuine results after inferential analytics.

Reasons why I like using Hevo Data to create data models

Use Cases and Deployment Scope

Hevo Data is a ETL tool which helps us in flattening of nested data. Our database is MongoDB which is a semi-structured database. So Hevo Data help us to create data pipelines or data models which is a processed table. Hevo Data can be connected to multiple sources such as Redshift, Prosgresql, google sheets etc. Hevo Data really help us to create automated pipelines which updates on near real-time.

Pros

  • Building of automated pipelines
  • Models updates on near real-time
  • Flattening of nested data
  • Hevo Data detects anomaly and notified us about the issue
  • Scaling of data is very easy

Cons

  • If we are getting data from other sheets then sheet which is connected to Hevo Data doesn't updates in real-time.
  • Hevo Data change time in it's workbench on its own. For e.g. If our database timestamp is in UTC format then Hevo Data will automatically change the time to IST but if I run the same code outside the Hevo Data workbench then time is still in UTC. This creates lots of confusion while working on Hevo Data.

Most Important Features

  • Updating of data models
  • Getting data from different data sources in a streamline way

Return on Investment

  • When we were able to release reports on near real-time, it has positive impact in our business

Alternatives Considered

Panoply and Devart ODBC Driver for Oracle

Other Software Used

Google Data Studio, Panoply, Studio 3T, Microsoft Power BI

Hevo - a price fit for non-complex use

Use Cases and Deployment Scope

We extract data from various sources and load into a single SQL warehouse. We extract sources from Facebook, AdWords, Bing and various others. We load roughly 70GB a month and Hevo keeps our data live (or not) depending on our use case. It addresses our ETL issue by simplifying and housing everything in a single tool instead of us writing script/api's and then scheduling ,which is of course the cheaper option but maintenance overhead is not fun.

Pros

  • Extract
  • Load
  • Transform
  • Support

Cons

  • Transformation
  • More Sources
  • More Destinations

Most Important Features

  • Extract
  • Load
  • Transform
  • Price Competitive

Return on Investment

  • Increased Time
  • Decreased Failures
  • Increased User Happiness

Alternatives Considered

Fivetran

Other Software Used

PostgreSQL, Heroku Platform, WhatsApp Business

Hevo - fantastic low cost alternative to Fivetran

Pros

  • 5 Minute Sync with Salesforce
  • Transformations
  • Auto Schema Mapping
  • Push to Salesforce

Cons

  • Support - their support teams try to be helpful, but often miss the mark
  • Error logging - we've run into a few issues debugging errors and limited support is provided by Hevo

Most Important Features

  • 5-Minute Salesforce Sync
  • Transformations
  • Hevo Activate

Return on Investment

  • Saved us 1000s of dollars compared to Fivetran
  • Saved engineering time by using Hevo transformations

Alternatives Considered

Fivetran

Other Software Used

Lucidchart, Tableau Desktop, Atom, dbt (data build tool), from Fishtown Analytics, Google BigQuery