SQL Clients
The InsightEdge JDBC driver can be used with existing visualization tools, to gain insight into the data grid by using the specific tool-provided features such as drag and drop.
Examples:
SquirreL
To install SquirreL for use with the InsightEdge Platform:
-
Download and install SquirreL.
-
Copy all of the GigaSpaces JAR files (located in $GS_HOME
\lib\required
) to the squirreLlib
folder. -
Copy all of the InsightEdge JAR files (
$GS_HOME\insightedge\lib\jdbc
) to the squirreLlib
folder. -
Start SquirreL.
-
Click the Drivers vertical tab on the left, and then click + to add a new driver.
-
Click the Aliases vertical tab on the left, and then click + to add a new connection. Sample URL:
jdbc:insightedge:url=jini://*/*/mySpace?locators=127.0.0.1&groups=xap-15.0.0
-
Create a connection to the GigaSpaces data grid.
-
Run a test query, for example
SELECT * FROM Product;
(the data grid was filled withProduct
objects in advance).