Code-free Digital Transformation with Error Correction

CASE STUDY

Client Snapshot:
Resene Paints is a multinational paint manufacturer based in New Zealand. The company, established in 1946, has manufacturing operations in Australia and Fiji and local production plants in Lower Hutt, Upper Hutt and Auckland. Resene products extend through a full range of paint and specialist coatings for residential and commercial buildings, marine, heavy industrial, road marking, automotive and agricultural use.

Internationally Resene has established a reputation as an innovative and technological leader and the company is often reported as one of New Zealand’s business success stories.

The Problem

Resene had seen an opportunity to build a cloud-hosted application to assist their customers with generating estimates of paint volumes and other consumables needed for projects. The application is hosted on SQL Azure, with development and test environments run from on-site servers in their headquarters. Resene were faced with two options for integrating their environments: using SQL Server Integration Services or the Eightwire Data Exchange.

The Approach

A Resene developer selected the Eightwire Data Exchange to:

  • Create two data stores, a local test database, and a cloud production database.
  • Build three processes:
    1. merge master data from test to production
    2. merge customer-generated data from production to test
    3. push application logs to test and clear out the production logs

The Benefits

Initially, Resene were considering using SSIS to merge and synchronise data between their environments. This was scoped to take ten days to build and was estimated to require eight days per year of maintenance and defect fixing. Using Eightwire to handle the integration between on-premises servers and the cloud, their consultant developer was able to construct the entire process in four hours.

Eightwire is able to dynamically fix data errors between systems saving Resene in support costs over the long term. Over the course of the first three months of Resene using Eightwire, nearly 120,000 rows were processed and over 1,000 data errors were fixed automatically without crashing a feed or requiring intervention by Resene staff.

Additional benefits that Resene can realise are the cost-effective migration of its local infrastructure to the cloud. Prior to using Eightwire, the costs of migrating data warehouse, line of business and other systems was simply too expensive for Resene to consider. It can now begin an enterprise wide migration project to move additional IT systems to Azure.

“Using Eightwire’s Data Exchange, our development team was able to reduce a three week development task to four hours.”

Daniel Shannon
Resene Development Team Lead

Related Posts

Year in Review Summary
Insight

2019: Year In Review

It’s been a busy, hugely rewarding year! We can’t wait to see what 2020 brings. Check out our highlights below.

Read More »
Singapore FinTech Festival NZ Innovation Pavilion
Insight

Building our reputation in Singapore and beyond

We were delighted to return to the Singapore FinTech Festival this year, particularly after our experience last year as part of the Global FinTech Hackcelerator programme. This year saw us selected as one of 12 leading New Zealand FinTech companies, invited by the wonderful team at NZTE, to be part of the first ever NZ

Read More »
The AWS Cardboard Village
Insight

Digital Health Week 2019 – our experience

A key highlight of this year’s Hamilton-based HiNZ organised event was being part of the Amazon Web Services (AWS) Experiential Village. The purpose of the village was to present attendees with a fusion of health and technology. This was the first time that primary and community healthcare were a major contributor to the annual HiNZ

Read More »
Sign up and one of our team will be in
touch shortly to start the journey.
By clicking submit, you agree to our terms and conditions.