Case Study
Helping Valley Water Make Waves with Oracle APEX
Oracle APEX Development - Legacy Modernization
The Overview
Services: Oracle APEX Development
Solutions: Legacy Modernization, E-Commerce Solutions, Data Integration
Industry: Utilities, Public Sector
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 Talan.
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.
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.
The Technology Used
- Oracle APEX on-prem
- Oracle APEX on Autonomous Database (OCI)
- APEX Office Print
- Address validation with usps.com
- 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.
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.
Modernizing ERP for Construction with Oracle APEX and OCI
Discover how CGSI modernized its ERP solution, iXbat, for construction and public works using Oracle APEX and OCI. Improved scalability, security, and efficiency with rapid development and real-time analytics.
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.
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.
