
Goodwill of San Francisco, San Mateo and Marin Counties has served the San Francisco Bay area for nearly one hundred years
Goodwill
As the third Goodwill organization established in the United States, Goodwill of San Francisco, San Mateo and Marin Counties has served the San Francisco Bay area for nearly one hundred years helping people and families in need of secure jobs, and build or rebuild their lives.
Industry:
Non-ProfitHeadquarters:
San Francisco, CAUse Case:
Cost effective, feature-rich data protection helps create more accurate critical business reportsData Sources:
Salesforce, Fusion ERP, Oracle Cloud, Microsoft Power BI“Relational Junction assures the safety of our data and allows us to generate business-critical reports, which we couldn’t build using Salesforce alone, such as our weekly report to the state for reimbursement funds of recycled e-waste.”
– Hong Hunt, System Support Specialist Goodwill San Francisco
Challenge
- Create a data warehouse for their sales and donation collection data.
- Sync CRM data from Salesforce with the Goodwill sales and collection data warehouse.
- Create accurate and comprehensive reports for government agency reimbursement funds critical to the ongoing operations of the San Francisco Goodwill organization.
Goodwill Industries of San Francisco, San Mateo and Marin Counties, must manage their IT infrastructure on a tight budget while rigorously maintaining data integrity and auditabiity. When the organization contacted Sesame Software they urgently needed to address data integration and reporting challenges in order to assure timely and accurate reports were delivered to the state of California for business critical reimbursement funding.
Solution
- Provides Salesforce data backup.
- Integrates disparate data repositories for coherent analysis and reporting.
- Delivers consistent, integrated view of sales and donations/grant data.
The San Francisco Goodwill IT team selected Sesame Software’s Relational Junction for Salesforce and Relational Junction ETL Manager because they are cost-effective, easily implemented yet feature-rich data protection and integration solutions.
