Anadolu Sigorta Decreases Database Provisioning From 5 Days To 10 Minutes With Delphix

Anadolu Sigorta A.Ş. is one of the largest insurance companies in Turkey that offer health, marine, engineering, auto, fire and home insurance packages, and more. The company has played an important role in shaping Turkey’s insurance market and modernizing its socio-economic landscape.

Serving more than 3 million customers, Anadolu Sigorta A.Ş. operates more than 2,500 agencies throughout Turkey and reached 324.5 million TL in consolidated net profit in 2018. The company has a deep focus on providing digital excellence to its customers by delivering high-quality applications at high speed.

Challenge

Anadolu Sigorta A.Ş. uses UAT and PREP environments to provide Production quality data to teams that require it, used mostly for UAT and Bug fix purposes. However, during Delphix installation they were also facing storage shortage challenges because they were in parallel planning to move their data center. These shortages were causing difficulties in environment and database creation requests and sometimes it would take more than a week to export/import a database from Production systems. These problems were either being solved by putting in extra operational work load or delaying the tests and SDLC cycles.

Solution

Delphix deployment in Anadolu Sigorta A.Ş. started in January 2018. Initially the Delphix Engine was given 5TB storage but eventually the storage was increased to support increasing demand. During the deployment Production databases were ingested by Delphix. The deployment work was performed based on systems that were prioritized by Anadolu Sigorta A.Ş. teams. Between January and May 2018 more than 6 Oracle databases are ingested, virtualized and given to end-users.

Data Protection related work was also performed during this timeline, leveraging the embedded Masking Engine. Currently Anadolu Sigorta A.Ş. is using Delphix Engine to its full capabilities. Delphix provided Anadolu Sigorta A.Ş. an opportunity to ingest and provision production databases in minutes to any team that requires it.

For each system that is to be virtualized initial meetings are performed with development, test and business teams to gather the requirements for the virtual databases. Required OS and DB accounts are created and Delphix is connected to production systems to ingest the databases. Virtual databases are created with Hook scripts in a way that ensures that virtual databases are ready to be used by end-users the moment that provisioning is completed. Masking, user and database update operations such as truncate are performed during the initial load of the database. In some cases, a stage database is used to provide continuously ready fresh data to the test teams.

Results

Providing daily, fresh, masked and end user ready data to UAT and PREP environments created lots of benefits to different teams.UAT teams are able to access data whenever they need it. Export/import operations become obsolete since virtual databases can be provisioned in minutes. OBA operation work load is moved from export / import related jobs to DB performance and other production related works. Ability to provide daily Production data anytime greatly improved how the tasks are handled especially those that are related to bug fixes. With Delphix, Anadolu Sigorta developers enjoy working with full data that is under their command on demand.

From project inception, the Accuras team was involved in all Delphix related steps in Anadolu Sigorta A.Ş. Our dedicated Delphix Blackbelt Client Architect, Rahim Çetinel provided all required analysis, architecture and deployment support. The Accuras team continues to provide 24/7 remote and on-site support for all Delphix related issues.