Offload Querying/Reporting from the Host to Commodity Systems

Old architecture

Figure 1 — Old Adapter Architecture: Reporting Application with Remote Enscribe Database Access

Situation

A large European steel tubing manufacturer runs its shop floor control applications on an HPE NonStop system. The manufacturer periodically generated reports on Linux systems using a connectivity tool that remotely accessed the NonStop Enscribe database.

Problems

  1. The architecture was susceptible to network failures, timeouts, and/or slowdowns when operating at full capacity.
  2. The manufacturer needed access to its Enscribe data using standard ODBC connectivity for querying, reporting, and OLAP to leverage new analytical tools.
  3. The manufacturer needed to share the OLAP results back with the NonStop applications to optimize shop floor control.

Solution

New architecture

Figure 2 — New Architecture: Replicated and Transformed Oracle Database for Reporting and Analytics

Outcomes

HPE Shadowbase Products of Interest


Contact us or your HPE Shadowbase representative, and learn how Shadowbase software will benefit you.

Further Reading

Case Study: Large Manufacturer Uses Data Replication to Offload Online Host Processing and Enable New Business Applications

Related “Asymmetric Capacity Expansion” Case Studies:

  • Copy to clipboard