A European national airline
Lack of alignment between development and change management processes causing slow, unreliable deployments and downtime
Introducing version control and automation to database development with industry-standard tooling
Increased speed and reliability of deployments, reduced downtime, time freed for development teams
A European national airline, renowned for high-quality service, emerged from a period of modernizing the fleet to enhance and improve passenger experience. Focus now turned to the technical division, who were under pressure to review their innovation cycle and to drive customer-facing features and products that would cement further gains in an increasingly competitive market.
When it came to the digital customer experience, internal processes were seriously impeding progress. A lack of alignment between development and change management processes was slowing down delivery and triggering unreliable deployments, which in turn were causing downtime that was unnecessarily disruptive to customers and risked serious reputational impact.
Avoiding failed deployments is business-critical for this sector, so the IT executive set the BI & Data Warehouse team a six-month project to:
Once there was visibility of the processes in place across the different functions that were responsible for the software development cycle, the project lead identified that it was database deployment that was still heavily manual and slowing down the pipeline. Application development had already adopted more efficient methods and a best practice technology stack.
While application teams had the ability to commit and push changes to source control, the database teams were stuck creating their own scripts and sharing them via a file folder. This in turn revealed a compliance vulnerability: with no version history for the database, the team could be exposed in a reputation-damaging audit, for not having watertight processes around the appropriate handling of sensitive data.
It immediately became apparent that introducing version control and automation to database development would create the sought-for alignment, reduce the risk of errors, and deliver the greatest gains in efficiencies to speed up delivery.
As customers expect not only a world-class experience, but also that their data will be secure, the opportunity to create an audit trail of what changes had been made, when, where, and by who instantly offered an opportunity to reduce the compliance risk.
The team decided to:
(IDC #EUR145261019 June 2019)
Download this free IDC Executive Brief for an invaluable understanding of the critical role database teams play in driving a leaner and faster development cycle.
"The ability to accelerate digital innovation at volume and pace will be the most critical new benchmark for organizations competing in the digital economy"
Case study
A FTSE 100 wealth management business with application development teams distributed across India and the UK reduced the time taken for deployments from twelve hours to two, with fewer post-deployment errors.
Case study
The world's leading premium automobile and motorcycle manufacturer, financier, and dealership dramatically reduced the volume of tickets submitted to their operations team, by empowering their developers to diagnose and resolve problems.
Case study
Since adopting SQL Provision, KEPRO, a leading healthcare organization, have been able to get a new off-shore development team running and compliant, save 15-20 hours a week in provisioning processes, and reclaim terabytes of disk space.
Whether you want more details about SQL Provision, a demo, or to know about best practice – get in touch.
Redgate has specialized in database software for 20 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.
Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.