Boston-based WGBH is one of the largest and best-known public television/radio stations in the U.S., serving not only as an educational and entertainment resource for all of New England, but also as a provider of thought-provoking audio and video content for public broadcasting stations across the county.
Needed to replicate CRM data onto a local server.
Salesforce, Pardot, SQL Server
“We really are using Relational Junction quite a bit for all of that heavy lifting of migrating legacy data into that new area. It’s just a workhorse that does what you need it to do.”
– Pamela Driscoll, WGBH Director of Technology Solutions
Like many PBS outlets, WGBH relies on a robust donor base to generate a significant portion of its operational funding, and in recent years has been using Salesforce as a CRM provider to manage that donor data, then moving that data to a cloud-based SQL server for analytics and data-based marketing automation done by RedPoint Global.
Pam Driscoll, WGBH director of technology solutions, says the station’s Technology Solutions department initially relied on Relational Junction’s suite of SQL tools to replicate the CRM data on that local server, as well as move data back from the warehouse up to Salesforce.
Driscoll says the Sesame Software support team have been tremendously responsive whenever support is needed. “We use Relational Junction in some ways that are not standard and they’ve always been there to help us,” she adds. “We’re also using Pardot and rely on Relational Junction to bring that data down to our warehouse as well.”
Driscoll adds Relational Junction is proving to be a reliable, robust and integral component of the WGBH data management strategy. “We’re very happy with it,” she says. “It’s just a workhorse and does what you need it to do.”
Headquartered in Boston, WGBH is a public radio and TV station that has been both a New England and national institution for nearly 70 years, enriching people’s lives through programming and services that educate, inspire, and entertain. In addition to initiatives that support K-12 education and a dedicated news reporting driven by facts rather than factions the WGBH mission advocates citizenship and culture, the joy of learning, and the power of diverse perspectives. WGBH also supports the efforts of public broadcasting stations across the country to connect with donors and generates the resources necessary to provide quality TV and radio content in their local markets.