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 like drag and drop.
1. Download and install SquirreL
2. Start SquirreL
3. Go to
Drivers vertical tab on the left and click + button to add a new driver.
4. Go to
Aliases vertical tab on the left and click + button to add a new connection.
5. Connect to the data grid
6. Run query, e.g. SELECT * FROM Product;
Currently there is a problem with RMI Classloader + Squirell, so as a workaround we copy our driver to the SquirreL lib folder. On Mac, copy jar as following: cp ./xap-calcite/target/gigaspaces-xap-jdbc-1.12.0-SNAPSHOT.jar /Applications/SQuirreLSQL.app/Contents/Resources/Java/lib.
Make sure you have Space deployed with some data and is accessible.
1. Download sqlline
2. cd ./xap-calcite/
4. To connect to the space:
!connect jdbc:xap:url=jini://*/*/space?locators=127.0.0.1 Enter credentials if your space is secured (or just press Return otherwise).
5. To list available tables:
6. Execute any query, e.g.
SELECT * FROM Product;
7. To close sqlline: