VERSATILE DATA VIRTUALIZATION DRIVER
Methods and systems for data virtualization are described. A computing system may transmit, by a client device and to a data virtualization server, a data virtualization query directed to a data source. The computing platform may receive, by the client device and from the data virtualization server, driver provision information comprising data source connection information for the data source and a native version of the data virtualization query. The computing platform may provision, at the client device and using the driver provision information, a native data source driver corresponding to the data source. The client device may transmit, to the data source and using the provisioned native source driver, the native version of the data virtualization query. The client device may receive, from the data source, data source results, and may display the data source results.
1 . A method comprising:
transmitting, by a client device and to a virtualization server, a data virtualization query directed to a data source;
receiving, by the client device and from the virtualization server, driver provision information comprising data source connection information for the data source and a native version of the data virtualization query;
provisioning, at the client device and using the driver provision information, a data virtualization driver corresponding to the data source, wherein the data virtualization driver is configured to bypass the virtualization server for direct data retrieval from the data source;
transmitting, to the data source and using the data virtualization driver, the native version of the data virtualization query;
receiving, from the data source, data source results; and
displaying the data source results.
2 . The method of claim 1 , further comprising:
prior to transmitting the data virtualization query, transmitting, to the virtualization server, connection information for the data source, wherein the connection information is used to introspect the data source.
3 . The method of claim 1 , further comprising:
prior to transmitting the data virtualization query, defining a plurality of data views, wherein the data virtualization query is expressed in terms of one of the plurality of data views.
4 . The method of claim 1 , wherein the virtualization server is further configured to:
identify a data quantity requested by the data virtualization query, and
compare the data quantity to a data volume threshold.
5 . The method of claim 4 , wherein the virtualization server is further configured to:
send, based on identifying that the data quantity meets or exceeds the data volume threshold, the driver provision information.
6 . The method of claim 4 , wherein the virtualization server is further configured to:
based on identifying that the data quantity is less than the data volume threshold:
transmit the native query to the data source,
receive, from the data source, the data source results, and
transmit, to the client device, the data source results.
7 . The method of claim 1 , wherein the data virtualization query comprises a query for a single data source of the data source.
8 . The method of claim 1 , further comprising:
caching, using the data virtualization driver, the native version of the data virtualization query.
9 . The method of claim 8 , wherein the caching is based on predicted queries to be sent from the client device for a particular application.
10 . The method of claim 1 , wherein the data virtualization driver is specific to an application at the client device.
11 . The method of claim 1 , wherein the driver provision information further includes provision partition clauses defining logical breakpoints used to split the data source result into a plurality of sub-results.
12 . A computing system comprising:
one or more processors;
memory storing computer executable instructions that, when executed by the processor, cause the computing system to:
transmit, to a virtualization server, a data virtualization query directed to a data source;
receive, from the virtualization server, driver provision information comprising data source connection information for the data source and a native version of the data virtualization query;
provision, using the driver provision information, a data virtualization driver corresponding to the data source, wherein the data virtualization driver is configured to bypass the virtualization server for direct data retrieval from the data source;
transmit, to the data source and using the data virtualization driver, the native version of the data virtualization query;
receive, from the data source, data source results; and
display the data source results.
13 . The computing system of claim 12 , wherein the memory stores additional computer executable instructions that, when executed by the one or more processors, cause the computing system to:
prior to transmitting the data virtualization query, transmit, to the virtualization server, connection information for the data source, wherein the connection information is used to introspect the data source.
14 . The computing system of claim 12 , wherein the memory stores additional computer executable instructions that, when executed by the one or more processors, cause the computing system to:
prior to transmitting the data virtualization query, define a plurality of data views, wherein the data virtualization query is input via one of the plurality of data views.
15 . The computing system of claim 12 , wherein the virtualization server is further configured to:
identify a data quantity requested by the data virtualization query, and
compare the data quantity to a data volume threshold.
16 . The computing system of claim 15 , wherein the virtualization server is further configured to:
send, based on identifying that the data quantity meets or exceeds the data volume threshold, the driver provision information.
17 . The computing system of claim 15 , wherein the virtualization server is further configured to:
based on identifying that the data quantity is less than the data volume threshold:
transmit the native query to the data source,
receive, from the data source, the data source results, and
transmit, to the client device, the data source results.
18 . The computing system of claim 12 , wherein the data virtualization query comprises a query for a single data source of the data source.
19 . The computing system of claim 12 , wherein the memory stores additional computer executable instructions that, when executed by the one or more processors, cause the computing system to:
cache, using the data virtualization driver, the native version of the data virtualization query.
20 . One or more non-transitory computer-readable media storing instructions that, when executed by a computing system comprising at least one processor, a communication interface, and memory, cause the computing system to:
transmit, by a client device and to a virtualization server, a data virtualization query directed to a data source;
receive, by the client device and from the virtualization server, driver provision information comprising data source connection information for the data source and a native version of the data virtualization query;
provision, at the client device and using the driver provision information, a data virtualization driver corresponding to the data source, wherein the data virtualization driver is configured to bypass the virtualization server for direct data retrieval from the data source;
transmit, to the data source and using the data virtualization driver, the native version of the data virtualization query;
receive, from the data source, data source results; and
display the data source results.