SQL Clients


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.

Examples:

SquirreL

To install SquirreL for use with the InsightEdge platform:

  1. Download and install SquirreL .
  2. Copy all of the XAP JAR files (located in <XAP-HOME>\lib\required) to the squirreL lib folder.
  3. Copy all of the InsightEdge JAR files (<XAP-HOME>\insightedge\lib\jdbc) to the squirreL lib folder.
  4. Start SquirreL.
  5. Click the Drivers vertical tab on the left, and then click + to add a new driver. image

  6. 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-14.0.0 image

  7. Create a connection to the XAP data grid. image

  8. Run a test query, for example SELECT * FROM Product; (the data grid was filled with Product objects in advance). image ```