Singer is an open source tool that helps bring order to the messy world of custom ETL scripts. Singer allows users to mix and match inputs and outputs, making their ETL processes much more modular–and therefore easier to run and maintain. Singer uses JSON to move all data between sources and destinations, so you won’t have to worry about incompatible formats once you’ve set your ETL tasks up to run. Panoply’s integration with Singer makes it easy to move data from anywhere with a supported tap–Singer’s term for a data collection script–into an automated cloud warehouse. And since Singer is open source and supported by a broad community of developers, if you can’t find the tap you need, you can just write your own, without having to worry about building loading functions for Panoply.
The QuickSight pay-per-use BI tool makes data analytics accessible to enterprises of all sizes. By using QuickSight’s built-in machine learning, you can create interactive dashboards to share with your teams. It delivers business insights to your apps on any device. This user-friendly analytic platform scales automatically from 10 to 10,000 users. With QuickSight’s APIs, you can embed self-service analytics in your apps and seamlessly authenticate the users who need access. Its SPICE in-memory calculation engine lets thousands of users do complex analytics at the same time, while it protects your source data. QuickSight uploads data from the cloud and on-premises from many third-party data sources, databases, and AWS services. But you can connect QuickSight to any data source with the Panoply integration. The all-in-one Panoply ETL continuously uploads, processes, and streams all your data types. This powerful automated ETL pipeline is fully integrated with a cloud data warehouse.