Easy Query Interface for External Business Warehouse Data Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Business warehouse systems, such as SAP BW, restrict queries to local access only, making it difficult to combine data from multiple systems and provide data access to mobile devices and other external sources.
Innovation Solution
The Easy Query system enables queries to be marked for external access, providing access points with fixed parameters and allowing data consumption through APIs like SOAP, REST, or RFC, enabling remote data access and combination of analytical and transactional data from various sources within a single application.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If queries are restricted to local access only within the business warehouse system, then system security and data integrity are maintained, but external systems and mobile devices cannot access or consume the query data
Solution Approach 1:
The patent introduces an intermediary component that sits between the business warehouse system and external consumers. This intermediary exposes queries through standardized protocols (SOAP, REST, RFC) without requiring changes to the core BW system, thus enabling external access while maintaining system integrity and security boundaries.
Solution Approach 2:
The patent creates a universal query access interface that can serve multiple types of consumers (mobile devices, external systems, analytics tools) through a single standardized mechanism. This multi-functional approach allows the same query infrastructure to serve both internal and external users without requiring separate systems.
2Adaptability or versatility
If queries are made accessible to external sources, then data consumption from mobile devices and external systems is enabled, but additional software and integration complexity are required
Solution Approach 1:
The patent implements a universal access layer that works with multiple communication protocols (SOAP, REST, RFC) and various consumer types through a single standardized interface. This eliminates the need for separate integration software for each external system type, significantly reducing software integration effort.
Solution Approach 2:
The system enables external systems to consume queries directly through standardized web service interfaces without requiring additional proprietary software or complex configuration. The self-service nature of the standardized protocols allows external consumers to access data independently.
3Adaptability or versatility
If multiple data sources from different systems are combined, then comprehensive analytics are achieved, but system integration complexity increases
Solution Approach 1:
The patent creates a universal data access interface that can consume queries from multiple different business warehouse systems and external data sources through standardized protocols. This single universal interface handles integration with diverse systems without requiring separate integration architectures for each source.
Solution Approach 2:
The patent merges data from multiple disparate systems (BW systems, external databases, transactional systems) into a single unified query interface. This consolidation allows comprehensive analytics across all data sources through one integrated access point rather than multiple separate integration paths.
Data Source
AI summary
A system and method for using an easy query in a business warehouse system environment that includes external end-user systems. A method includes providing a flag in a query to a business warehouse data system, the flag marking the query for access to the query by sources external to the business warehouse data system. The method further includes providing, by the at least one data processor the access points having a number of parameters that are fixed at a design time associated with the query, providing a query result to the access points of the sources external to the business warehouse system according to the number of parameters. The system and method provide an easy way of creating an access function at design time, as well as an easy way of result set consumption provided by the function at runtime.