Oracle database migration
Oracle database migration to Oracle Cloud Infrastructure for ZSE Energia, a.s.
Client Profile: ZSE Energia, a.s.
The company ZSE Energia, a.s. is one of the largest suppliers of gas and electricity in Slovakia. It operates primarily in West Slovakia and has done so for over 100 years It also offers the same high quality of services in other parts of the country, with over one million customers reliant on it every day. The company mission is to trade electricity and gas in the West Slovakia region and elsewhere, and to provide long-term, reliable and price-friendly supplementary services in an environmentally friendly manner and in compliance with EU regulations.
Project aim
As part of the data migration, the client wanted its database environment to be relocated in the cloud.he client wanted its database environment to be relocated in the cloud. The main selection criteria were database performance and compliance with licence terms and conditions.
Initial situation
The cloud storage that the client had been using no longer met the demands of modern administration and the latest requirements. It was therefore essential to find a solution that would satisfy these requirements and criteria. To add to the challenge, the client was using a fairly old version of Oracle Database – 11.2.0.4 Standard Edition One – and the projected target database size was approximately 25 terabytes.
Solution
When choosing a cloud environment that would meet all the necessary criteria, we opted for Oracle Cloud Infrastructure (OCI), despite the client making extensive use of Azure cloud services. OCI not only provided the required performance for the migrated databases, but also offered the required database version as a platform service, offering several benefits for the client in the simplicity of database and licence management. The actual migration of the databases was straightforward without any major surprises and the process was completed according to schedule. Connecting the new OCI cloud environment to existing services in the Azure cloud using a secure, low-latency IPSEC tunnel went ahead equally smoothly.
Project benefit
This successful project also produced various additional benefits for the client. One of the outputs of the project is easier data management using platform services. The client also gained more flexibility in DevTest scenarios, allowing them to create cloud environments dynamically as needed. Another key benefit for the customer is that Oracle Cloud Infrastructure provides Oracle licensed programs that can then be used in Pay As You Go form. What’s more, the TCO of migrating an Oracle database to the cloud is almost 30% lower with OCI compared to other cloud providers.
Project outputs
Key project achievements:
- to migrate the database environment to Oracle cloud Infrastructure (OCI) successfully and effectively
- to confirmthe seamless scalability of the data warehouse (up to the expected workload) in DBCS on OCI
- to save costs by choosing the right OCI cloud platform.
Special acknowledgements
This project was carried out in cooperation with Oracle Cloud Solutions
Virtual Solutions
Oracle database migration
Client profile
ZSE Energia, a.s.
The company ZSE Energia, a.s. is one of the largest suppliers of gas and electricity in Slovakia. It operates primarily in West Slovakia and has done so for over 100 years It also offers the same high quality of services in other parts of the country, with over one million customers reliant on it every day. The company mission is to trade electricity and gas in the West Slovakia region and elsewhere, and to provide long-term, reliable and price-friendly supplementary services in an environmentally friendly manner and in compliance with EU regulations.
Oracle
Platform
Migration
Efficiency
25 terabytes
Target database size
Migration of Oracle database to Oracle Cloud Infrastructure for ZSE Energia, a.s.
Project aim
As part of the data migration, the client wanted its database environment to be relocated in the cloud.he client wanted its database environment to be relocated in the cloud. The main selection criteria were database performance and compliance with licence terms and conditions.
Initial situation
The cloud storage that the client had been using no longer met the demands of modern administration and the latest requirements. It was therefore essential to find a solution that would satisfy these requirements and criteria. To add to the challenge, the client was using a fairly old version of Oracle Database – 11.2.0.4 Standard Edition One – and the projected target database size was approximately 25 terabytes.
Solution
When choosing a cloud environment that would meet all the necessary criteria, we opted for Oracle Cloud Infrastructure (OCI), despite the client making extensive use of Azure cloud services. OCI not only provided the required performance for the migrated databases, but also offered the required database version as a platform service, offering several benefits for the client in the simplicity of database and licence management. The actual migration of the databases was straightforward without any major surprises and the process was completed according to schedule. Connecting the new OCI cloud environment to existing services in the Azure cloud using a secure, low-latency IPSEC tunnel went ahead equally smoothly.
Project benefit
This successful project also produced various additional benefits for the client. One of the outputs of the project is easier data management using platform services. The client also gained more flexibility in DevTest scenarios, allowing them to create cloud environments dynamically as needed. Another key benefit for the customer is that Oracle Cloud Infrastructure provides Oracle licensed programs that can then be used in Pay As You Go form. What’s more, the TCO of migrating an Oracle database to the cloud is almost 30% lower with OCI compared to other cloud providers.
Project outputs
Key project achievements:
To migrate the database environment to Oracle cloud Infrastructure (OCI) successfully and effectively.
To confirmthe seamless scalability of the data warehouse (up to the expected workload) in DBCS on OCI.
To save costs by choosing the right OCI cloud platform.
This project was carried out in cooperation with Oracle Cloud Solutions
See more case studies
Slovnaft
Outsourcing of IT services
For 10 years already we have been a partner to this major refinery, providing support for the end-user and workstations environments…
TIMED
Outsourcing of IT services
Our services for this client provide comprehensive management of the IT environment.
We progressively upgraded the central and network IT infrastructure, deployed the Microsoft Windows 10…
SlovakAid
Outsourcing of IT services
For the customer, it covers the support of the central IT infrastructure and the end-user environment.
We have gradually consolidated and upgraded the central infrastructure towards a hybrid solution with the MS O365 platform, where the customer currently uses the communication tools and storage functions.
Wiktor Leo Burnett
Outsourcing of IT services
As part of the IT as a Service solution, we provide the advertising agency with support for workstation and end-user environments, support and operation of central solutions, IT systems and communication infrastructure, including the creation of a strategy and concept for the IT environment.
365 bank
Comprehensive migration project
For a 365 bank and 365 invest customer, we created a complex project that included transferring the accounts, mailboxes, OneDrive, SharePoint sites, Teams and Office 365 groups of the 365 invest subsidiary’s employees to the bank’s tenant…
Tatra Banka
Flexible and effective data extraction
■ Quality and efficiency of document digitisation
■ Preserving the structure of processed documents
■ Flexibility of templates for busy documents and more
■ Scalability, robustness, easy administration and monitoring
ZSE Energia
Application of Microsoft Dynamics 365
For the customer ZSE we have created an information system for managing users of public charging stations for electric vehicles based on Microsoft Dynamics 365…
Železnice Slovenskej republiky
Universal training simulator
As part of a project for our customer ŽSR, we handed over a universal training simulator for selected rail vehicles.
The simulator connects a HW copy of a real control console with a virtual environment and enables rendering via a mixed reality system…
Univerzita Komenského v Bratislave
Virtual Anatomy application
Using our Virtual Anatomy application, students of Comenius University have a tool at their disposal to explore more than 14 anatomical structures in an interactive way, along with expert descriptions or animated models of the musculoskeletal system…
Západoslovenská distribučná
ChatGPT virtual assistant
As part of a project for our customer, they applied a bespoke system that provides automation and sharing of internal information resources within the organisation.
Slovnaft
Outsourcing of IT services
For 10 years already we have been a partner to this major refinery, providing support for the end-user and workstations environments.
In addition to traditional IT support, we also took over central administration of the workstation environment, hardware and software lifecycle management and deployed an IT Point kiosk service.
TIMED
Outsourcing of IT services
Our services for this client provide comprehensive management of the IT environment.
We progressively upgraded the central and network IT infrastructure, deployed the Microsoft Windows 10 operating system and managed the transition to hybrid use of the Microsoft Office 365 platform, which simplified the management of company communication.
SlovakAid
Outsourcing of IT services
For the customer, it covers the support of the central IT infrastructure and the end-user environment.
We have gradually consolidated and upgraded the central infrastructure towards a hybrid solution with the MS O365 platform, where the customer currently uses the communication tools and storage functions.
Wiktor Leo Burnett
Outsourcing of IT services
As part of the IT as a Service solution, we provide the advertising agency with support for workstation and end-user environments, support and operation of central solutions, IT systems and communication infrastructure, including the creation of a strategy and concept for the IT environment.
365 bank
Comprehensive migration project
For a 365 bank and 365 invest customer, we created a complex project that included transferring the accounts, mailboxes, OneDrive, SharePoint sites, Teams and Office 365 groups of the 365 invest subsidiary’s employees to the bank’s tenant.
One of our main priorities was to minimise any impact on the day to day running of the end user services. In addition, we have seen an increase in productivity due to the unified approach to services and a reduction in administration and maintenance costs.
ZSE Energia
Application of Microsoft Dynamics 365
For the customer ZSE we have created an information system for managing users of public charging stations for electric vehicles based on Microsoft Dynamics 365.
In 6 months we created an application supporting public charging of electric vehicles. The result of our work is a highly flexible CRM system and billing platform. We helped the customer achieve a 61% increase in the use of public EV charging services and a 242% increase in monthly revenue from the use of the nationwide EV charging service. The number of registered users grew by 127% in a year, bringing ZSE to a milestone of 1,200 subscribers.
Tatra Banka
Flexible and effective data extraction
Based on ABBYY FlexiCapture 12.0 Distributed Version, we designed a comprehensive solution for our long-term customer, TATRA BANKA a.s., to digitise data, extract it efficiently and export it to a document management system (DMS). We streamlined the information system for data extraction and significantly expanded its functionalities such as:
■ Quality and efficiency of document digitisation
■ Preserving the structure of processed documents
■ Flexibility of templates for busy documents and more
■ Scalability, robustness, easy administration and monitoring
Západoslovenská distribučná
ChatGPT virtual assistant
As part of a project for our customer, they applied a bespoke system that provides automation and sharing of internal information resources within the organisation.
Univerzita Komenského v Bratislave
Virtual Anatomy application
Using our Virtual Anatomy application, students of Comenius University have a tool at their disposal to explore more than 14 anatomical structures in an interactive way, along with expert descriptions or animated models of the musculoskeletal system.
Thanks to the use of virtual reality, they can, for example, shrink to the size of a bee and fly through the entire human body, or break down complex structures into their constituent parts.
Železnice Slovenskej republiky
Universal training simulator
As part of a project for our customer ŽSR, we handed over a universal training simulator for selected rail vehicles.
The simulator connects a HW copy of a real control console with a virtual environment and enables rendering via a mixed reality system. The simulator is designed for students, but also for training the reactions of experienced drivers to unforeseen situations.
