Creating and Updating a Microsoft Server SQL or Oracle Workgroup Database

The purpose of this post is to provide users who plan to use or currently use Microsoft SQL Server or Oracle databases for InfoNet and/or InfoWorks ICM with the resources they need to initially create and/or update their database to a new version.

It must first be mentioned that Innovyze does not recommend using Microsoft SQL Server or Oracle rather than the Standard Workgroup Database for InfoWorks ICM and/or InfoNet. Utilizing SQL or Oracle is a matter of customer preference. The Standard Database is designed to provide the best performance with the minimal configuration for the supported Innovyze Workgroup products. If it is preferred to utilize a Microsoft SQL Server or Oracle Workgroup Database, there is a great deal of information provided in the Workgroup Data Server Administration document:

To access the most recent Workgroup Data Server Administration document, you may find it at in the same location where the Workgroup Client (InfoNet and ICM) is downloaded.

In order to utilize SQL or Oracle databases, there will need to be a DBA (Database Administrator) in place who is experienced in managing these servers and applying scripts as these are operations that are not guided or performed by Innovyze Support. Continue reading

Share this post!
    Posted in InfoNet, InfoWorks ICM | Tagged , , , , , | Comments Off on Creating and Updating a Microsoft Server SQL or Oracle Workgroup Database

    “State of the Water Industry” Report Highlights R&R, Planning, and Water Tech in 15th Edition

    For the fourth year in a row, renewal and replacement (R&R) of aging water and wastewater infrastructure has been identified as the top challenge facing US water companies, according to the American Water Works Association (AWWA) State of the Water Industry report.

    This year marks the 15th edition of the report and analyzes responses from 967 North American water industry professionals from a range of small, medium, and large utilities.

    Continue reading

    Share this post!
      Posted in General, InfoMaster, SCADAWatch | Comments Off on “State of the Water Industry” Report Highlights R&R, Planning, and Water Tech in 15th Edition

      Come Rain or Shine.

      One of the (many) joys of working at Innovyze is its location. Since joining the company a couple of months ago, I’ve enjoyed a walk along the river most mornings before work. It’s not without its hazards. Bear in mind that this is Oxfordshire and therefore Inspector Morse country. I half expect to find a dead body floating among the reeds. Hasn’t happened yet. In fact, this morning I saw some live bodies as two ladies enjoyed a swim.

      That’s pretty unusual. Ducks, coots, Canada Geese certainly, even the occasional spaniel, but relatively few people swim in the Thames. Anyone who’s been watching the BBC documentary, The Five Billion Pound Super Sewer, will understand why.


      Continue reading

      Share this post!
        Posted in Career, General, Stormwater | Comments Off on Come Rain or Shine.

        Leaks and bursts: find, fix and prevent them

        Reservoir with low water level

        If you’re concerned about leaks in your water supply network – whether they’re steady, or sudden bursts – they can be addressed. Reducing leaks and non-revenue water (NRW) means happier customers and regulators, savings on wasted water, and fewer fines.

        You need to know:

        • where the leaks are
        • how bad they are, and their cause
        • how to manage the repair, with the minimum disruption to the community
        • how to avoid leaks in the future

        Continue reading

        Share this post!
          Posted in DemandWatch, InfoMaster, InfoNet, InfoWorks WS Pro, IWLive Pro, SCADAWatch | Tagged , , , , | Comments Off on Leaks and bursts: find, fix and prevent them

          Simulating Pump Transients through InfoSurge

          Power outage and Pump trips cause the pump operation changes. Power outage is the most severe case for pump transient events. There are two ways to simulate pump operations within InfoSurge.

          1- Pump Speed Change with creating speed ratio curves is the easiest way to simulate the pump operation change. The Pump Operation Change Data window is accessed by selecting a pump and selecting the Pump Operation Change   button in the Attribute Browser. This function is used to describe the pump/turbine operational changes during transient analysis.  A turbine is represented by the pump element with turbine-specific parameters in a surge model. A wicket gate can be specified for the turbine element to simulate the transients due to wicket gate changes. Continue reading

          Share this post!
            Posted in InfoSurge | Comments Off on Simulating Pump Transients through InfoSurge

            Atlas 14 Temporals for XPSWMM

            Back in January, we introduced the capabilities of XPSWMM that allows a modeler the ability to perform an ensemble-based critical duration analysis using the NOAA Atlas 14 Temporal Distributions. As the NRCS, formerly the Soil Conservation Service (SCS), retires the legacy rainfall distributions (Type I, IA, II, and Type III) and replaces with more location specific distributions, the question shifts toward is there a better distribution to consider over a standard nested intensity storm.

            The NOAA Atlas 14 rainfall depths are pretty well known. The temporals that NOAA published are not as well known.  How might one incorporate the temporals into an analysis with XPSWMM? There are two methods and we explore these below.

            The standard method to leverage the Atlas 14 temporal is the simplest yet time-consuming. It’s a copy and paste method between the application and the downloaded data from the NOAA Website. Download the Temporal distribution table data from the Temporals site for the Atlas 14 Volume, Region, and  Duration needed. The file (typically a CSV) is composed of four quartiles plus an all cases as a cumulative percent of depth.

            Continue reading

            Share this post!
              Posted in Stormwater, XPSWMM/XPSTORM | Tagged , | Comments Off on Atlas 14 Temporals for XPSWMM

              With Expansive Product Offering, Innovyze Maintains Commitment to Customer Success

              To help mark the one-year anniversary of XP Solutions and Innovyze joining forces, we sat down with VP of Product Management Greg Kowalsky to discuss the Innovyze approach to product development as well as to gain some insight into the future trajectory of Innovyze solutions.

              QUESTION: What problems are we trying to solve? Not from an engineering or mathematical standpoint, but from a human standpoint?

              Greg Kowalsky, VP of Product Management

              KOWALSKY: First and foremost, we’re trying to help our utility and consulting clients serve their communities. There is a cost optimization component where we want our products to help provide higher quality of service so clients can stretch a dollar farther. There is also a health and safety component that includes forecasting and predictive recommendations so that we can help them be prepared when adverse events occur.

              QUESTION: How does the Innovyze product team approach product development?

              KOWALSKY: We are proactively pushing functionality forward and we want to be more user-centric. Our goal is to understand the work our clients are trying to get done, so we consistently solicit their feedback to solve the challenges they face and strive to meet their needs. Continue reading

              Share this post!
                Posted in General | Comments Off on With Expansive Product Offering, Innovyze Maintains Commitment to Customer Success

                Predictive Flood Modeling: a Course for the Future

                In a recent keynote speech at Wharton’s Initiative for Global Environmental Leadership (IGEL), Innovyze CEO Colby Manwaring took the stage to address the current state of flood modeling techniques. The story? We can do better. Wet weather is becoming more unpredictable and the impacts are being felt by our communities. Municipalities, engineering consultants, and government agencies cannot continue to operate with outdated flood models that are plagued by inaccurate or incomplete data. If they do, residents and businesses are left vulnerable to flood risks and costs, compromising the integrity of local governments.

                Where We Come from Determines Where We Are

                The presentation began with a call to re-evaluate current flood modeling methods: “We need to consider our frame of reference if we are going to get to a solution, we need to consider our assumptions on where we are.”, Colby stated. Once we realize where we come from, we can plot a course for the future.

                Colby goes on to explain that what we currently know about flood forecasting, mapping, and modeling originated in the 1970’s. During this period, the foundation was laid for data collection systems and computing that was later used to shape flood modeling approaches.

                These methods were eventually codified and legislated in the developed world based on key data points extracted from weather patterns. The result was a reliance on risk assessments based on 100-year return intervals of flooding (probably from most people thinking “I won’t be here in 100 years, so I’m safe”). In an elementary sense, risk assessment was framed as: How likely is an area to flood throughout a 100-year time frame: once? 15 times? 40 times? This framework for risk assessment is relatable to most people, regulators and the public alike, but somewhere along the way the understanding was lost that a “100-year flood” is just a way of saying that every year there is a 1% chance of this flood occurring.  Probability this year is not affected by last year’s events, nor by future events – so we can have “100-year floods” anytime.

                Flood mapping based on this framework was, inevitably, misunderstood and flawed. Weather and rainfall input data was spread out, disjointed, and often assumed because it is hard to predict and codify. The inaccuracies in rainfall data contributed to the assumptions made for the overall model, which led to the need for tweaking of output data.

                Flood maps based on 100-year risk assessments emerged as a binary, or “single truth”, basis for flood insurance, infrastructure planning, and risk mitigation. Businesses and residents were either in or out of the floodplain, and insurance costs were­­ calculated accordingly. In reality, flood emergencies do not occur in an “in vs. out”, binary manner. They are more fluid than that – they are graduated events that we are trying to quantify with probabilistic methods – so floods don’t stop at some imaginary floodplain line.

                What Happens when the Map is Wrong?

                In 2012, Hurricane Sandy ravaged the US east coast and the Caribbean. Hundreds of thousands of housing units were destroyed and billions of dollars were spent in reconstruction efforts for infrastructure, homes, and businesses.

                In his first major address following the disastrous storm, former New York City Mayor Michael Bloomberg compared the FEMA 100-year flood maps to the actual flooding caused by the storm. According to the former mayor “two-thirds of all homes damaged by Sandy [were] outside of FEMA’s existing 100-year flood maps.”

                Continue reading

                Share this post!
                  Posted in General | Comments Off on Predictive Flood Modeling: a Course for the Future

                  InfoWorks ICM 9.0 Release

                  InfoWorks ICM 9.0 has now been released and is available for download from the Innovyze website under:

                  The What’s New which goes with the installer has a complete breakdown of the new features which have been included, some of those features have been explored further and demonstrated in part with examples below.

                  Continue reading

                  Share this post!
                    Posted in InfoWorks ICM | Tagged , , | Comments Off on InfoWorks ICM 9.0 Release

                    A neat Ruby script to delete all scenarios other than the base network

                    Within InfoWorks ICM, scenarios are a useful way of creating options, testing different network configurations and undertaking sensitivity analysis. However, once created and no longer needed, there is no easy way to delete them en masse. It is possible to delete them one by one using the ‘Manage Scenarios’ tool and it is also possible to write an SQL which deletes a list of multiple pre-defined scenarios.  Both of these approaches are time consuming.

                    There is a quicker, neater way of deleting all scenarios other than the base network by using Ruby Scripting within the user interface.  The ruby script will take the form of the below text:-


                    net.scenarios do |s|

                                    if s!=’Base’




                    The script is written in Ruby language within a text editor and needs to be saved as a file with extension type .rb.  Once this is created, you can open the network of choice and go to Network->Run Ruby Script and navigate to the location of the Ruby script.  This will then run the Ruby Script.  Once run, the Ruby script will appear within the list of recent scripts.  The Ruby script can also be associated with a custom action.

                    Ruby Scripting can be used within the user interface to manipulate data within the network, within the Open Data Import/Export Centres to filter and adjust import fields and also with ICM Exchange, the InfoWorks ICM API.  For more information on the Ruby scripting, particularly scripts that can be run within the InfoWorks ICM user interface then please contact the support team at


                    Share this post!
                      Posted in ICMLive, InfoWorks ICM | Tagged , , , , | Comments Off on A neat Ruby script to delete all scenarios other than the base network