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; and provide the SQL response to the client device; and a plurality of communication adapters configured to facilitate bi-directional communication between query transformation server and other systems via a network.