Grouparoo Open Source Data Tools with Brian Leonard

ETL stands for “extract, transform, load” and refers to the process of integrating data from many different sources into one location, usually a data warehouse. This process has become especially important for companies as they use many different services to collect and manage data. 

The company Grouparoo provides an open source framework that helps you move data between your data warehouse and all of your cloud-based tools. This process of moving data back from the data warehouse to the applications is called reverse ETL, and is important for things like marketing campaigns and customer service. It easily integrates with your developer’s tools and is free and easy to install.

In this episode we talk with Brian Leonard, CEO at Grouparoo.

This interview will also be published as a video episode on our YouTube channel.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

Transcript

Transcript provided by We Edit Podcasts. Software Engineering Daily listeners can go to weeditpodcasts.com to get 15% off the first three months of audio editing and transcription services with code: SED. Thanks to We Edit Podcasts for partnering with SE Daily. Please click here to view this show’s transcript.


Sponsors

What has five tracks of content, covers two days, and is totally virtual? It’s SpringOne, and it’s coming up September 1st and 2nd! Join your fellow developers and learn the latest on topics from Spring to Kubernetes to digital transformation—and everything in between. Watch captivating industry all-stars. Boost your skills with a hands-on workshop. Engage with the community for (dare we say it?) real virtual fun in the Social track. And do it all from the comfort of anywhere. The best part? Workshop registration is open now! But hurry, seats are limited. Learn more at softwareengineeringdaily.com/springone.

Prophecy makes Enterprise data teams productive with new workflows – but what about existing workflows that are stuck in old proprietary ETL formats? For that, Prophecy has a Transpiler that automatically converts AbInitio, Informatica, SSIS, and Alteryx workflows to high-quality Spark code. See how Prophecy can modernize your data engineering with a free account at prophecy.io/sedaily.

G2i is the only marketplace just for pre-vetted JavaScript developers. Hire React, React Native, & Node.js developers you can trust on a contract or full-time basis. G2i will match you with pre-vetted developers within three days of your onboarding call. You’ll be able to review their technical profiles and set up interviews with candidates you like. You get a detailed technical profile that provides the developer’s assessment scores in each category, a copy of their code challenge, and a recording of their technical interview. Test a working relationship with no risk! The first week is free if you decide your developer isn’t a good fit. G2i’s litmus test is simple: can this developer make an impact in your code base within their first week? Go to softwareengineeringdaily.com/g2i to get started.

With infrastructure monitoring, distributed tracing, and logs, Datadog provides end-to-end visibility into the health and performance of modern applications. Datadog’s distributed tracing and APM generates detailed flame graphs from real requests, enabling you to visualize how requests propagate through your distributed infrastructure. See which services or calls are generating errors or contributing to overall latency, and dive deeper into your production code with an always-on code profiler to pinpoint the root cause and optimize your application faster at no additional overhead, regardless of your scale. Start monitoring your applications with a free trial and Datadog will send you a free T-shirt! softwareengineeringdaily.com/datadog

strongDM lets you manage and audit access to servers, databases, and Kubernetes clusters, no matter where your employees are. With strongDM, you can easily extend your identity provider to manage infrastructure access. You can automate onboarding, offboarding, and moving people within roles. strongDM. Manage and audit remote access to infrastructure. Start your free 14 day trial today at: strongdm.com/SEDaily

Software Weekly

Software Weekly

Subscribe to Software Weekly, a curated weekly newsletter featuring the best and newest from the software engineering community.