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 secure jobs and build or rebuild their lives. As the third Goodwill organization established in the United States, the organization helps motivated individuals overcome barriers to employment such as long- term welfare dependence, physical or mental disabilities, homelessness, incarceration or limited use of English.
Goodwill’s mission is to enhance the dignity and quality of life of individuals, families and communities by eliminating barriers to opportunity and helping people in need reach their fullest potential through the power of work.
In order to achieve their mission, Goodwill of San Francisco, San Mateo and Marin Counties operates:
- 27 stores & donation sites
- Over 50 corporate and community donation drives per year
- A 33,000-square foot processing plant
In addition to the data management for these business operations, individual, corporate, foundation and government donation and grant income data must be managed and integrated into the operational data.
Hong explains, “We require a coherent integrated data warehouse in order to perform timely and accurate data analytics and reporting using Microsoft Services tools. We also need to capture select information from the warehouse in order to optimize efficiency of state reimbursement funds reporting from our electronic waste recycling programs.”
The magnitude of Goodwill’s operations, coupled with the small IT staff and budget, drives the consistent need for cost-effective, easy-to-implement and manage tools for data storage, integration, analysis and reporting. Hong Hunt, System Support Specialist for the organization, works to assure these diverse operations run smoothly and data is available to both Goodwill management to external donor organizations and grant agencies.
Initially, Goodwill tried using Salesforce.com’s built-in reporting features. However, the feature set did not support their reporting requirements nor did it provide an automated data integration and backup solution.
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 auditability. 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:
- Create a data warehouse for their sales and donation collection data.
- Synch 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.
- Improve the general efficiency of analysis and reporting.
The San Francisco Goodwill IT team selected Sesame Software’s Relational Junction for Salesforce and Relational Junction ETL Manager because they are cost-effective, short-time-to-implement yet feature-rich data protection and integration solutions.
- Provides Salesforce data backup.
- Integrates disparate data repositories for coherent analysis and reporting.
- Delivers consistent, integrated view of sales and donations/grant data.
- Allows key business reporting for government funding.
Goodwill Industries® has helped people go to work since 1902. Goodwill trains people for careers in fields such as financial services, computer programming and health care. The organization provides employment, job training and other community-based programs for people with disabilities, those who lack education or job experience, and others facing challenges to finding employment.
Goodwill believes that work creates the economic energy that builds strong families and strong communities. Work helps build self- confidence, friendships and independence. Everyone deserves a chance to have those things in life. Goodwill provides that chance.
Goodwill Industries is a global social enterprise made up of community-based organizations. Goodwill Industries of San Francisco, San Mateo and Marin Counties, founded in 1916, is one of 208 autonomous Goodwill organizations in the United States.
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 ewaste.” – Hong Hunt, System Support Specialist Goodwill San Francisco
Relational Junction< for Salesforce is the best tool out there. I researched almost all of the available products and Relational Junction is the best –Great functionality and really stable. Plus, support is excellent! I love this product!”
Hong Hunt, Systems Support Specialist Goodwill San Francisco
Since Goodwill relies on Salesforce for CRM, they reviewed the data integration solutions on the Salesforce AppExchange. After evaluating several products, Goodwill concluded that Sesame Software’s AppExchange certified Relational Junction for Salesforce offers the best combination of features to meet their data integration, analysis and reporting requirements.
The Relational Junction for Salesforce data integration features have solved Goodwill’s data management and reporting challenges with time-saving automation.
Goodwill has been using Relational Junction for Salesforce for three years to automatically integrate information across operational databases, providing the Goodwill management, donors and grant agencies with comprehensive and timely information to support Goodwill’s invaluable contribution to families in need.