You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

Keyrus Implements Industrial Data Integration Solution for Logistics Giant

SA’s largest mineral freight logistics company now has comprehensive visibility into its disparate third-party industrial systems. Leading business data intelligence consultancy Keyrus has integrated data from various Grindrod Terminals’ stand-alone industrial systems into the organisation’s operational data to provide a single version of the truth, accessible via dashboards and their Visibility System.

The near real-time solution was designed using a range of leading technology platforms including Microsoft SQL Server Integration Services (SSIS), Azure Data Factory and Azure Cloud Storage. Tableau software is used to visualise and present the data.

Grindrod’s Terminal business faced tough consolidation challenges as a result of a number of fit-for-purpose, but independent industrial proprietary applications. These provide bespoke services for the vastly different areas of its business recording data from train and truck weighbridges, as well as from rail tippler equipment. The challenge, however, was to bring this data together to provide a holistic and integrated view of the data to enable business decision making. The solution leverages cloud-based technology to address the disparate geographic locations and also to provide visibility to the data from any location.

This part of solution augments the work done in previous phases where Keyrus was contracted to extract this industrial data and integrate it with the operational data pulled from programmable logic controller (PLC) machines in Grindrod’s facilities.

“Our challenge was to ensure this data was transformed into one, consistent format that could be pushed to the central, cloud-based data warehouse we set up for Grindrod,” says SSRS expert Evan Barke.

The ability of modern technology to solve business challenges lies at the heart of the way Keyrus operates. SSIS, a component Microsoft’s SQL Server database software, was adopted to build a high-performance data integration solution for Grindrod. This pushes the data at a set frequency, only moving new data records.

“The integration package we’ve installed on a central server at Richards Bay, for example, finds any new rows of data every five minutes and pushes that to the Azure environment,” says Barke. “All data is now also protected from on-site equipment failures.”

Azure Data Factory is used for all Grindrod’s integration touchpoints. It is here that data undergoes further transformation and is matched back to the master data stored in the organisation’s overarching application, Falcon, also designed by Keyrus.

The solution boasts a flexible architecture, capable of expanding to include any future third-party systems. It is also cost-effective as data integration flows are planned to ensure cloud resources are not shared by too many pipelines trying to execute at any one time.

Grindrod now also benefits from centralised visibility into what data is moving and when. If anything fails, alerts for action are triggered.

“The experts at Keyrus made clever use of a combination of sophisticated technology and back-to-basics tools to consolidate our disparate data into a central, cloud-based data warehouse,” says Bronwyn Burdis, Data and Analytics Manager at Grindrod’s Terminal business. “They are extremely flexible in their approach, resulting in quick turnaround times. We now have the single source of truth which is so vital for optimising our processes.”

“This implementation shows that, regardless of the mechanisms that limit the source systems, we are able to integrate the data and make business sense of it using Tableau,” says senior consultant at Keyrus, Craig Andrew.

“Grindrod is dependent on this fine level of detail to ensure more productive and effective throughput. It is wonderful to work with a customer with the foresight and willingness to invest in the future, and we’re delighted to be their integration partner. We pride ourselves on building a long term value for our client’s business,” adds Greg Guye, CEO at Keyrus.

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Success story

Digital transformation of Namibia Breweries' operations

February 1, 2023

Namibia Breweries chose Keyrus to contribute to its transformation into a data-driven organisation. Keyrus helped to instill a true data culture within Namibia Breweries’ operations.

Success story

Keyrus automates logistics data for Tevo

January 24, 2023

Keyrus assisted with a rapid, accurate, visible shipping date information system that makes for faster and better-informed customer decision-making.

Press release

Partnering with Pyramid Analytics

January 12, 2023

Keyrus has become a systems integration and consulting partner for Gartner-recognised, Pyramid Analytics in Southern Africa. This partnership will enable Keyrus's customers to benefit from this unique augmented analytics platform for decision intelligence and accelerate growth for Pyramid Analytics in Africa

Client testimonial

Keyrus and Tableau make data matter

November 23, 2022

In this age, it is absolutely essential to collect data but even more important is to use it effectively to the organisations’ full advantage - to make data matter.

Expert's opinion

Value of embedded analytics

August 20, 2021

The BI landscape is continually evolving, and rapidly too. The transition from IT-driven BI delivery to self-service analytics continues at pace and is now enhanced by the latest major trend of embedded analytics. The BI environment is no longer something separate from line of business systems. BI and advanced analytics are now being embedded within core operational systems with tangible benefits, says Adam Walker, General Manager at Keyrus South Africa.

Success story

We are experts in embedded analytics

September 12, 2022

Keyrus is Tableau Embedded Specialist Partner in Africa and MEA region, recognising our expertise in promoting and implementing Tableau’s embedded BI solution.

Success story

Creating new BI service stream through Qlik platform

September 9, 2021

Keyrus assists the Kwaden Investments Group to revolutionise its clients’ business landscape and transform their organisations. In the modern information age, data should be considered a precious corporate resource. However, it is only beneficial when coupled with the ability to derive deep insights from the available information by using analytics to provide focused details around business areas such as sales, stock and financial performance.

Expert's opinion

How we 'make data matter' and what are the future trends in business intelligence

June 15, 2022

Stephen Coull, Sales Director at Keyrus South Africa conducts a captivating interview with a business-technology celebrity Aki Anastasiou discussing key contributors to Keyrus’s success, our unique partnership with Tableau, embedded analytics being the future of BI, and the importance of humanizing data.

Success story

Keyrus is a Tableau PREMIER Reseller Partner in South Africa and EMEA region

May 27, 2022

South Africa’s leading data and technology consultancy Keyrus has achieved Premier Reseller Partner status in the Tableau Partner Network, becoming the only Premier Tableau reseller in South Africa and also on the African continent.

Success story

Vector Logistics embraces cloud-powered modern analytic solutions

April 20, 2022

A leading national supply chain specialist now benefits from vastly improved visibility and immediate access to information via self-service following a sophisticated cloud-powered analytics solution delivered by Keyrus.

Logo - Keyrus
Durban

10 Flanders Drive Mt Edgecombe 4302 Kwazulu Natal

Phone:+27 87 350 8860

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection