One of the major uses of a data integration platform, such as Scribe Online, is data aggregation – or consolidating data from multiple isolated systems, or data silos. Often this is done as part of a reporting or analytics process that is critical to business operations. Without the bridges that an integration platform like Scribe Online can build, data either remains isolated, never to be viewed in context with other data, or it is aggregated using a manual process. But manual processes can kill any productivity benefit you may have received from the aggregation, reporting, or analytic process. Manual movements could be feasible if you only need to aggregate the data periodically, but when you want to build a reporting process that is run regularly, manual steps create a fragile data aggregation and reporting process that can ruin your analytic capabilities and erode trust in your data.
A good example of a company experiencing this is the Rainforest Alliance. The Rainforest Alliance tracks the ingredients in consumer products, such as coffee, tea, cocoa, and paper products, from the farms and forests, through the supply chain, and to the retail shelves. If the ingredients are sustainably-produced, the product receives the Rainforest Alliance Certified seal. The data management, certification, and reporting processes they had in place before using the Scribe integration platform included several manual steps and would often slow down or break. Any time someone was out sick, left for vacation or was pulled away for other priorities, the data aggregation process was interrupted and their supply chain reports became outdated.
The Rainforest Alliance saw an opportunity to automate a number of key data processing steps and better integrate their systems. They hoped it would provide better visibility into the supply chain, shorten the seal approval process for suppliers, and eliminate the disruption caused by their manual process.
They used Scribe Online to move certification and audit information from Salesforce to their Microsoft SQL Azure data warehouse on an hourly basis. No more manually pulling data from Salesforce! They also created data flows between Salesforce and Microsoft Dynamics CRM (to aggregate information on people involved in certifications) and between Salesforce and their accounting system (Dynamics SL) so they could aggregate financial data into the data warehouse to enhance their management reports.
“Scribe’s strength is that it can easily get the data out of one system and into another,” said Eugene Kogan, CTO, the Rainforest Alliance. “Just a few hours after starting to use Scribe Online, we had a clear stream of data going from Salesforce to our data warehouse and our entire supply chain view came into focus.”
With the automated data flows they created with Scribe Online, the Rainforest Alliance is now able to run information seamlessly between their core CRM, accounting, and supply chain systems and their data warehouse without manual intervention. The system helped them improve data qualify, get greater visibility into their supply chain, and improve IT uptime.
This case shows that sometimes you just need to know what tool to apply to the job at hand. When Rainforest Alliance applied Scribe’s cloud-based integration platform to their situation, their problems started to dissolve in just a matter of hours.
To find out more about how the Rainforest Alliance used Scribe Online to integrate Salesforce with their other systems and their data warehouse, check out the complete case study.