IBS completes migration of Ak Bars Bank data warehouse to Arenadata DB

2022: QCD migration to Arenadata DB

On September 8, 2022, IBS announced that Ak Bars Bank had migrated the corporate data warehouse to the Arenadata DB analytical massively parallel database management system. As part of the project, the IBS team implemented a custom reporting layer, configured multifunctional storage user support, and the Data SLA provisioning process.

The Enterprise Storage Migration Project data was an important step in the strategy. data management bank

The need to migrate storage was associated with several factors. In 2019 the American , the corporation IBM curtailed the business of producing data storage and analysis equipment used Netezza by Ak Bars Bank. Instead, the company invited customers to switch to cloudy technology, but this option was unacceptable for storing sensitive data of the company. In addition, the decision of Ak Bars Bank to postpone the FTC was influenced by the general desire for independence from foreign technologies and the high cost of supporting them.

storage systems The analytical MPP-Arenadata DBMS DB, built on the basis of a project open source with code, was chosen as an alternative. Greenplum

The technological partner of Ak Bars Bank for migration was IBS, a Russian IT company that provides services in the field of process optimization, business system creation, data analysis and modeling, development, testing and maintenance ON,. outsourcing business processes

Before the main migration, the IBS team implemented a pilot project, within the framework of which a technological stack was identified, its ability to fulfill the assigned tasks was proved and a roadmap for the project was developed. During the migration, IBS specialists gradually performed work on optimizing the storage model, transferring historical data: layers of detailed data, aggregates, technological and business storefronts, user analytical data and data sandboxes, as well as the complete migration of all integration flows and calculation mechanisms. The user level was refined according to the logic used in IBM Netezza.

The IBS team has transferred about 40 BI reports, which are regularly used by the bank's financial department, the client segment development directorate, the financial risk directorate and other divisions. We also helped build user processes: storage operation, updating, data quality assurance, functionality assurance and Data SLA, - said Nadezhda Makarova, project director at IBS.

During the migration process, the logic of the original ETL scenarios was partially rewritten and optimized. The migration itself was almost seamless, along with the implementation of current business tasks. IBS supported the simultaneous operation of two storage facilities during the transition period, so that services remained available to users.

The project was completed in 18 months, work on it went from January 2021 to June 2022.

By migrating to Arenadata DB, our company has gained a new level of reliability, security and data availability. The work with data has been simplified, their processing has accelerated, additional opportunities for business analytics have opened up. The cost of owning IT infrastructure and dependence on foreign counterparties has decreased, - said Vyacheslav Yashkin, Managing Director of the Management Board of Ak Bars Bank.