What do you like best about the product?

Shopify data is quite complex. Hevo makes it all accessible in an easy to use format in which you select the fields you want from each table. The user interface is easy to use and thorough, with appropriate defaults if you don't need to get into field mapping, etc.

One big benefit for us is that Hevo does not include a database and is priced less because of it. We already have a database and wanted to populate that vs. paying for storage and having to replicate.

We had occasion to use their support a few times; twice for things that were actually our errors in understanding the data and once for an issue with a name field that was a reserved name in Azure Analysis Services. They quickly troubleshooted the problem, provided a workaround using mapping, and will resolve the issue for future customers. Support is *very* responsive and sends status messages every day.

We have the capabilities in-house to build datalflows like this, but Hevo makes it very easy, very fast, and very configurable. Using them is worth the savings in understanding the intracacies of complex APIs.

FYI, we integrated with Synapse Analytics first, but it required a full time SQL pool that we just did not need for our use case. We then switched to Azure SQL Serverless and the product worked fine with that.

If you notice that we are not a current user, that is because we had to develop Azure Data Factory pipelines for other purposes and decided to do Shopify ourselves. If we were starting again from scratch, I would use Hevo instead, especially if I needed any of the other data sources they support.

What do you dislike about the product?

The lack of a database could be an issue for some potential customers. The product is very attractive to people who won't build API interfaces, but it does require a bit of technical setup of a database, primarily because Shopify data cannot be queried quickly. Some products include this, but they are much more expensive. Also, if you don't need a database on your end now, you may well need one in the future and should consider going this route.

I'm giving them an N/A for security because I didn't deep dive on it. All interactions with them have respected security (e.g. they ask for permission for their support staff to access your data), but I didn't evaluate their business practices.

What problems is the product solving and how is that benefiting you?

Getting data out of Shopify and into our Business Intelligence system.