18 years helping British businesses
choose better software

What is Panoply?

Focus on analysis, not tedious data tasks. Panoply combines code-free data connectors with built-in storage, making it the easiest way to sync, store, and access all your business data.

Key features of the Panoply platform include:
-Code-free data integrations for seamless syncing
-Automated data warehouse configuration
-Connections to all major BI and analytical tools
-Industry-leading onboarding and support

Who Uses Panoply?

Data analysts, engineers, architects & scientists responsible for availability/usability of disparate data. Business users and strategists who need to generate insights

Where can Panoply be deployed?

Cloud-based
On-premise

About the vendor

  • Panoply
  • Located in San Francisco, US
  • Founded in 2015

Panoply support

  • Phone Support
  • Chat

Countries available

Australia, Brazil, Canada, China, Germany and 5 others

Languages

English

Panoply pricing

Starting Price:

US$199.00
  • Yes, has free trial
  • No free version

Panoply does not have a free version but does offer a free trial. Panoply paid version starts at US$199.00.

Pricing plans get a free trial

About the vendor

  • Panoply
  • Located in San Francisco, US
  • Founded in 2015

Panoply support

  • Phone Support
  • Chat

Countries available

Australia, Brazil, Canada, China, Germany and 5 others

Languages

English

Panoply videos and images

Panoply Software - 1
Panoply Software - 2
Panoply Software - 3
Panoply Software - 4
Panoply Software - 5
View 6 more
Panoply video
Panoply Software - 1
Panoply Software - 2
Panoply Software - 3
Panoply Software - 4
Panoply Software - 5

Features of Panoply

  • API
  • Customer Database
  • Data Analysis Tools
  • Data Capture and Transfer
  • Data Cleansing
  • Data Connectors
  • Data Discovery
  • Data Integration
  • Data Migration
  • Data Quality Control
  • Data Security
  • ETL - Extract Transfer Load
  • Master Data Management
  • Match & Merge
  • Metadata Management
  • Reporting/Analytics
  • Search/Filter
  • Third-Party Integrations

Alternatives to Panoply

Try for free! Data analytics lets data analysts and business teams collaborate with Notebooks, visualizations, reports & dashboards.
Data exploration and analytics solution combining modeling, transformations, and derivations at the same layer.
SAP HANA Cloud is a multi-model database system enabling users to build and deploy intelligent data applications at scale.
Azure Synapse Analytics is a cloud data warehouse that provides limitless analytics and accelerated time to insight.
Snowflake empowers the Data Cloud, fostering global data connectivity and collaboration across diverse scales and types.
It is predictive analysis that helps businesses analyze data across data lakes, operational databases, data warehouse, and more.
BigQuery is a serverless, multicloud data warehouse designed to help you turn big data into valuable business.
ZEMA Global enables organizations to meet all their data management objectives, including those related to risk, trade, analytics...
Centralpoint outranks MS/Sharepoint as a secure knowledge management solution for leading organizations

Reviews of Panoply

Average score

Overall
4.0
Ease of Use
4.2
Customer Service
4.3
Features
3.8
Value for Money
4.1

Reviews by company size (employees)

  • <50
  • 51-200
  • 201-1,000
  • >1,001
Nathan Patrick
Nathan Patrick
Chief Information Officer in US
Verified LinkedIn User
Health, Wellness & Fitness, 5,001–10,000 Employees
Used the Software for: 1-5 months
Reviewer Source

Panoply gets the job done!

5.0 5 years ago

Comments: The support team behind Panoply is very helpful. We've used the on-site chat function to get immediate help. We've also submitted questions through traditional routes like email. All of which were answered quickly.

Pros:

The speed to solution is a big win for us. We were able to get a full data pipeline up in running in less than half a day. That's with various data sources and incremental refresh. The UI is easy to use.

Cons:

There aren't really any cons. The platform is in its infancy and I can tell that the team is listening to user feedback and already making updates.

Alternatives Considered: Azure Synapse Analytics, Looker, Mode and SAP HANA Cloud

Reasons for Choosing Panoply: Snowflake was too costly and still required in-depth coding and platform knowledge to quickly spin up a data pipeline.

Switched From: Snowflake

Reasons for Switching to Panoply: The price was perfect and the features met our needs.

Julian
Analytics Engineer in Canada
Hospital & Health Care, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

Excellent starting option for data warehousing

4.0 3 years ago

Comments: Was the foundation of my last company's BI pipeline and served us very well. Now they are going through a painful migration from the old Redshift servers to BigQuery and the cost has tripled. Before I left I was undergoing a migration to BigQuery natively and skipping Panoply as it began to add complexity for us rather than take it away.

Pros:

Very simple to set up and manage. Still all the core functionality you need in a warehouse

Cons:

The built in data connectors could be buggy. Particularly Google Analytics with multiple accounts. Integrating with Google Data Studio was also frustrating as we couldn't find a way to share dashboards within our workspace.

Alternatives Considered: Amazon Redshift, Google Cloud BigQuery and Snowflake

Reasons for Switching to Panoply: much more simple to set up and manage. Reliable monthly cost was easier to get buy in from management

matt
CEO in US
Computer Software, 2–10 Employees
Used the Software for: 6-12 months
Reviewer Source

Customer service is great until you cancel

3.0 4 years ago

Comments: Decent product, overpriced for it's function, the support team and customer service team need to get their act together.

Pros:

We used Panoply to ingest DynamoDB data and send it to the analytics platform for intellegence. The software worked and functioned fine, our we had a simple use case, but it never failed us.

Cons:

The pricing was really steep for our simple use case and didn't bring the value that the price tag suggests. Ultimately we found a service that is 40% the cost that suites our needs. When I went to cancel there is no unsubscribe button, I had to hunt for a cancellation email address. After going back and forth with the director of customer service, I finally got it cancelled. However, they threw a 30-day notice clause at us causing us to pay an extra 50 days for a product we are not using. Really bad form in my opinion.

Panoply Response

3 years ago

Hi Matt, Thank you for your review. We value feedback from all of our customers. I am glad that you had a good experience with our platform and that our platform allowed you to get some insights. I am sorry about your experience with the cancellation process. While we are disappointed when one of our customers leaves, we aim to make the process as simple as possible by following the terms of the signed contract. One of the terms is our requirement to provide 30 days' notice before the next renewal date. We state this in our terms and conditions but apologize for any misunderstanding, and we will work to make that part of the agreement clearer. We wish you all the best and hope that we can work together in the future.

Saurav
Saurav
Research Assistant in US
Verified LinkedIn User
Environmental Services, 5,001–10,000 Employees
Used the Software for: 1+ year
Reviewer Source

Helped me immensely with analyzing netcdf data files

5.0 5 years ago

Comments: I am working with Geographical data that has latitudes, longitudes and a variable I am trying to analyze. This is a great tool to have for such data structure.

Pros:

I was introduced to Panoply by a colleague. I was trying to analyze a bunch of climate variables that were in netcdf format. Before I could write a code in Matlab to analyze the data, I needed to know the data structure. For this I have used a combination of F77 and Matlab in the past. However, I wanted to exclude Fortran and have a more convenient way of knowing the basic data structure. Matlab was more powerful with the actual analysis but not with the pre processing. This is where Panoply came in handy. All I had to do was upload the netcdf data file directly into panoply and boom. It gave me the basic structure that includes the number of data points, latitudes and longitudes of the data points and other essential details I needed.

Cons:

I did not come across any problem in particular for the 2+ years I have used Panoply. Sometimes, It did take a little long to load it if the netcdf file I was working with was a large file but it was not a big deal. Panoply actually was immensely helpful in knowing the data structure of the variable type for which I followed a much more complex procedure in the past before I used Panoply.

Adir
Adir
Co-Founder & CEO in Israel
Verified LinkedIn User
Used the Software for: 2+ years
Reviewer Source

A great service to connect all your data sources to and analyze them together

5.0 7 years ago

Pros:

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.

Cons:

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!

Verified Reviewer
Verified LinkedIn User
, 501–1,000 Employees
Used the Software for: 1-5 months
Reviewer Source

The power of a data warehouse in minutes

4.0 7 years ago

Comments: I managed to setup the data warehouse for a large company (3000+ employees) in just a couple of months (mainly getting accesses and defining which sources to use).
Not only we are saving money from other un-managed solutions, but we are also saving from the development and maintenance time required to build an in-house solution.

Pros:

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.

Cons:

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).

Hugh
Founder in UK
Information Technology & Services, 11–50 Employees
Used the Software for: 1+ year
Reviewer Source

Never worked for us, management incredibly rude and confrontational

1.0 6 years ago

Comments: I would not recommend doing business with their company unless you have a ridiculously simple use case (for example, our use of nosql databases seemed to be outside their typical use case) and you are OK with their management team being rude and unhelpful. (The support team seems friendly enough but struggles to handle complex cases or smaller ACVs from our experience).

Pros:

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.

Cons:

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.

Rory
Rory
Performance Marketing Director in UK
Verified LinkedIn User
Entertainment, 11–50 Employees
Used the Software for: 6-12 months
Reviewer Source

The best managed AWS solution

5.0 7 years ago

Pros:

For our purposes, they worked out cheaper than an out-of-the-box AWS integration, but they offered ELT and excellent customer support as a bonus.

Cons:

They don't have as many ELT connectors as companies like Fivetran and Stitch, but what they do have works very effectively.

Jacklyn
Jacklyn
CRM & Digital Strategy Manager in US
Verified LinkedIn User
, 51–200 Employees
Used the Software for: 6-12 months
Reviewer Source

The easiest way to get started with data management.

4.0 7 years ago

Comments: Was able to stop leaking data and made it easily accessible without going into sticker shock.

Pros:

Panoply is easy to use and doesn't require a lot of work to get started. Without a database manager I was able to connect and save all of my data. Able to use SQL instead of crashing my computer for reports and segmentation.

Cons:

Organizing folders can be difficult if you didn't plan ahead because you can't select more than one at a time. Also difficult to search for information and it is slow when going in and out of folders.

Verified Reviewer
Verified LinkedIn User
Computer & Network Security, 11–50 Employees
Used the Software for: 6-12 months
Reviewer Source

Panoply Makes Warehousing Easy for Most Users

5.0 6 years ago

Comments: Overall, Panoply is a great option for short-term or non-technical projects, but may not be best for more advanced teams.

Pros:

Panoply finally offers non-technical users an easy and affordable way to warehouse data, pipe it to the right tools, and not deal with the hassle of new warehouse creation, view generation, or ETL. The interface is intuitive enough to not need support during setup, and data is accurately reflected in the warehouse within hours. Several adaptors to other services are supported out of the box.

Cons:

Panoply works well for limited warehousing applications, but if you have technical resources available and/or need good long-term storage, other warehousing solutions may be best. Panoply has many native cloud integrations, but several require 3rd party solutions like Stitch, increasing cost and complexity.

Noam
Data Analyst in Israel
Information Technology & Services, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Panoply is a great product that helps in WH management as well as optimization.

4.0 7 years ago

Pros:

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

Cons:

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

Verified Reviewer
Verified LinkedIn User
Consumer Goods, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

Redshift without the Maintenance

5.0 7 years ago

Pros:

This is the perfect solution for those who want to use amazon redshift but don't want to manage a cluster. Panoply automagically creates indexes and optimizes your DB as you add data

Cons:

The software is still new, so I occasionally run across a bug or 2. These are typically minor and fixed quickly.

Elana
Customer Success Manager in US
Information Technology & Services, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

Easy to set up and maintain VPC

4.0 5 years ago

Pros:

Panoply is very easy to set up and entirely obfuscates the ETL process.

Cons:

When I had issues with data loading it was very difficult to troubleshoot and had to talk to support many times and eventually also a data architect.

Robert
Group Product Manager in US
Hospital & Health Care, 11–50 Employees
Used the Software for: 6-12 months
Reviewer Source

Great service and response time, queries timeout sometimes.

4.0 7 years ago

Comments: ETL from Mongo to Redshift, ability to integrate with data from many internal tools (Mixpanel, Twilio, ZenDesk, Asana, etc.), running performance-intensive queries.

Pros:

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.

Cons:

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.

Verified Reviewer
Verified LinkedIn User
Computer Software, 51–200 Employees
Used the Software for: 1-5 months
Reviewer Source

Great product for jumpstarting your BI infrastructure.

4.0 7 years ago

Comments: We were able to get our BI infrastructure up and running quickly and at a good value.

Pros:

- Can run Redshift without needing a DBA -- Panoply does it for us. - Access to a data architect for assistance.

Cons:

- No alerts for if a job fails. - Limited number of connectors. Have to bridge the gap with other software.

Alejandro
Alejandro
Head Of Information Technology in Mexico
Verified LinkedIn User
Used the Software for: 6-12 months
Reviewer Source

Very easy to set up, connect to our services and consume the data. I love their customer support.

5.0 7 years ago

Pros:

- Ease of setting up - Simplicity - Customer service is very close every trimester - Integrations to other platforms

Cons:

At the begining it was hard to conect to Microsoft Azure and the development of this took time, after this, everything were as expected

Verified Reviewer
Verified LinkedIn User
Internet, 51–200 Employees
Used the Software for: Free Trial
Reviewer Source

Great for non-engineers

2.0 6 years ago

Pros:

Panoply has a LOT of connectors to third-party tools

Cons:

Does not support common formats like Parquet, making it clear that this was built for non-engineers

Verified Reviewer
Verified LinkedIn User
Computer Software, 2–10 Employees
Used the Software for: 1+ year
Reviewer Source

Good product; among the worst service I have every encountered

3.0 5 years ago

Pros:

Easy to setup, with minimal technical skill required.

Cons:

Tricky renewal process and absolute inflexibility. Charged us for an additional 12 month contract for unused product after auto-renewal. Product generally good, but I would caution to watch billing like a HAWK.

Panoply Response

5 years ago

Sorry you had this experience. We are always striving to improve and appreciate the feedback.

Verified Reviewer
Verified LinkedIn User
Used the Software for: 6-12 months
Reviewer Source

Signing on with Panoply is like getting a whole engineering team's worth of output for cheap

5.0 7 years ago

Comments: The ability to manage our data in one central store.

Pros:

It does something that is sorely needed in the market -- a way to manage large amounts of data in one central store without needing tons of in-house expertise. Getting set up could not have been easier and working with data in Panoply is easy. I have no regrets about signing up.

Cons:

Redshift SQL is a little bit annoying, but that has nothing to do with Panoply and their service. It will be interesting to see if they expand to other warehouses in the future.

Franklin
Software Engineer in US
Used the Software for: 1-5 months
Reviewer Source

It's great but it's sluggish

3.0 7 years ago

Pros:

I like that it is easy to use. It is incredibly easy to navigate around. It allows you essentially to browse without using strict SQL queries. As we are trying to integrate the product for use with our non technical team, this is incredibly important. They are not particularly well versed in tech or code or any of the sort, but they can understand panoply. Trying to grapple with SQL data directly would be fairly impossible. Panoply allows us to level to playing field and bring this over to all users and simplify the entire process as well as not provide us with the ability to not expose the direct data that customers are using directly.

Cons:

I have not used the product in a couple weeks, but at the time panoply was incredibly slow. Whenever I attempted to use the product in any way shape or form, it took an incredibly long time for it to deliver any data that I was looking for. It was actually surprising how long it would take and I actually spent some time troubleshooting my local network as a result (which I've found not to be the issue). My colleague has since informed me that this is no longer the case, so I'm definitely willing to give it another go, but my impression at the moment unfortunately still stands at this present time.

Teja
BI Engineer in US
Computer Software, 51–200 Employees
Used the Software for: 1-5 months
Reviewer Source

Best Value for Money

5.0 7 years ago

Comments: We could gain the insights we are looking from various sources using Panoply

Pros:

Panoply is the best investment we have made so far. For a company our size(100-200 employees), and a company that cannot invest too much money in BI infrastructure yet, Panoply not only maintains the infrastructure but also provides the best customer support and data architect to gain insights from various sources. I have already recommended panoply to a few of my contacts.

Cons:

Restriction on the number of admins to 1.