The In-Grid SQL Query 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.
To install SquirreL for use with the InsightEdge platform:
- Download and install SquirreL .
- Copy all of the XAP JAR files (located in
<XAP-HOME>\lib\required) to the squirreL
- Copy all of the InsightEdge JAR files (
<XAP-HOME>\insightedge\lib\jdbc) to the squirreL
- 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:
Create a connection to the XAP data grid.
Run a test query, for example
SELECT * FROM Product;(the data grid was filled with
Productobjects in advance). ```