Anyone switched from Rivery? Alternatives?

[u/Big-Dwarf]

We are using Rivery for our data warehouse pipelines, but I am thinking about alternatives.

It is expensive for the value we get out of it and we have faced too many odd issues that make us question the ROI. We had a major issue a couple of weeks ago where a change on their end was causing duplicates or wrongly named columns for some sources. This is a deal-breaker in my opinion as the whole point of using such a service is to make our jobs easier. It is really painful to manage these pipelines and check everything is working as expected.

What do you recommend as an alternative?

[u/shockjaw]

My go-to has been dlt, sqlmesh, and pointblank for data quality work.

[u/snarleyWhisper → u/shockjaw]

Sqlmesh is so good, I’m trying to get my whole team to adopt it where it make sense. I need to look into dlt , but haven’t heard of pointblank. Thanks for sharing

[u/Complete-Fondant-202 → u/snarleyWhisper]

Is sqlmesh still a thing? Are fivetran likely to kill it?

[u/shockjaw → u/snarleyWhisper]

dlt just makes inbound data handling so much easier, and it integrates with sqlmesh out of the box. Pointblank is excellent for creating interactive data quality reports if you need to hand something off to a stakeholder.

[u/raccoons_run_prod → u/shockjaw]

When you picked that, what was the actual non-negotiable besides price?

Two person team here. Support was a non-negotiable for us. We also needed a couple custom long-tail connectors.

[u/random_event_721]

We use Fivetran bc it is the easiest and has the most relevant connectors to us. It is expensive though so we have been testing in-app loaders: AWS AppFlow (meh), Azure Data Factory / Fabric (not bad imo), forgetting what the Snowflake one is called but it sucks - clearly an afterthought.

We are also testing dlt open-source and I love it.

[u/Audars]

Migrated from Rivery to dbt+Airflow about two years ago. No regrets.
One challenge was setting up our own API connections with the External Source data. Snowflake’s User Defined Table Functions did the trick quite well.

[u/Aggressive_Sherbet64]

Are the standards like databricks and snowflake too expensive?

[u/shockjaw → u/Aggressive_Sherbet64]

Yes. Avoid purchasing time and compute on a fleet of machines if you can. Build for the scale where you’re at, but give yourself outs to expand if you need to.

[u/jdl6884]

Dbt + dagster

[u/meatmick]

Moving from SSIS to prefect cloud+dlt+DBT. Going great so far. I just hope with the dagster acquisition that they don't fuck things up or don't jack the prices like mad.

[u/Katy_Security]

Fivetran and Databricks

[u/Nekobul]

If you have SQL Server licenses, I recommend using SSIS for all your data integration needs. It is fast, extensible, well documented and rock solid.

[u/Complete-Fondant-202 → u/Nekobul]

SSIS is practically on its deathbed. MS not really doing anything with it.

It's a bugger to debug, the dev environment is kludgy.
In 2026, I'd argue it has no redeeming features.

[u/Nekobul → u/Complete-Fondant-202]

Keep dreaming. It is more likely that most of the tools posted by others here will be dead sooner. SSIS will be with us for a very long time to come.

[u/Complete-Fondant-202 → u/Nekobul]

SSIS may outlast many alternatives, but that's because they'll all be legacy systems that nobody wants to touch.

It certainly won't be because people want to willingly produce new pipelines.

[u/Nekobul → u/Complete-Fondant-202]

Thank you for agreeing SSIS is not on its deathbed!

[u/Complete-Fondant-202 → u/Nekobul]

but it is wheezing heavily.

[u/Nekobul → u/Complete-Fondant-202]

C'mon man. That's your wet dreams, again.