Case Study

Helping Valley Water Make Waves with Oracle APEX

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.


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.


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

Shopping Cart

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.

Water Planning Database

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.

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 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

Ready To Talk?

Some of our other case studies

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.

Helping a Manufacturer Modernize with APEX

How Insum helped an architectural product manufacturer modernize by migrating their “satellite applications” and selected Oracle Forms apps to Oracle APEX.

Pharmaceutical Regulatory Information

This leading pharmaceutical provider needed a custom application to ensure regulatory compliance. Oracle APEX and Oracle’s Autonomous Database were the answer.