Panoply Pros and Cons

Easy to use and set up new connectors to multiple different sources. Review collected by and hosted on G2.com.

Need more access to analytics around performance of the datawarehouse. Review collected by and hosted on G2.com.

In Panoply, we can perform quick querying & visualization within a few clicks in its intuitive console. We obtain our customer data from various data sources such as Adobe Analytics, Salesforce and Teradata and perform ad-hoc analysis and visualization in Panoply. It's our central data warehouse platform to handle dubious workload ingestion and manage unforeseen spikes in user queries. Review collected by and hosted on G2.com.

Overall, we are satisfied with the data warehouse solutions offered by Panoply. Its pricing models for Premium & Basic services are high compared to other data warehouse platforms. If more cost flexibility is provided, then Panoply can be used by small-scale and mid-scale companies. For having extensive data set requirements & historical load processing, Panoply is suitable. Review collected by and hosted on G2.com.

Panoply has been a very straight-forward and simple-to-use solution to bring together our data. Because of its ease-of-use, we don't spend much time maintaining it or worrying about it. It doesn't get "in the way". Instead, it helps us. Review collected by and hosted on G2.com.

You have to pay attention to whether you really want a particular set or, really subset, of data in Panoply. You have to have a good strategy for that, or you end up consuming too much of your storage and can run the risk of over-running. Basically, you do have to pay attention. Review collected by and hosted on G2.com.

- Ease of Use - Easy to use platform enabled us to get to a proof of concept on our data pipeline in a single day. We were connecting several data sources, some of which were non standard. The platform was able to pull in the data we needed flawlessly for all of the commonly used data sources

- Removed Human Error - The automated system appears well designed and eliminated any human error in our reporting process

- Informed, Effective Customer Service - They had BI Analysts /Data Scientists on staff who were able to jump in and create custom connections to some of our nonstandard data sources. They even offered to help with some of the data blending that we were doing. This effectively lowered the bar and shortened the time to value for our organization Review collected by and hosted on G2.com.

Have very little bad to say about the product and team. Their product is a bit on the expensive side but it is certainly worth the cost to have professionals able to trouble shoot any issues that may arise Review collected by and hosted on G2.com.

Panoply reduced our reliance on manual input by a very wide margin. In turn, this increased our confidence in data by cleanly aggregating and storing multiple datasets from multiple tenets, removing user-errors and greatly reducing the associated need for time-intensive Q&A of manual inputs. The end result is that Panoply freed up team resources to focus on what they do best - provide meaningful insights to promote change and decision-making both internally and with our clients. Review collected by and hosted on G2.com.

Their customer service has improved since our onboarding considerably. It's clear they've made strategic investment here. Our reps were hands-on and very communicative as our data needs changed and shifted with company scale, both up and down. Review collected by and hosted on G2.com.

We are using for example in extract all information related with mondodb, postgresql, fb Ads, Google Ads and other sources for example s3, the easy of use of this tool is amazing just connect and mapping the sources and destination Review collected by and hosted on G2.com.

Could be the pricing model, we noticed that another tools like airbyte or another open source could be more cheaper than panoply in any aspects, this one of the reason I dislike panoply Review collected by and hosted on G2.com.

The promise of Panoply and its functionality, when it works, is quite good. The ability to quickly sync data from various sources into a data warehouse is certainly valuable, and what they promise has a good deal of business value. Unfortunately, what is inputted into the UI does not always result in the expected output so their value proposition is nothing more than a broken promise now. Review collected by and hosted on G2.com.

Where to start... support team has an "average response time of 1 day" according to their Intercom widget. In reality, it can be several days to receive and follow-up at all and then when you do hear from them, they rarely have solutions. I have a Facebook Ads connector that has been broken for weeks and I've re-configured 5 times as they instructed and still it won't pull in historical data. They don't follow-up proactively or provide updates on issues at all. The issues with the platform have cropped up since they were acquired by an Israeli company which, from a user perspective, has clearly not invested enough into the Panoply software or support team. AVOID this platform! Whatever cost savings you think you might get will be lost in the hours spent banging your head against the wall waiting for them to fix their faulty platform. You'd be better off with literally any other solution. I was a Panoply user for years and finally have convinced our CFO to ditch Panoply due to their many failures. Review collected by and hosted on G2.com.

The platform is *extremely* easy to set up with reliable data ingestion from lots of commonly needed data sources, and where they're missing, the customer support team's work has exceeded our expectations. Review collected by and hosted on G2.com.

Documentation is lacking in certain places, though that's made up for by customer support. Review collected by and hosted on G2.com.

I don't have to worry about the day to day care and feeding of the database. Review collected by and hosted on G2.com.

The number of data sources can be better, but they are very responsive when requesting adding new ones. Also, their generic connector they developed is working well. Review collected by and hosted on G2.com.

Speed, Easy

No need for a DB Admin

Good support

Good connections with existing tech stack Review collected by and hosted on G2.com.

When deleting existing tables, 'view dependences' is not always clear on the prompt. Need to run a separate view dependencies query to extract dependent views. Review collected by and hosted on G2.com.