System for business intelligence data integration

摘要

A system for business intelligence data integration, comprising a query transformation server that receives an SQL query, applies transformations to the query, and embeds the transformed query into an XML web services request. At least a portion of the XML web services request is sent to a business intelligence engine web service. An XML response is received from the business intelligence engine web service. The system applies modifications to the XML response including extracting SQL from the XML and adding back the visualization-specific column to generate a complete SQL response, which is provided to the client device.

主权项

1. A system for business intelligence data integration, comprising:
a query transformation server comprising at least a plurality of programming instructions stored in a memory and operating on a processor of a network-connected computing device and configured to:
connect to a plurality of business intelligence engine web services via a network;receive a SQL query from a client device;apply a plurality of transformations to the SQL query including at least removal of a visualization-specific column from the SQL query and embedding the SQL query into an XML web services request;provide at least a portion of the XML web services request to a business intelligence engine web service;receive an XML response from the business intelligence engine web service;apply a plurality of modifications to at least a portion of the XML response including extracting SQL from the XML and adding back the visualization-specific column to generate a complete SQL response; andprovide the SQL response to the client device; anda plurality of communication adapters configured to facilitate bi-directional communication between query transformation server and other systems via a network.