1 million+ businesses helped. Get advice
Get Free Advice
Home

/

Data Warehouse Software

/

Panoply

Overview
Alternatives

Panoply 2026: Benefits, Features & Pricing

Software Advice offers objective insights based on verified user reviews and independent product and market research. When our advisors match you to a software provider, we may earn a referral fee.

How Software Advice ensures transparency

Software Advice lists all providers across its website—not just those that pay us—so that users can make informed purchase decisions. Users can talk to our advisors for free to receive software recommendations matching their needs. Software providers pay us for sponsored profiles to reach users interested in their products.

How Software Advice verifies reviews

Software Advice carefully verified over 2 million reviews to bring you authentic software experiences from real users. Our human moderators verify that reviewers are real people and that reviews are authentic. They use leading tech to analyze text quality and to detect plagiarism and generative AI.

Independent research methodology

Researchers at Software Advice use a mix of verified reviews, independent research, and objective methodologies to bring you selection and ranking information you can trust. While we may earn a referral fee when you visit a provider through our links or talk to an advisor, this has no influence on our research or methodology.

Wondering if Panoply is right for your organization?

Our Data Warehouse Software selection experts can help you in 15 minutes or less.

On this page
  • Overview
  • Pricing and Plans
  • Features
  • Integrations
  • User Reviews

Overview

Panoply
Panoply
4.0
(21)

Pricing

Starting at $499.00 per month

About Panoply

Panoply is a cloud data platform that helps businesses source, store and manage data from various applications to streamline data analysis processes. Professionals can track the status of data sync as ‘running’, ‘pending’ or ‘scheduled’ and automatically detect data types.

Panoply helps business users sync, store, and leverage all of their data, without complicated code. Drive insights fast by building a single source of truth for all your reporting needs.

Panoply enables businesses to integrate the platform with various third-party applications, such as HubSpot, Google Analytics, Shopify, BigQuery and more.

Panoply Screenshots

0
0
1
2

Panoply Pricing and Plans

Starting price: $199.00
Free Trial
Free Version

Starter

$199.00

flat rate

No plan information available

    Lite

    $499.00

    flat rate, per month

    No plan information available

      Standard

      $799.00

      flat rate, per month

      No plan information available

        Premium

        $1,199.00

        flat rate

        No plan information available

          Advisor Get Price CTA Image

          Confused about pricing? We've got you covered.

          Get a personalized pricing breakdown tailored to your specific needs—no guesswork, no generic estimates.

          Panoply Features

          • Popular features found in Data Warehouse
            Data Capture and Transfer
            Data Connectors
            Data Extraction
            Data Integration
            Data Migration
            Data Quality Control
            ETL - Extract Transfer Load
            In-Database Processing
            Multiple Data Sources
            Reporting/Analytics
          • More features of Panoply
            Ad hoc Query
            API
            Customer Database
            Dashboard
            Data Analysis Tools
            Data Blending
            Data Cleansing
            Data Discovery
            Data Security
            Data Storage Management
            ETL
            Job Scheduling
            Master Data Management
            Match & Merge
            Metadata Management
            Natural Language Search
            Non-Relational Transformations
            Search/Filter
            Secure Data Storage
            SSL Security
            Third-Party Integrations

          Panoply Integrations

          JIRA Service Management
          JIRA Service Management
          Mailchimp
          Mailchimp
          Salesforce Platform
          Salesforce Platform
          Typeform
          Typeform
          Dropbox Business
          Dropbox Business
          Intercom
          Intercom

          See all 37 integrations

          Panoply User Reviews

          Overall Rating

          4.0

          Ratings Breakdown

          5

          43%

          4

          33%

          3

          14%

          2

          5%

          1

          5%

          Secondary Ratings

          Ease of Use

          4.2

          Value for money

          4.1

          Customer support

          4.3

          Functionality

          3.8

          Have you used Panoply and would like to share your experience with others?

          Nathan Patrick's profile

          Nathan Patrick T.

          Verified reviewer

          Health, Wellness and Fitness

          5001-10000 employees

          Used weekly for less than 6 months

          Review source

          Reviewed April 2020

          Panoply gets the job done!

          5

          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.

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          4
          Functionality
          icon
          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.

          Reasons for choosing Panoply

          The price was perfect and the features met our needs.

          Reasons for switching to Panoply

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

          Read More

          JG

          Julian G.

          Verified reviewer

          Hospital & Health Care

          51-200 employees

          Used daily for less than 2 years

          Review source

          Reviewed July 2022

          Excellent starting option for data warehousing

          4

          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.

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          4
          Functionality
          icon
          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.

          Reasons for choosing Panoply

          much more simple to set up and manage. Reliable monthly cost was easier to get buy in from management

          Read More

          ms

          matt s.

          Verified reviewer

          Computer Software

          2-10 employees

          Used daily for less than 12 months

          Review source

          Reviewed August 2021

          Customer service is great until you cancel

          3

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

          Ratings Breakdown

          3
          Ease of use
          1
          Value for money
          2
          Customer support
          3
          Functionality
          icon
          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.

          Vendor Response

          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.

          Replied August 2021

          Read More

          Saurav's profile

          Saurav C.

          Verified reviewer

          Environmental Services

          5001-10000 employees

          Used weekly for less than 2 years

          Review source

          Reviewed April 2020

          Helped me immensely with analyzing netcdf data files

          5

          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.

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Functionality
          icon
          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.

          Reasons for switching to Panoply

          The procedure for the option was simpler and also Panoply gave me the option to visualize the data that I could not do with Fortran 77

          Read More

          Adir's profile

          Adir R.

          Verified reviewer

          Used daily for more than 2 years

          Review source

          Reviewed May 2018

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

          5

          Ratings Breakdown

          4
          Ease of use
          5
          Value for money
          5
          Customer support
          4
          Functionality
          icon
          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!

          Read More

          VR

          Verified
          Reviewer

          501-1000 employees

          Used daily for less than 6 months

          Review source

          Reviewed May 2018

          The power of a data warehouse in minutes

          4

          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.

          Ratings Breakdown

          4
          Ease of use
          5
          Value for money
          5
          Customer support
          3
          Functionality
          icon
          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).

          Read More

          HS

          Hugh S.

          Information Technology and Services

          11-50 employees

          Used other for less than 2 years

          Review source

          Reviewed August 2018

          Never worked for us, management incredibly rude and confrontational

          1

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

          Ratings Breakdown

          2
          Ease of use
          1
          Value for money
          1
          Customer support
          2
          Functionality
          icon
          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.

          Read More

          Rory's profile

          Rory B.

          Verified reviewer

          Entertainment

          11-50 employees

          Used daily for less than 12 months

          Review source

          Reviewed July 2018

          The best managed AWS solution

          5

          Ratings Breakdown

          4
          Ease of use
          5
          Value for money
          5
          Customer support
          4
          Functionality
          icon
          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.

          Read More

          Jacklyn's profile

          Jacklyn A.

          Verified reviewer

          51-200 employees

          Used weekly for less than 12 months

          Review source

          Reviewed January 2018

          The easiest way to get started with data management.

          4

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

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          4
          Customer support
          3
          Functionality
          icon
          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.

          Read More

          VR

          Verified
          Reviewer

          Computer & Network Security

          11-50 employees

          Used monthly for less than 12 months

          Review source

          Reviewed February 2019

          Panoply Makes Warehousing Easy for Most Users

          5

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

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          4
          Functionality
          icon
          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.

          Read More

          Showing 1 - 10 of 21 Reviews
          Load More Reviews

          Other Top Recommended Data Warehouse Software

          Logi Symphony
          Logi Symphony

          4.5 (258)

          Recently recommended 5 times

          Grow
          Grow

          4.4 (400)

          Recently recommended 4 times

          Hevo
          Hevo

          4.7 (110)

          Recently recommended 1 times

          Funnel
          Funnel

          4.7 (19)

          Recently recommended 1 times

          Advisor Get Price CTA Image

          Stuck Between Options?

          Our experts can help you compare Panoply with other top options, so you can find the best fit for your needs.

          See what companies are saying about Software Advice