Panoply

Avantages

Query optimization is great and all behind the scenes.
Views automatic materialization is great and enable me to create very complicated views without considering runtime.
support representatives are very responsive and usually very helpful.
In general, very flexible company that always to get better and answers it's clients needs

Inconvénients

Web platform can be built better
Materialization processes have some problem sometimes (downtime) and are not visible properly on the platform

Avantages

It's really easy to start and add various data sources. You can then create connections between data sources and start building custom reports that show you insights and valuable data.

Inconvénients

The biggest con I can think about is the lack of built-in visualization tools. At the moment if you want to see your data visually you must use an external software. Hoping they would get around to adding it soon!

Avantages

Forget about building and maintaining a data warehouse in-house (with all its ETLs).
You can get up and running in just 5 minutes with a lot of pre-built integrations, and amazing customer support.
And with it's flexible pricing model, it makes Panoply a no-brainer for both small and large enterprises.

Inconvénients

The web UI/UX needs more work, it can be slow, and there are many features that are only available on request from the backend (history tables, ssh tunnel for connections, etc.).
The replication frequency is rather limited (down to 1hr only), and the lack of change log replication is a big cons (e.g. MongoDB chagelog or Postgres replication log).

Avantages

I love the service and response time from Alon and crew. They are always on top of it. I also like the materialized views functionality and our custom integration with Twilio.

Inconvénients

I don't like that I can't materialize views in Panoply if I'm not the dbadmin. I also have had frustrations with queries timing out in our data visualization tool, although that's improved recently. I'd also like multifactor auth available in the UI in Panoply.

Avantages

If it worked for our use case I'm sure the product would be great. However our experience was that there was a lot of promises during the sales process but it turned out that we couldn't actually use the product – for reasons on both sides. They insisted that we pay for it for 14 months anyway though.

Inconvénients

Their management team (someone in the C suite) sent some of the rudest emails I have ever received.

When we were unable to use the product because it wasn't able to sufficiently support our use case or have adequate protections for our private/secure data, they went from friendly to incredibly rude and confrontational.

They were unable to accept that a customer who got zero use or value from the product (which they'd be able to demonstrate with internal metrics) wasn't likely to love the product or recommend it to others.