Case Study

Helping Valley Water Make Waves with Oracle APEX

Oracle APEX Development - Legacy Modernization

The Overview

Services: Oracle APEX Development, Legacy Modernization

Solutions: Shopping Cart, Database creation

Industry: Utilities, public sector, environmental services, water resource management

Valley Water manages an integrated water resources system that supplies clean, safe water, flood protection and stewardship of streams on behalf of Santa Clara County’s 2 million residents. The district effectively manages 10 dams and surface water reservoirs, three water treatment plants, an advanced recycled water purification center, a state-of-the-art water quality laboratory, nearly 400 acres of groundwater recharge ponds and more than 294 miles of streams.

The Challenge

One of Valley Water’s missions is to serve the two million residents of Santa Clara County and effectively manage the region’s water resources. Oracle Forms and Reports-based applications aren’t efficient and flexible enough to adapt to the rapidly changing environment or significantly enhance user engagement.

Valley Water also wished to attain its goal of a single source of truth by eliminating multiple data sources and quickly implementing new community services, such as web-based forms and applications.

Valley Water sought a strategic partner to help it achieve its goal of better serving Santa Clara County, so it partnered with Insum.

The Solution

Valley Water selected Oracle APEX as its new development platform. With its existing Oracle infrastructure, APEX was a logical choice as it required no additional licensing costs, offered ease of use, and had a short learning curve for its existing resources. The result was the development and rollout of at least thirty applications to date, with more in the pipeline.

Valley Water opted for the Oracle Autonomous Database on OCI. This decision was driven by its ability to scale and provide high availability and security features. Insum worked closely with Valley Water throughout the development process, playing a key role in creating several critical applications, including the Water Conservation Shopping Cart and the Water Supply Planning Database.

Through this collaborative effort, Valley Water has modernized its systems, saved time and money, and now better serves the needs of its community.

Some Results


One of Valley Water’s most critical applications is the Water Conservation Shopping Cart. This innovative platform has enabled Valley Water to deliver thousands of free water-saving devices to residents, helping them to conserve water and reduce their utility bills. The application’s success has been recognized nationally, with Government Technology Magazine awarding Valley Water the Special District Citizens Award for their use of technology to improve service delivery to the community. In 2022 alone, Valley Water shipped nearly 60,000 free water-saving devices to over 9,300 residents in Santa Clara County, making a significant impact on water conservation efforts in the area.


The Water Supply Planning Database is a crucial application developed by Insum and Valley Water to address the significant challenges faced in water supply planning activities. With the previous system becoming obsolete and no longer supported, the lack of a centralized and authoritative repository for water supply and consumption data, and inefficiencies from redundant and cumbersome data entry, this new database offers a comprehensive solution. The application enables faster and more flexible development of accurate and consistent water production and consumption reports, automates manual processes, and provides data visualization and analytics. Its implementation has significantly saved staff time and better supports the district’s planning and operations.

The Technology Used

  • Oracle APEX on-prem
  • Oracle APEX on Autonomous Database (OCI)
  • APEX Office Print
  • Address validation with
  • ArcGIS Feature Service API
  • REST API with ORDS for shopping cart order fulfilment by 3rd party vendor

The Results

The adoption of Oracle APEX as the new development platform truly revolutionized the way Valley Water manages its data and serves its customers.

The transition to Oracle APEX allowed for the development of several critical applications that streamlined processes and enabled Valley Water to better serve its community.

The Water Conservation Shopping Cart, in particular, has been a resounding success, with tens of thousands of free water-saving devices delivered to Santa Clara residents. Moreover, the Water Supply Planning Database has significantly saved staff time by automating manual processes and providing data visualization and analytics.

Working with a strategic partner such as Insum was key to this success, as they were able to collaborate closely with Valley Water and provide expertise in Oracle APEX development. This partnership ensured that Valley Water was able to leverage the full potential of Oracle APEX to achieve its mission of better serving its community.

Need guidance in a large APEX project? See our team coaching and augmentation service

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

Creating a Supplier Portal with Oracle APEX

Learn how Insum replaced an inefficient and cumbersome Excel spreadsheet and implemented an Oracle APEX-based Supplier Portal that revolutionized data handling, increasing efficiency and accuracy for a global electronics manufacturer.

Moving Air Transat to the Cloud

Air Transat collaborated with Insum to transition its critical scheduling application to Oracle Cloud, addressing server inefficiency and high replacement costs. This move enhanced performance and achieved significant savings.

Revitalizing Legacy Systems: A Cemetery’s Journey to Modernization

In a significant digital transformation, Insum collaborated with one of North America’s largest cemeteries to overhaul a 20-year-old system, replacing cumbersome manual processes with an integrated, user-friendly platform. The solution included a customer portal for online access to gravesite information, advanced reporting tools, and seamless integrations across departments.

Modernizing Oracle Forms Applications with Technip Energies

Partnering with Talan, Insum helped Technip Energies modernize its Oracle Forms material management applications.

Helping a Large County Streamline its APEX Applications

How Insum helped a large county adopt APEX best practices and successfully implement several new applications

Improving the Retail Experience with James Avery Artisan

James Avery Artisan Jeweler needed a POS application to efficiently connect their retail associates to its back-end EBS system for Buy Online, Pickup in store orders. Using APEX, Insum created an application that simplified the transaction and helped staff stay out front with their customers.