Hevo

Excellent Data Pipeline

Comments: It was very easy to sign up and set up Facebook to BigQuery. The user UI is easy to use and step-by-step instructions are included. You don't need a dev to get things moving as long as you're passingly familiar with Facebook and BigQuery and can read directions.

Pros:

I used Hevo to pipeline data from Facebook into Big Query. The service worked as expected and properly transferred my data. It was one of several services I evaluated for our data pipeline needs.

Cons:

I had some integration needs that HEVO did not include, so I had to go with another provider who included those. Otherwise, HEVO was amongst my top choices.

Hevo Data saved us

Pros:

Hevo Data saved our company in more ways than one. For the bi-directional Hubspot features alone, this tool is worth the cost for us, hands-down. We were able to pull all of our Hubspot data into our data warehouse, annotate, and push back to custom properties and objects. The tool worked so well, we began using it as the core ETL connector for our data lake, and are testing as our scheduled task manager for the core transformations for our data warehouse. The pricing model has worked out well for us. The free trial to prototype how the thing works, and how we could be efficient with our usage of connectors, has also been wonderful.

Cons:

THe list of connectors is really good, but not 100% where we wish. In addition, migrations from one tool to another (e.g. Intercom -> Hubspot) require us to do a bunch of manual mapping that is hard; other tools have these mappings canned and are therefore easier to use for that use-case.

Alternatives Considered: Zapier and Help Desk Migration

Reasons for Choosing Hevo: This tool is much more powerful, cost-effective and aligned with our needs.

Switched From: Zapier

Reasons for Switching to Hevo: We are using Hevo Data in conjunction with Help Desk Migration, which does the mapping we need for us.

Good Product

Pros:

I really like the ease with which you can deploy the tool

Cons:

The tool can get better in documentation and video tutorials.

Hevo data for Extraction and Loading to Snowflake

Comments: Very Pleasing. I set it up once and I don't have to worry about it again.

Pros:

Simple and effective hassle free table syncing between Cloud VM SQL Server and Snowflake DWH.

Cons:

Getting Hevo white listed with other vendors such as FTP sites is the first big hurdle. Sometimes I'd like to have it sync a view from my source system but it struggles with this. Instead I make it sync the source tables of the view.

Alternatives Considered: Fivetran

Reasons for Switching to Hevo: Simple ease of use. It does what it says it does.

The best Data Extraction service for Startups

Comments: Hevo was the ideal tool that I needed to bootstrap our data infrastructure. As the person who set everything up I am very satisfied with them and hope that this will be a long partnership.

Pros:

Hevo is very easy to set up (the whole process is self explanatory) and has a lot of integrations. It also allows for a lot of flexibility with Rest API and Webhook integrations. The UI is very well tought out and the whole product feels professional. I should also point out the Consumer Service, which is great and very helpfull. I get answers every time I talk to them, and I feel my problems are being taken seriously.

Cons:

Hevo doesn't allow precise control of the Ingestion and Loading frequency and times. You can only choose a frequency or specify certain times, but even this one is limited to a certain number of runs. This is our only limitation with Hevo right now.