Case Study

Modernizing ERP for Construction: CGSI's Journey with Oracle APEX and OCI

Oracle APEX and OCI

The Overview

Services: Oracle APEX Development, Consulting

Solutions: Custom Application, Cloud Migration

Technology: Oracle APEX and OCI

Industry: Construction

CGSI, a leading ERP provider for construction and public works, serves over 200 companies across France with its iXbat solution. With Oracle Cloud Infrastructure (OCI) and Oracle APEX, CGSI embarked on a journey to modernize iXbat, aiming to enhance security, performance, and development flexibility.

CGSI partnered with Insum for expert guidance and support during this transition. While CGSI opted to retain control of development, they leveraged Insum’s team for guidance with coaching, training, technical challenge resolution, and validation to ensure adherence to best practices. This collaboration laid the groundwork for scalable, efficient modernization.

The Challenge

CGSI encountered multiple challenges in its ERP modernization journey:

  • Infrastructure Reliability and Scalability: Moving from a local hosting provider, CGSI needed a cloud infrastructure capable of industrial-scale processes, strong security, and simplified administration.
  • Development Efficiency and Standardization: Transitioning from Oracle Forms to APEX required adopting best practices to accelerate development and simplify future maintenance.
  • Data Security and Disaster Recovery: After prior issues with their hosting provider, CGSI sought a secure environment with automated backups and a robust disaster recovery plan.

The Solution

CGSI chose Oracle OCI for its secure, high-performance cloud environment and Oracle APEX for low-code development. With Insum’s support, CGSI established a solid foundation for ERP modernization and began developing modules to enhance iXbat. Key solution features included:

Infrastructure Modernization with OCI: Migrating iXbat to Oracle OCI provided a reliable, scalable cloud environment with automated backups and robust security.

Development Coaching and Support: Through a flexible hourly support model, Insum guided CGSI’s internal team, addressing technical challenges, validating solutions, and ensuring adherence to APEX best practices.

Rapid Module Development: The first APEX module, iXplorer, demonstrated how intuitive analytics and interactive dashboards could modernize iXbat while reducing development time and effort.

The Results

The collaboration between CGSI and Insum yielded transformative outcomes. By leveraging Oracle OCI and APEX, CGSI established a secure, scalable ERP foundation, enabling faster development cycles and improved operational efficiency. The iXplorer module, developed in record time, provided intuitive dashboards and real-time analytics, empowering users with actionable insights. Automated backups and disaster recovery capabilities further ensured data security and compliance, building customer trust.

 

Key Outcomes:

  • Secure and Scalable ERP Foundation: OCI and APEX provided a reliable infrastructure to support CGSI’s modernization goals.
  • Faster Development Cycles: Oracle APEX’s low-code environment reduced time-to-market, enabling rapid deployment of new features.
  • Improved Operational Efficiency: Real-time analytics and intuitive dashboards streamlined decision-making for end users.
  • Robust Data Security: Automated backups and disaster recovery capabilities ensured compliance and enhanced customer confidence.
  • Collaborative Success: CGSI retained control of development while benefiting from Insum’s guidance, ensuring best practices and scalability for future needs.

 

“Our decision to partner with Insum allowed us to modernize iXbat on Oracle Cloud while maintaining control of development. Insum’s expertise helped us establish a strong foundation and achieve results quickly, ensuring we’re set up for long-term success.”

— Yves de Laroche, President of CGSI

Discover the Full Story on Oracle.com

Learn how CGSI leveraged Oracle Cloud Infrastructure (OCI) and Oracle APEX to modernize iXbat, streamline operations, and enhance scalability.

Work with Us

We appreciate your interest in learning more about Insum.

We want to learn about how we can work with you.
Do you have any questions or need more info?

Fill out this form, and a member of our
team will connect with you. Let's talk!

Some of our other case studies

Enhancing Laboratory Solutions with Oracle APEX and OCI

Learn more about how Agilab, a leader in laboratory informatics, leveraged Oracle APEX and Oracle Cloud Infrastructure (OCI) to deliver a scalable SaaS platform. Learn how innovative development, secure cloud infrastructure, and tailored solutions transformed pharmaceutical R&D operations.

Transforming Shipping Operations with Oracle APEX at Nidec Leroy-Somer

Discover how a leading manufacturer improved its shipping operations by integrating Oracle APEX with Oracle E-Business Suite, reducing processing time and increasing efficiency with a modern, real-time shipping interface.

AP Automation with Oracle APEX and Document Understanding

Trailcon Leasing, a top transportation company in Canada, struggled with inefficient and error-prone manual invoice processing. Insum implemented an Oracle AI-powered solution to automate invoice parsing, reducing processing time from 30 minutes to 5 minutes. This automation improved accuracy and operational efficiency, allowing Trailcon’s finance team to focus on strategic tasks.

Banking on a Customer Application

Discover how an international banking group improved operational efficiency, reduced customer duplication errors, and enhanced data security through a custom Oracle APEX application integrated with Oracle EBS.