How a hub-and-spoke Salesforce integration improved Wistia's data visibility

Observability is crucial for building resilient data systems, and the implementation of a hub-and-spoke model with reverse ETL, as shown by Wistia's experience with Fivetran Activations, can significantly enhance data pipeline efficiency. Wistia faced several challenges, including complex updates, language barriers, data sequencing requirements, lack of data visibility, and excessive alerts, which were addressed by centralizing data definitions and using dbt models with Fivetran Activations. This setup enabled faster updates, improved visibility, and reduced alert fatigue by ensuring that data from various sources like Salesforce, HubSpot, and Stripe is consistent and easily accessible. The new system allows for SQL-based changes, spreading the workload across a broader team familiar with SQL and Python, and ensures that data errors are promptly identified and resolved without unnecessary alerts. Wistia's success with this model highlights the potential for other companies to streamline their data operations and free up resources by reducing reliance on custom integrations, with future plans to apply the same model to their marketing automation platform, HubSpot, for consistent data handling.