Thank you, I'm currently looking for alternatives to "enterprise" ETL tools.

Most of leading tools are HORRIBLE as programming enviroments and also are incredibly expensive.

Yes. For example, I am convinced that Informatica Powercenter was made by the Devil to bring suffering into the world.

PowerCenter is a piece of shit.

Then that makes it a lot better than some "enterprise" ETL/integration tools I've seen that could only aspire to be pieces of shit.

I recently joined a competitor (SnapLogic). It's a lot nicer IMHO - HTML5 drag-n-drop interface, unified platform for big data, API integrations, IoT etc., and supports executing integrations either in the cloud or on-premise.

Microsoft's SQL Server Integration Services has a lot of adapters and transformations out of the box. The tooling is in visual studio, you can use c# or f#. Warning about f# - you will never want to touch other languages after you try it.

Yeah. It's really friggin good. I highly recommend it. And I'm an entrenched libre open source kinda character.

I recommend reading PACT PRESS' books about Business Intelligence on the Microsoft SQL Server stack. It brings it all together in a fantastic way, example driven.

This looks bad ass, but unfortunately I work with retail data, and retailers don't want any of their data on Amazon. Bummer.

They don't mention the github version anywhere. Is it useable on its own?

You get full control of how and where you run Metabase which means:

    No storage limits, pricing tiers, or caps.
    Your data stays private and on your own servers.

Metabase is nowhere close to being a business-ready BI tool. I wish them luck, but their current product is basically a tech demo compared to the real, commercial products out there -- none of which require you to put your data anywhere in particular either (you can run Tableau against pretty much any DB platform out there).

Oh, I meant the duck thing.