Integrate.io

ETL for agile analysts

Comments: There are mostly two types of ETL as a service on the market: one is super easy to use and can migrate your data across services and databases but lacks transformation capabilities, while the other needs full-time data engineers to operate but tailored solutions are available programmatically. Xplenty sits in the golden middle letting analysts and engineers deploying custom transformation jobs in minutes even based on multiple data sources. The UI is intuitive but you can always use SQL to filter your sources or to create new sets in scheduled packages. Also, there are plenty of built-in functions available. Running costs are not comparable of running your own services on Heroku or Google cloud but its intuitive features save a lot of engineering hours. I would recommend Xplenty for agile teams having multiple sources of data where data analysts frequently needs custom datasets to deliver insights.

Pros:

- wide variety of sources and destinations - visual editor makes creating packages quick and easy - SQL transformations - great, quick, responsive support - free unlimited hours of sandbox - Slack integration

Cons:

- expansive for hourly jobs - error logs are not always informative - transforming JSON or other nested data is not trivial

No-SQL to SQL

Pros:

We have a complex and highly nested no-sql DB. Xplenty was the only ETL solution that allowed us get out data into tabular format for analysis

Cons:

None. Its been great. Haven't had any issues.

No code ETL pipelines

Comments: We stopped using xplenty when we started creating complex pipelines which required joined across data schemas.

Pros:

Drag and drop interface easy to use for simple pipelines. Coding skills not needed to create and setup a pipeline. Very prompt support.

Cons:

The same drag and drop interface becomes extremely tough to use for complicate pipelines. Deployment of pipelines quite confusing.

Highly recommend

Comments: My entire team loves it. Our rep actually goes out of his way to meet with us quarterly even years after set up to make sure we are aware of all the enhancements. You can use the product whether you are tech savvy or not. It is necessary for our tech stack to work.

Pros:

I like the ease of use. We have never ran into a problem with it. And if we have a question their support is AMAZING!! They actually teach you how to use it and don’t just send you an article. I love their business support model. More companies should do it!

Cons:

I actually don’t dislike anything about it. It’s the only tech solution I have no complaints about which doesn’t ever happen..

Great ETL solution with responsive technical support

Comments: One of the key benefits is how technically capable their support staff is. They do a great job supporting a technical product.

Pros:

We used Xplenty for 3 years as our ETL. It was easy and flexible to setup and was the only solution on the market that could handle MongoDB to Redshift with a very nested structure.

Cons:

Nothing I disliked. When we had an ETL (now on ELT) it was great and exactly what we needed.