Offload Querying/Reporting from the Host to Commodity Systems
Figure 1 — Old Adapter Architecture: Reporting Application with Remote Enscribe Database Access
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.
- The architecture was susceptible to network failures, timeouts, and/or slowdowns when operating at full capacity.
- The manufacturer needed access to its Enscribe data using standard ODBC connectivity for querying, reporting, and OLAP to leverage new analytical tools.
- The manufacturer needed to share the OLAP results back with the NonStop applications to optimize shop floor control.
- Use HPE Shadowbase Data Integration to offload querying/reporting from the host to commodity systems
- Use HPE Shadowbase Essentials (which includes SBDDLUTL) to convert Enscribe DDL into the target SQL database formats
Figure 2 — New Architecture: Replicated and Transformed Oracle Database for Reporting and Analytics
- Offloads querying/reporting from the host to commodity servers
- Converts Enscribe DDL into SQL formats to create the Oracle replicated database
- Introduces a new, upgraded architecture
- Creates new analytical functionality
- Enables local data access for queries with ODBC
- Replicates data bi-directionally, unleashing even more benefits from data sharing
HPE Shadowbase Products of Interest
- HPE NonStop Shadowbase Basic Data Integration Software (BE443AC/QSA51V6)
- HPE NonStop Shadowbase Advanced Data Integration LTU (BE444AL/QSA52V6)
- HPE Shadowbase Basic Application Software 1-8 core or 9+ core (WSA51V6T1/T2)
- HPE Shadowbase Basic Application Software LTU 1-8 core or 9+ core (WSA52V6T1/T2)
- HPE NonStop Shadowbase Essentials Software (BE446AC/QSA54V6)
Contact us or your HPE Shadowbase representative, and learn how Shadowbase software will benefit you.
Case Study: Large Manufacturer Uses Data Replication to Offload Online Host Processing and Enable New Business Applications
Related “Asymmetric Capacity Expansion” Case Studies: