{"id":831,"date":"2016-09-16T13:49:02","date_gmt":"2016-09-16T17:49:02","guid":{"rendered":"https:\/\/blog2wrkdev.wpenginepowered.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/"},"modified":"2026-09-29T06:31:21","modified_gmt":"2026-09-29T10:31:21","slug":"this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato","status":"publish","type":"post","link":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/","title":{"rendered":"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato"},"content":{"rendered":"\n<i style=\"font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen-Sans, Ubuntu, Cantarell, 'Helvetica Neue', sans-serif;\">This is a snippet from the SFTA case study done by Bigger Boat Consulting. Bigger Boat builds <a href=\"https:\/\/biggerboatconsulting.com\/salesforce-human-services-solutions\/\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https:\/\/www.google.com\/url?hl=en&amp;q=https:\/\/biggerboatconsulting.com\/salesforce-human-services-solutions\/&amp;source=gmail&amp;ust=1474068680945000&amp;usg=AFQjCNFRM-2fGxj2Ya84Wtdx5qc6w9e7nA\">Salesforce-based solutions for nonprofits focused on human and social services<\/a>.<\/i>\n<div>\n\nSupporting Families Together Association (SFTA) is a statewide association of child care resource agencies and family resources agencies throughout the state of Wisconsin. SFTA helps these agencies by providing program management, organizational development, systems building, and professional development services.\u00a0Each child care resource agency is independent, but the resource agencies have a few core functions in common including providing referrals for childcare in their areas.\n\nWhen their legacy tool no longer could meet their needs, SFTA began to work with Bigger Boat Consulting to create a tool for the eight participating child care resource agencies. This tool needed to provide aggregated statewide data to\u00a0SFTA and bring together information from all 8 agencies.\n<h4><b>Creating A Central Hub with Salesforce<\/b><\/h4>\nBigger Boat created a Salesforce system that allows SFTA to manage referrals, providers (including provider listings and tracking providers licensing and pre-licensing status), trainings and reporting. Clients could now either call their local agency for a referral or access childcare referrals online with no login necessary.\n\nTo keep each agency autonomous but still connected with a central hub, Bigger Boat\u00a0created one core system and then deployed it to individual Salesforce instances for each agency. This allows the agencies to easily make their own changes and modifications to meet their local needs. However,\u00a0SFTA also needed to track detailed statistics on referrals and providers so they could report to various funders from this database. This meant integrating between multiple Salesforce instances.\n<h4><b>Integrating the Agencies with Workato<\/b><\/h4>\nBigger Boat knew that a\u00a0key requirement for SFTA, as the statewide organization, was to see aggregated data across all eight local agencies. They chose to use Workato to connect the eight agency Salesforce systems to the statewide system. Workato recipes were built for each primary object that needed to sync, such as Accounts and Referrals. The recipes trigger when records are created or updated, and the appropriate fields and records are synced between the agencies and SFTA.\n\nThis synchronization has enabled SFTA to have a holistic view of critical data from across the state, while each regional agency sees only its own data in its own instance.\n<h3><a href=\"https:\/\/biggerboatconsulting.com\/statewide-childcare-referral-network-streamlines-operations\/\">Read the full case study &gt;<\/a><\/h3>\n&nbsp;\n\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This is a snippet from the SFTA case study done by Bigger Boat Consulting. Bigger Boat builds Salesforce-based solutions for nonprofits focused on human and social services. Supporting Families Together Association (SFTA) is a statewide association of child care resource agencies and family resources agencies throughout the state of Wisconsin. SFTA helps these agencies by [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-831","post","type-post","status-publish","format-standard","hentry","category-customer-stories"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato - Workato<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato - Workato\" \/>\n<meta property=\"og:description\" content=\"This is a snippet from the SFTA case study done by Bigger Boat Consulting. Bigger Boat builds Salesforce-based solutions for nonprofits focused on human and social services. Supporting Families Together Association (SFTA) is a statewide association of child care resource agencies and family resources agencies throughout the state of Wisconsin. SFTA helps these agencies by [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/\" \/>\n<meta property=\"og:site_name\" content=\"Workato\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-16T17:49:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-29T10:31:21+00:00\" \/>\n<meta name=\"author\" content=\"Kristine Colosimo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kristine Colosimo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\\\/\"},\"author\":{\"name\":\"Kristine Colosimo\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/8afac8a5850ae6d549221e0759616fa5\"},\"headline\":\"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato\",\"datePublished\":\"2016-09-16T17:49:02+00:00\",\"dateModified\":\"2026-09-29T10:31:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\\\/\"},\"wordCount\":397,\"articleSection\":[\"Customer Stories\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\\\/\",\"url\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\\\/\",\"name\":\"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato - Workato\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#website\"},\"datePublished\":\"2016-09-16T17:49:02+00:00\",\"dateModified\":\"2026-09-29T10:31:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/8afac8a5850ae6d549221e0759616fa5\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog2workato.wpengine.com\\\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#website\",\"url\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/\",\"name\":\"Workato\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/8afac8a5850ae6d549221e0759616fa5\",\"name\":\"Kristine Colosimo\",\"description\":\"Kristine oversees Workato's content and works with awesome apps like DocuSign, Zendesk, SurveyMonkey etc. on great automation content.\",\"url\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/author\\\/kristine\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato - Workato","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/","og_locale":"en_US","og_type":"article","og_title":"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato - Workato","og_description":"This is a snippet from the SFTA case study done by Bigger Boat Consulting. Bigger Boat builds Salesforce-based solutions for nonprofits focused on human and social services. Supporting Families Together Association (SFTA) is a statewide association of child care resource agencies and family resources agencies throughout the state of Wisconsin. SFTA helps these agencies by [&hellip;]","og_url":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/","og_site_name":"Workato","article_published_time":"2016-09-16T17:49:02+00:00","article_modified_time":"2026-09-29T10:31:21+00:00","author":"Kristine Colosimo","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kristine Colosimo","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/#article","isPartOf":{"@id":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/"},"author":{"name":"Kristine Colosimo","@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/8afac8a5850ae6d549221e0759616fa5"},"headline":"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato","datePublished":"2016-09-16T17:49:02+00:00","dateModified":"2026-09-29T10:31:21+00:00","mainEntityOfPage":{"@id":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/"},"wordCount":397,"articleSection":["Customer Stories"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/","url":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/","name":"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato - Workato","isPartOf":{"@id":"https:\/\/www.workato.com\/the-connector\/#website"},"datePublished":"2016-09-16T17:49:02+00:00","dateModified":"2026-09-29T10:31:21+00:00","author":{"@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/8afac8a5850ae6d549221e0759616fa5"},"breadcrumb":{"@id":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog2workato.wpengine.com\/this-statewide-nonprofit-streamlined-data-between-8-agencies-using-salesforce-and-workato\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog2workato.wpengine.com\/"},{"@type":"ListItem","position":2,"name":"This Statewide Nonprofit Streamlined Data Between 8 Agencies Using Salesforce and Workato"}]},{"@type":"WebSite","@id":"https:\/\/www.workato.com\/the-connector\/#website","url":"https:\/\/www.workato.com\/the-connector\/","name":"Workato","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.workato.com\/the-connector\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/8afac8a5850ae6d549221e0759616fa5","name":"Kristine Colosimo","description":"Kristine oversees Workato's content and works with awesome apps like DocuSign, Zendesk, SurveyMonkey etc. on great automation content.","url":"https:\/\/blog2workato.wpengine.com\/author\/kristine\/"}]}},"_links":{"self":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/comments?post=831"}],"version-history":[{"count":2,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/831\/revisions"}],"predecessor-version":[{"id":5687,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/831\/revisions\/5687"}],"wp:attachment":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/media?parent=831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/categories?post=831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/tags?post=831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}