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.
Trevor.io is an enterprise BI tool that makes it easy for teams to build and share simple and complex SQL queries. Its intuitive UI dashboard suggests relevant choices to add to your queries. Even non-programmers can create colorful dashboards in Trevor that visualize their business analytics results. And features like Advanced JSON support, Custom SQL and CSV upload make Trevor a functional build platform for designers and engineers. Its Zapier integration connects Trevor to hundreds of third-party apps like Gmail, Trello and Slack. Panoply’s Trevor integration automates and speeds extract, transmit and load (ETL)—the process that powers all data operations. Panoply continuously uploads, sorts, simplifies and stores your latest data. It’s managed on the secure cloud and streamed in real time to your Trevor queries and dashboards. This powerful all-in-one ETL pipeline is fully integrated with a cloud data warehouse.