Netrika has implemented a project for import substitution of DBMS for Rosagroleasing

2022: Transfer of stored procedure databases and integration services to Russian PostgreSQL

At the end of 2022, the company Netrika"" completed work on the transfer (migration), databases stored procedures and services from the integration database management system data Microsoft SQL Server the Russian Postgres Pro analytical to the enterprise system of JSC "." Rosagroleasing Import substitution DBMS implemented with the preservation of functionality and permissible indicators. performance Data migration is "seamless," without system downtime. This was announced on March 23 by Netrika.

Rosagroleasing JSC state leasing is a company whose activities are aimed at technical technological and modernization domestic AGRARIAN AND INDUSTRIAL COMPLEX by transferring funds productions to leasing to agro-industrial complex organizations. To countries increase the stability of the analytical system, the management of Rosagroleasing JSC decided to transfer data to the Russian DBMS Postgres Pro and import substitution of the SSIS integration service. The technological partner of the project was the St. Petersburg IT company Netrika.

Netrika has implemented dozens of projects for the development, maintenance and modernization, software including the migration of database management systems. And since the company specializes in working with, state information systems issues safety and stability are given priority. Postgres Pro is the most suitable solution for import substitution of database management systems from Oracle and to Microsoft. Russia The high quality of work of IT architects of Rosagroleasing JSC, a well-designed data structure and a well-functioning technological process of updating, storages as well as a well-configured business process and availability of all the necessary specialists allowed the Netrika project team in close cooperation with internal IT experts of Rosagroleasing to carry out the project in a short time. Data development, migration and commissioning industrial took only 5 months.

As a result, a database of about 6 TB was migrated - more than 300 tables with up to 4 billion rows. 15 ETL packets and 131 procedures are adapted. At the same time, the functionality of the customer's system is completely preserved.

The Company's storage facility is the most complex algorithmic system of the Company from the point of view. In addition to accumulating historical data, the system implements key mechanisms for mutual settlements with customers. In accordance with the terms of reference, the Netrika team carried out the transfer of the data schema, tables, procedures, as well as the integration service on time. Conducted testing migration results, reconciliation of migrated data, as well as system debugging in the industrial environment. During the audit of all procedures, system flaws were identified and corrected business logicians. In fact, in addition to migration, Netrika specialists refactored source code to eliminate shortcomings and optimize the solution for the specifics of Postgres Pro, commented on the head of the information systems development department of Rosagroleasing JSC Denis Molotkov.

The efficiency of the migration process was greatly helped by the good structuring of databases and a deep understanding of their own processes by the customer's specialists. Thanks to the high-quality import substitution of the DBMS, the risks in terms of the stability of the analytical system and its information security, which arose due to restrictions on support from Microsoft, were reduced. Rosagroleasing JSC has a good base for the further development of the enterprise's information systems without reference to foreign proprietary software, added the head of the Automation department of the Netrika IT company Anton Germans.