Logo-SQORUS
SQORUS logo

Successful migration of a PeopleSoft environment to Oracle Cloud Infrastructure

SQORUS optimized an Oracle Cloud infrastructure with Autonomous Database and APEX.

The challenge

Guarantee a reliable and secure interconnection between Oracle Autonomous Database and APEX

In a context where companies are looking to modernize their applications while guaranteeing high data availability, our customer needed to interconnect Oracle Autonomous Database with Oracle APEX to develop an interactive web portal.

The main challenge was to ensure :

  • Efficient replication of data between a primary and secondary database via Data Guard to guarantee business continuity with minimal failover time and zero data loss.
  • Optimum performance to meet end-user requirements.
  • Enhanced security to prevent cyber-attacks and data leaks.
  • Seamless integration with existing information systems.

Background & objectives

Modernizing infrastructure to support growth

SQORUS logo

Our customer operates in a sector where data availability and fluidity of access are essential. Its initial infrastructure had several constraints:

  • An imperative need for high availability to guarantee uninterrupted access to critical applications.
  • Incident recovery times too long, with a direct impact on business
  • An aging architecture that doesn’t offer the agility required for business growth.
  • A need to reduce operating costs and optimize Cloud resources.

The main objectives of this migration were to :

  • Deploy a primary-secondary architecture with Data Guard on Autonomous Database to ensure redundancy and resilience.
  • Integrate APEX as a user interface for simple, efficient data access.
  • Automate database management to reduce manual intervention and the risk of error.
  • Optimize data security and compliance with advanced encryption and intrusion detection mechanisms

The SQORUS solution

Cloud architecture with high availability and optimized user interface

SQORUS implemented an OCI architecture combining Oracle Autonomous Database, APEX and Data Guard to guarantee performance and resilience.

1.High-availability architecture with Data Guard

  • Deployment of a primary database on Autonomous Database, with configuration of advanced performance options.
  • Configuration of a secondary database replicated via Oracle Data Guard in synchronous mode to minimize data loss.
  • Real-time monitoring of database synchronization via OCI Monitoring, with alert notifications in the event of discrepancies.
  • Automatic failover in the event of a breakdown thanks to Fast-Start Failover for rapid service resumption.

2. Secure interconnection with APEX

  • Deployment of APEX on Autonomous Database to develop an intuitive low-code user interface.
  • Implementation of a Virtual Cloud Network (VCN) with strict segmentation of security rules.
  • Configure strong authentication with Oracle Identity Cloud Service for regulated access to applications.
  • Optimization of latency and caching to improve response times and enhance the user experience.

3. Automation and performance optimization

  • Automatic regular backups on OCI Object Storage with multi-region storage.
  • SQL query optimization via Autonomous SQL Tuning to speed up processing of large queries.
  • Implementation of auto-scaling to dynamically adapt resources to the workload and reduce costs.
  • Proactive monitoring with OCI Logging and Application Performance Monitoring (APM) to anticipate incidents.

The results

High-performance interconnection with measurable business benefits

Thanks to this architecture, our customer has seen significant improvements:

  • 99.99% guaranteed high availability thanks to automatic replication.
  • Incident recovery time divided by 3, from 15 minutes to 5 minutes in the event of a switchover.
  • 35% performance improvement on SQL query processing.
  • Automation reduces maintenance costs by 25%.
  • Enhanced overall security with reinforced authentication and advanced data encryption.
SQORUS logo

The SQORUS choice

Why our customer chose SQORUS for this project

Expertise

SQORUS masters Oracle Cloud solutions, including Autonomous Database, Data Guard and APEX, guaranteeing optimal implementation.

Support

We adopted an agile, collaborative approach, involving the customer at every stage of the project.

Oracle Partner

As an Oracle partner, we benefit from exclusive access to best practices and technological innovations.

Contact SQORUS for your Oracle infrastructure optimization project Cloud

The interconnection between Oracle Autonomous Database and APEX on OCI, combined with Data Guard, ensures a high-performance, resilient and secure infrastructure. SQORUS supports its customers in implementing innovative Cloud solutions to meet their strategic challenges.

Need to optimize your Cloud infrastructure? Contact SQORUS for expert support!

Contact SQORUS

They trust us

Discover our other SQORUS case studies

See more

Who are we?

Discover the strengths of the SQORUS strategy

Logo_SQORUS_GPTW_2024
Read more

SQORUS specializes in the digital and business transformation of HR, Finance and IT functions.

For over 30 years, our consultants have been working with major corporations on strategic, international information systems projects: development strategy, selection assistance, integration, Business Intelligence, Data Management, support and change management, as well as on Cloud and Artificial Intelligence issues.

We have been able to adapt to new digital challenges, the arrival of the Cloud and changes in working methods. We have succeeded in forging strong partnerships with the main publishers in the market and in attracting business and technical experts.

Our strength: over 300 talented people dedicated to the success of your projects and sharing strong values: diversity, commitment and solidarity, which represent real value for the company and its customers.

Great Place to Work for 10 consecutive years, SQORUS is sensitive to the personal development of its Sqorusien.ne.s, their career development and their training in future-oriented solutions.