Panoply.io is a cloud data platform providing ETL and data warehousing services for individuals and teams.
Its integration functionality is pretty standard, allowing users to connect data from multiple sources and control how it is collected. For instance, you can manage your destinations, primary and incremental keys, schemas, and how the system handles nested data.
The platform also supports User Defined Functions (UDFs), enabling users to perform advanced data manipulations.
The platform's data warehousing solution makes it a valuable option for users new to data management as they wouldn't need to worry about setting up and connecting to external data warehouses, especially if they're small or medium-sized businesses with minimal data needs. For users who already house their data in external warehouses like RedShift and BigQuery, Panoply.io can connect data sources and deliver them to these destinations. However, this process requires some technical maneuvering.
Panoply.io offers integration with BI and visualization tools so users can generate insights, attribute ROI, and make data-driven decisions faster.
Panoply positions itself as a tool for data engineers, analysts, and scientists. Additionally, Panoply can also be used by business analysts, marketers, product managers, and decision-makers who require access to data insights for informed decision-making.
Thus, the platform can be used for marketing analytics purposes, such as performance tracking, ROI analysis, segmentation, and A/B testing.
A lot of customers complain about Panoply's customer support response time and, in general, about the level of support the team provides during the onboarding and operations. The lack of support means you need to have in-house expertise and IT resources to take care of the platform and make sure the data flows smoothly.
Panoply.io offers three pricing plans: Lite, Basic, and Standard, covering data warehousing and ETL solutions. Every user gets access to unlimited connectors, rows, and users.
Lite costs $399/month, offering a 1TB data warehouse. Basic charges $1089/month with 2TB of data warehouse storage space and the ability to request custom data connectors. Standard costs $1719/month and offers 4TB of warehouse storage, HIPAA compliance, onboarding with a data architect, warehouse and query support, and custom connector requests.
Panoply.io comes fitted with over 300 integrations encompassing data sources, visualization platforms, and ETL tools, among others.
Only users on the top two pricing plans can request custom connectors. However, you can leverage supported APIs and CSV file connectors to integrate data from your custom sources.