5 time-saving tools for EHS compliance

We all know the struggle of getting things done with shortened staff without compromising the quality of our work, especially in EHS. Locus Technologies’ Locus Platform (LP) offers multiple options to ease your complexity by providing a truly SaaS platform packed with some nifty apps. Here are some tools in LP that can help you utilize your workforce much more efficiently:

 

1) Dashboards tailored to your needs

Every software has built-in report and dashboards, but they may not meet all your needs when purchased off the shelf. If you need a new report, chart, or other visualization of your data, it usually incurs a custom software development charge, but not with Locus Platform (LP). LP allows you to assemble the information you want in your chosen format (bar or line charts, maps, tables, treemaps, diagrams, etc.) and share your custom dashboards and real-time information/data with your team.  In addition, the views and dashboards export to Excel, so you can easily integrate with commonly used tools and further mine the data. At the enterprise level, powerful dashboards will help you understand the status of each facility based on a matrix  you design. With the LPs flexibility, facility information can be automatically populated based on the user credentials, saving your team time and frustration.

Screenshot of Sustainability reporting dashboard on Locus Platform

 

2) Simplified Sustainability Reporting

Locus Platform’s Sustainability application and calculation engine support simultaneous calculations using multiple methods for various reporting programs including EPA, California ARB, CDP, TCR, DJSI, and others. This allows users to input data only once and utilize it to report to multiple federal, state, and voluntary reporting programs, according to their required format. The application will also support direct electronic reporting formats for many reporting programs, so that additional manual transcription and submittal of data are no longer necessary. This is a very powerful tool and a huge advantage to customers in terms of improving efficiency, while reducing costs.

Locus Platform Sustainability

 

3) Integration

Integration, if done correctly, can save you a great deal of time and headache during some of the most tedious and cumbersome tasks in EHS data management. Locus Platform (LP) has built in a unique point and click integration application to enable connection with major databases or third-party systems that have open API (Access privileges). Some integration, database, and communication standards and methods that are supported include OLE compliance, SOAP, COM, Java, XML, web services, ODBC/ODMA/SQL/Oracle, VIM, and MAPI. LP also works well with MS Excel and provides a powerful two-way synchronization allowing users to download parts of the database to Excel, then work, edit, and verify or append data on their local copy of Excel where they have no internet connection. Any revisions they perform to the downloaded data in Excel can be automatically synchronized back to the Locus Platform application. During the process, a complete audit trail will be preserved. This can be a great time saver especially when you are sending large volumes of valid values in a database or if you are migrating any historical data.

Locus Technologies Integration

 

4) Mobile

Locus’ Mobile application allows you to sync with your server to create data collection profiles on a mobile device, whether it’s your phone or a tablet. It will allow you to click through and enter data on the device even when you are offline. Data validation is performed in real time and is stored locally on the device, once the phone reaches an internet signal, it will sync with your server, and the data will automatically be updated in Locus’ cloud-hosted solution. What’s more, Locus Mobile works seamlessly with both EIM and Locus Platform.

Using Mobile you receive the benefits of data entry directly on the mobile device, with immediate data availability on the cloud when you reach an internet signal. Other advantages of using Mobile include location metadata and mapping integration, bar-code/OR code scanning, voice recognition, and form customization. If you’d like to know more about the Locus Mobile application, check out the Top 10 cool features in Locus Mobile.

Locus Mobile integrates with Locus Platform

 

5) XML Exports

Locus has prioritized enhancing its GHG application in Locus Platform to make it easy to manage GHG emission inventory tracking and reporting requirements. Locus Technologies is the only software vendor that is a certified GHG verifier under the State of California’s AB32, and has performed the most GHG verifications in California since 2015. The State and Federal eGGRT web portals are notoriously cumbersome and require a significant amount of your time to input all the required data and generate your report. But with XML support, you can bypass almost the entire data entry process, and complete your submittal within a few minutes.  XML reports support many greenhouse gas subparts, including EPA GHG Subparts C, D, W, and NN.  And because data entry for EPA and CARB is consolidated in the XML GHG application, it eliminates the need to maintain separate agency spreadsheets and software. Additional reporting programs are also adding support for XML submittals, such as EPA’s eManifest.  This functionality can be a huge time saver for anyone working with these online regulatory reporting tools.

Locus Platform XML export

 

 

EHS software switch to multi-tenancy: Too late to switch for many vendors

The announcements by several EHS software vendors this Fall caught my attention. After offering their software on-premisses for over a decade, suddenly many are discovering and planning to introduce multi-tenant Software-as-a-Service (SaaS) while promising to continue to maintain their current on-premises or single tenant offerings. In essence, they are introducing multi-tenancy as if it were a new version of their software. This plan is not going to work! Let me explain why.

Most public announcements begin something like this: In the next several years we plan to expand our software offerings and offer our customers the option to move from their current on-premises solution to the cloud. However, is this even possible? What they consider the “cloud” may not be a true multi-tenant cloud. That train departed years ago, and most of the current EHS software vendors missed it. While multi-tenancy has been a game changer in the tech industry, many are uncertain of exactly what makes an application “multi-tenant” or why it matters.

Locus Multi-Tenant Software

There is a considerable degree of (intended) confusion in the EHS software space when it comes to the definition of a real cloud or better said, multi-tenancy. Companies that are considering SaaS solutions for EHS software hear all sorts of things from EHS software vendors hoping to tap into the momentum of cloud computing. Many go as far as saying “sure; we can do multi-tenant, single-tenant, whatever tenant you need!” –anything to win the job. These vendors do not understand the real cloud.

Multi-tenancy is a significant shift in computing and requires an all-new approach to the software architecture and the delivery model from the ground up. It is transformational, and customers who intend to buy the next generation of EHS software should spend the time to understand the differences. More importantly, multi-tenancy is a principle, not a software version or an upgrade. It is not an evolutionary step; instead, it is a revolution in the software delivery model and it matters in the long run for the customer.

Multi-tenant architecture

Figure 1: The single-tenant model cannot easily be switched or “upgraded” to multi-tenant. The software architecture does not allow it for easy switch the same way as single family home cannot be “remodeled” to become a multi-tenant highrise. What differentiates multi-tenant application architecture is its effectiveness in achieving the same goal in a scalable and sustainable fashion.

Can anyone imagine companies like eBay, Salesforce, Google, Workday, or Amazon offering a “single-tenant” solution side by side to their multi-tenant clouds? I argue that any EHS software vendor who offers a single-tenant solution of any type, cannot be a serious contender in multi-tenant SaaS.

EHS software vendors with on-premise software applications or single-tenant web-enabled offerings are seduced by the seemingly low barriers to entry into the SaaS market with an architecture that leverages virtualization. This approach allows a software company to quickly offer subscription-based services of their legacy product to their initial customers. In the long run, however, this multi-instance approach just won’t scale economically. A recent wave of ownership change of EHS software companies is the best indicator that sold companies became victims of their initial success. A SaaS provider who leverages virtualization puts the long-term viability of the business at risk as more efficient SaaS competitors come to dominate the market.

Multi-tenant architecture

Figure 2: Single-tenant requires many more vendor resources. The resource costs are eventually passed to customers. Each upgrade of the application will require each customer to upgrade independently and the ability to implement tenant management tools and tenant-specific customizations is significantly limited. The benefit of multi-tenancy is that instead of 100 copies of the OS, 100 copies of the database, and 100 copies of apps, it has 1 OS, 1 DB and 1 app on the server with significantly less vendor resources required to manage it. And it is those savings that are on a long term passed to customers.

Multi-tenant architecture

Figure 3: Multi-tenant model requires less resources and easier (and rolling) upgrades (i.e. no version number necessary). Only one software instance and hardware stack for multiple tenants. All customers are always on the latest version of software. Locus Technologies figured this out in 1999. And they contribute their phenomenal success since then exactly to the multi-tenancy. They could scale up infinitely without adding proportional cost. Others cannot.

Multi-tenant architecture

Figure 4: “Can’t we create a separate stack for just this one customer? I promise it’s just this one…” Even a single installation for one “special” customer, breaks the multi-tenant model. Don’t do it.

I would also add that single-tenant (hybrid) cloud applications are worse than on-premise installment. Why? Because they are fake clouds. In single tenancy, each customer has his or her independent database and instance of the software. These instances may reside on the same or different servers. In this model, a customer is, in fact, outsourcing maintenance of their application (software and hardware) to a vendor (or their consultant) that is not likely equipped to perform these tasks. No single vendor in the EHS software industry is large enough to undertake maintenance of the single-tenant infrastructure on behalf of their customers regardless of how inexpensive hardware or software virtualization may be. Even if they offer their hosting on Microsoft Azure Cloud or Amazon Web Services (AWS), they still cannot guarantee multi-tenancy as these solutions address only hardware challenges.

The Economist magazine in 2004 described it: “Those forerunners also promised a software revolution by hosting the software applications of companies. But they failed because they simply recreated each client’s complex and unwieldy datacentre in their own basements, and never overcame the old problems of installation and integration with other software. With each new customer, the old ASPs had, in effect, to build another datacenter; there were few economies of scale.”

To improve their position in a shifting marketplace, on-premises EHS vendors have found a way to market their solutions as “cloud-based” when they are not backed by the fundamental principle of what that means. Considering the large investment that is associated with the purchase or licensing of EHS software, it is critical for customers to be able to tell a true cloud product from a fake one. But how can you spot a fake?

Just ask the EHS software vendor these four questions:

  1. Do you support both single-tenant and multi-tenant deployments of your software?
  2. Does your software have version numbers? 
  3. Do you charge for upgrades?
  4. Can we install your software on our infrastructure?

If the answer to any of these questions is yes, the vendor is not committed to only multi-tenant architecture, and you should not move to their “cloud.”

Multi-tenancy is the only proven SaaS delivery architecture that eliminates many of the problems created by the traditional software licensing and upgrade model where software is installed as a single-tenant application on a customer’s premises or at a customer’s or vendor’s data center. In contrast, in multi-tenancy, all customers access the same software on one or a set of linked servers.

Multi-tenancy requires a new architectural approach. Companies have to develop applications from the ground up for multi-tenancy. Once companies commit their limited financial resources to one architecture, it becomes nearly impossible for them to switch to the multi-tenancy model, no matter how many resources they have available. Moreover, for this reason, I am skeptical that many current vendors will be able to make a switch to multi-tenancy fast enough.

A vendor who is invested in on-premise, hosted, and hybrid models cannot commit to providing all the benefits of a true SaaS model due to conflicting revenue models. Their resources are going to be spread thin supporting multiple versions rather than driving innovation. Additionally, if the vendor makes the majority of their revenue selling on-premise software, it will be very difficult for them to fully commit to a true SaaS solution since the majority of their resources will be allocated to supporting the on-premise software.

And if they suddenly introduce a “multi-tenant” model (after selling an on-premises version for 10+ years) who in the world would want to migrate to that experimental cloud without putting the contract out to bid to explore a switch to well established and market-tested true multi-tenant providers? Even Google and Microsoft are playing a catch-up game with Amazon’s AWS when it comes to cloud hosting business. The first mover advantage when it comes to multi-tenancy is a huge advantage for any vendor.

In summary, an EHS software vendor can be either truly multi-tenant or not. If a vendor has installed their software on somebody’s else hardware and runs multiple instances of that software (even if the code base is the same) they are not and will never be true multi-tenant.

Multi-tenant architecture

Figure 5: Where do you want your software to reside? In multi-tenant or single -tenant infrastructure? If multi-tenancy is attempted on old infrastructure or legacy application upgrade watch out. After vendor built the first few floors of that skyscraper, there is no easy way to replace the foundation. You will be lucky if they end up like the tower of Pisa or Millennium tower in San Francisco. To keep the tower alive they will have to do constant underpinning of the foundation and restrict access to the structure. And you, the customer, will pay for it. That is what many customers of single-tenant EHS vendors are facing today.

Therefore, when considering a SaaS solution, make sure that the vendor is a true SaaS vendor who is solely committed to the multi-tenant SaaS delivery model and has invested in a true multi-tenant platform. This is the only way to reap all the benefits that a SaaS model has to offer.

Solving water utility data management challenges—one conversation at a time

Last month I got the opportunity to attend AWWA Water Quality and Technology Conference in Toronto, Canada. I was very enthusiastic to interact first hand with end-users of different water technology tools, and interact with other water technology professionals.  It’s one thing to design software and support it, it’s a whole different thing to sit and talk with the real customers and real end users and get unfiltered feedback.

As a Product Manager, I’m usually connected with our customers by the various email and messaging systems that provide an endless amount of documentation, but nothing can substitute for an in person conversation. I heard first-hand how there is a need to change existing business practices and stop using older, non-integrated systems that only provide part of the data solution. This scenario is not a new problem; there is a need by most water entities to centralize data, and more easily load, share, analyze and report data. I have had this general conversation many times, but the more in depth, one-on-one conversations about sample planning and data collection provided the most useful feedback. I had the opportunity to give a brief demonstration on “Scheduling and collecting routine water samples using Locus Mobile and EIM” at AWWA, which provided a great venue for candid feedback. Based on these conversations, I have summarized a list of frequent challenges that users encounter during their water sampling process and how they can be solved using the right tools or better communications.

Challenge 1: Finding a flexible sampling planning tool

The overall feedback I heard from attendees is their sampling is generally routine, but the planning tools need to allow flexibility in terms of different sampling intervals and date ranges, different field and analytical parameters, and account for location grouping. Using a well-designed application can pull together all of this detailed information, and can provide a summary view of the individual samples. A manager can easily view sample status, and whether the sample is complete, in process, or planned.  A well-designed application can also generate the chain of custody (COC), and lab and sample shipping date information and labels per sample, which is a huge time saver. This type of sample tracking detail seemed to be very useful to many conference attendees to help ensure they are in regulatory compliance with required sampling frequencies. A key feature to look for is an application that is flexible enough that it can allow one-time, unplanned sample events such as water main breaks, customer complaints and schedule changes, and can handle complex multi-year routine sampling with ease. As a plus, it’s easy for you or your manager to know where you stand at any time.

EIM screenshot of sample planning edit form with email notification and calendars popouts

Challenge 2: Eliminating data entry errors caused by hand data entry

Everyone I talked with had dealt with data entry errors and fixing bad data when it was transcribed from field notes to Excel or other programs.  Everyone wanted a better way to streamline the error prone data collection process.  Many attendees were interested in an alternative to the pencil/paper/clipboard method and had goals to move to tablet or smartphone for data collection.   As a field data collection mobile product manager, this was my area of expertise.  The universal wish list for mobile field applications included:

  • Easy to use and set up
  • Built in data validation to catch data entry errors at the source
  • Direct upload to a data system so the end of the day all the daily samples were in the system with the push of a button
  • Prepopulating locations especially for large water systems
  • Complete field instructions for samplers on what to collect and where to collect it to eliminate missed samples
  • Smart tracking to know on a daily/weekly basis, what samples were collected and what samples were still outstanding
  • Integrated with sample planning tools (See challenge 1) to automate the sampling instructions and track the data collection activities vs plan

Locus Mobile

Challenge 3: Getting the most out of their software, especially regarding updates

Everyone one is aware that software updates all the time.  Sometimes its security enhancements and sometime feature enhancements or bug fixes.  Based on feedback from attendees, a source of frustration is getting a software update and not knowing what was updated or how best to incorporate a new feature/enhancement into their established process.  There was also concern for impact to an established routine with field crews that were used to the existing way of doing things. Even if a functionality improved the workflow, enhancements are only valuable to a user if they understand how to use them and how to incorporate them into their existing process.

Some suggestions from the attendees included:

  • Concurrent documentation updates with software updates
  • “Quick start” guides for new functionality
  • Online training on the new functionality with recording for later viewing
  • Heads up on what is coming in the next several months so they can do strategic planning (sharing the roadmap)
  • Sandbox environment to test the enhancements before going in production so they can plan how to incorporate the features into their process and train field crews

Mobile applications, which appear very simple to the users, are in reality complex software and require careful integration with the receiving database for a range of complex use cases.  This makes rolling out new mobile features challenging for both the developers and the users.  Enhanced customer/developer communication along with a sandbox environment can go a long way towards solving some of the inherent issues with rapid innovations and updates associated with cloud and mobile software.

Locus training and support

Take Aways

  • In person feedback beats everything
  • Communication is key.
  • Software tools are available and can solve a lot of the common data management challenges, but know what you want, know the problem you are trying to solve, and know it will take some time and effort but the end result will significantly improve your business processes.

 


About the author—Bill Donaldson, Locus Technologies

Bill Donaldson, Locus Technologies

Mr. Donaldson has 5 years experience in SaaS systems, performing Product Management and QA/QC of Locus Mobile iOS application and Locus’ Environmental Information Management system (EIM). While completing his B.S., Mr. Donaldson held several paid internships, where he configured a Relational GeoDatabase and a Database Management System (DBMS), for biological data entry.