Sedex and OpenCredo use Google Compute Engine to sustain a world-class CSR database
Sustainability has become an accepted part of the corporate management paradigm. Practices in areas like social justice, environmental protection, and accountability are now par for the course for large organisations, including Sedex.
Sedex manages an ethical data exchange on behalf of retailers and suppliers operating across global supply chains. A not for profit membership organisation, Sedex helps reduce the burden on suppliers who are repeatedly asked to meet corporate and social responsibility (CSR) and ethical auditing requests.
Established by a consortium of UK retailers in 2004, the organisation now represents 16,000 members – including WPP, Tesco, Walmart and Procter and Gamble – and manages data for 37,000 suppliers globally.
With this exchange, Sedex helps reduce the burden on suppliers who are repeatedly asked to meet sustainability requests.
Sedex’s existing system faced some fundamental problems due to the skyrocketing number of suppliers using its data exchange. Built on a third party platform (BI reporting applications running on Rackspace), the system was inflexible and difficult to amend, and as a result was unable to cope with the volume of data it needed to process.
Sedex also had ambitions to upgrade its data platform to include additional sources of information and provide greater insights to its clients. For example, Sedex wanted to share relevant news articles with suppliers, and at the same time improve its ability to scrutinise these multiple sources of data to better analyse trends.
“Since we’re a data platform provider, it’s essential that we’re perceived as best in class for CSR and compliance. Average will never be good enough,” said José Copovi-King, Director of Products and Services at Sedex. “We wanted to move to the next level and offer Big Data services.”
Sedex asked OpenCredo to devise and create a data-processing platform that used a range of open source technologies and was capable of meeting all of its requirements: managing, storing, analysing and disseminating huge volumes of data while being failure resilient.
OpenCredo’s solution combined Google Compute Engine, Cloud Load Balances, and Cloud DNS with Hortonworks Data Platform, a completely open-source technology.
Google Cloud Platform offered the most cost-effective option, with more reliability and more broadband per pound. And Hortonworks made it easy to scale the data storage and computation needs to address increasing demands.
In addition, to meet the expected level of performance for self-service data analysis and reporting by non-development users, a pipeline was built using Hive. Results of the Hive queries would be stored in a PostgreSQL database for access by existing reporting technologies. During a four-month period of collaboration, OpenCredo and Sedex refined and amended system requirements using Agile software development methods. OpenCredo’s consultants also engaged in a skills-transfer process, empowering Sedex employees to operate the reporting system independently.
Sedex now possesses a sophisticated, industry leading data processing platform, one that can evolve to meet the company’s requirements over time. Sedex is able to manage multiple datasets, design its own reports and handle made to order requests on demand.
These capabilities have given the company a clear competitive advantage in the marketplace.
The new Sedex solution can quickly produce (within milliseconds) complex yet digestible reports that compare data from a variety of sources, such as audit reports and self-assessment forms. Similar reports would have taken hours to produce previously, if they were possible at all.
Overall, Sedex has experienced a 40% cost savings over their previous system.
“We have the ability to produce large data sets very quickly and there are huge retailers in the U.S. who could very well become clients just because of that,” said José Copovi-King. “This is a huge step change for retailers and we’re now out in front of the competition in the CSR environment.”
OpenCredo, using Google Compute Engine and other technologies, devised and created a scalable self-service platform that could scrutinise datasets in real time while allowing Sedex to design and produce reports independently.
Results: A 40% cost savings through a world-class solution capable of evolving with the needs of the company and its customers.
The flexibility of the system allows Sedex to fulfil bespoke requests at short notice and has increased the value of the organisation to its clients. Sedex can also produce industry reports, which hold their own commercial worth.
“If a client has a specific requirement, we can rapidly meet that demand,” said José. “We had a request for a data security questionnaire and were able to carry this out very quickly by collecting data online. We can also design and sell our own reports – if we want to produce trend reports or benchmark companies against their peers we can now do so.”
Sedex, a nonprofit membership organization established by a consortium of UK retailers in 2004, manages a data exchange for companies and suppliers operating across global supply chains and asked to meet CSR and ethical auditing requests. Sedex represents
16,000 corporate members, including WPP, Tesco and Procter & Gamble, and manages data for 37,000 suppliers around the globe.
OpenCredo was founded with a straightforward goal: to help its clients across a spectrum of industries to deliver mission-critical software solutions faster and more cost-effectively . To achieve this, OpenCredo brings impartial expertise across a wide range of technologies and a holistic pragmatic approach to the software development process.
Google Compute Engine
Compute Engine offers flexible virtual machines (Infrastructure-as-a-Service or IaaS). Run large-scale workloads on virtual machines hosted on Google’s infrastructure. Choose a VM that fits your needs and gain the performance and consistency of Google’s worldwide fiber network. With per-minute billing, you pay only for what you use.