Hevo

Hevo is an impressive feature-packed product with great UX

Pros:

1) Self serve product with super UX - we were able to start our pipelines by ourselves within a day 2) Detailed documentation for every source / destination with appropriate up-to-date references 3) Was impressed by the overall speed - after submitting a job to queue, it picks up the job almost immediately 4) Transformation supports Python which is great, data can be manipulated by custom scripts 5) Full visibility and control over the entire pipeline 6) Schema mapper is great, auto-mapping works for most of the use cases. Manual mapping is also possible. It shows and asks user to confirm what query it is going to execute at the destination, which is good 7) Workbench available to run queries at the destination, custom data models available to create "views" from destination tables

Cons:

1) Didn't quite like the limit on number of sources in plans 2) Schema mapper doesn't have an option to change column types at the destination

Happy with Hevo!

Comments: If you need an easy way to bring some data into your data warehouse, I definitely recommend going with Hevo. They are a great value, have good documentation, and are easy to use! We have a small data team so this has saved us a lot of time versus developing custom connectors or dealing with other more complex softwares (such as Informatica, Talend, etc).

Pros:

Good support. Easy to use. Basic connectors and functionality just work. We were able to quickly load several data sources to our Snowflake data warehouse to replace our previous workflows.

Cons:

Some connectors are still in Beta but support is helpful in answering questions and resolving any issues. Also, some things you need to do a certain way for the connector (example - when bringing data in from S3 and FTP you need to have different events in separate folders), but I think the ease of use makes up for that versus a heavier weight software and they add new functionality often.

Good product for small data sets

Comments: Their customer support team is great with quick turnaround time.

Pros:

Easy to setup and no/low code approach is what works for someone just starting with Data engineering.

Cons:

reliability has been a concern with Hevo with downtimes, bugs, corner cases and missed events. It doesn't seem to work well at scale.

Hevo Review

Pros:

1:- Ease of access 2:- Data Integrity 3:- Real time Data Sync 4:- Customer Support

Cons:

1:- Cannot define Dist Style and sort keys in Models while creating Tables on Destination.

One step solution for end-to-end Data transfer

Comments: As a product analyst we signed up for a free trial of Hevo and finds the onboarding process to be straightforward. We used the built-in connectors to connect their data sources to Hevo and create a data pipeline that transfers data from their sources to their data warehouse in real-time. I appreciates Hevo's user-friendly dashboard, automated error handling, and ability to customize and monitor data transfer. After a few weeks of using Hevo, we have noticed a significant improvement in our team's ability to consolidate and analyze data, enabling us to generate reports and insights more quickly and accurately, leading to better business decisions.

Pros:

Simple and Intuitive Interface : Way too easy to use .Seamless Integration with Multiple Sources : Integration with almost every possible tool. Real-time Data Transfer.Automated Error Handling and Also showing where the pipeline is failing and what is the reason behind it.

Cons:

Data transformation needs to have some helping tutorial . Appending data and taking whole data snapshot should have some toggle.