From Custom Builds to Fivetran: Evolving Our Data Pipeline Strategy

In this episode of The Dashboard Effect, Brick and Landon discuss their shift in thinking on whether to build custom data connectors or use third-party tools like Fivetran. They share the pros, cons, and lessons learned from their proof-of-concept with Fivetran, and why APIs are changing the data pipeline game.Key Moments:1:15 – Why custom connectors made sense in the past2:00 – The rise of APIs and the challenge of building connectors for them2:39 – Realizing the variety of systems—and limits of pre-built connectors4:03 – How Fivetran’s dedicated API teams save time and reduce risk4:57 – Turnaround times and when a custom build is still needed5:56 – Cost trade-offs: upfront development vs. subscription model6:30 – Support considerations for in-house vs. third-party connectors6:41 – Exploring other tools and continuing custom pipeline work7:11 – Closing thoughts and advice for data teamsBlue Margin helps middle-market companies turn their data into a strategic asset through automated dashboards and data solutions. By simplifying the flow of information, we empower leaders to make confident, data-driven decisions that drive growth and efficiency. Learn more at bluemargin.com.