Generic Report Provider for On-Premise Query Framework Reuse
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Organizations face significant challenges in migrating existing application functionalities from on-premise to cloud-computing environments, as existing query frameworks require re-implementation, leading to increased costs and maintenance burdens, and the need to preserve prior investments in on-premise technologies.
Innovation Solution
A computer-implemented method and system that allows the reuse of existing on-premise query frameworks by transmitting requests to a generic report provider, checking authorization, and routing requests to appropriate backend ERP systems, using ODATA metadata and adapters to execute reports and render results on-demand, thereby enabling the integration of on-premise systems with cloud-based applications.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If existing on-premise query frameworks are re-implemented in cloud-computing platforms, then application functionalities can be migrated to the cloud, but prior investment costs cannot be saved and maintenance burdens increase
Solution Approach 1:
The patent creates a wrapper layer that copies and exposes the functionality of existing on-premise query frameworks through standardized web service interfaces. This allows cloud applications to access on-premise reporting capabilities without re-implementing them, preserving prior investments while enabling cloud migration.
Solution Approach 2:
The patent introduces a wrapper component as an intermediary between cloud applications and on-premise query frameworks. This mediator translates cloud-based service requests into on-premise framework calls, enabling integration without direct modification of either system and reducing overall complexity.
2Reliability
If on-premise query frameworks are accessed from cloud environments, then existing functionality can be reused, but integration complexity increases
Solution Approach 1:
The patent implements a universal wrapper interface using standardized web service protocols that can interface with multiple different on-premise query frameworks through a common architecture. This multi-functional approach enables functionality reuse across different systems while maintaining consistent integration patterns that reduce complexity.
3Reliability
If on-premise systems are integrated with cloud applications, then prior investments are preserved, but support for new devices becomes more challenging
Solution Approach 1:
The patent replaces direct mechanical/integration connections between on-premise systems and cloud applications with standardized web service interfaces. This substitution enables easier support for new devices (mobile phones, tablets) by using platform-independent web protocols rather than device-specific integrations.
Data Source
AI summary
The present disclosure describes methods, systems, and computer program products for allowing reuse of existing query frameworks to build new on-demand services. One design-time computer-implemented method includes transmitting a request for available reports to a report repository which is transmitted to a generic report provider on a backend enterprise reporting planning (ERP) system, transmitting a request to a report catalog user interface for a selected report returned by the generic report provider, transmitting a request for metadata to the generic report provider. One run-time computer-implemented method includes receiving a data request for bound result set elements provided by on-demand services, checking authorization for access using an authorizations repository, requesting routing information for applicable back-end ERP systems from a report repository, routing requests to a generic report provider of an appropriate backend ERP system, and triggering a report execution using a corresponding adapter for a query framework on the ERP system.