Re: GUI based SQL Client for Apache Ignite

[Sri Ganesh V]

Thanks Shamim. 
Information provided was very useful.
I was able to query the cache using DBeaver. 

- Ganesh



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/GUI-based-SQL-Client-for-Apache-Ignite-tp8283p8372.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: GUI based SQL Client for Apache Ignite

[srecon]

Hi,
 you can use DBeaver open source SQL client to connect to Ignite cache.
After the installation of DBeaver from http://dbeaver.jkiss.org/download go
to
Database -> Driver Manager -> New
In the 'Settings' part fill in the requested information as follow:
<http://apache-ignite-users.70518.x6.nabble.com/file/n8366/Screen_Shot_2016-10-19_at_22.png>
 
Add all the above libraries shown in the screen shot. 
Start your Ignite server with default-config as shown below:
"
   

   
   








  

   
   
 
 
 
 
 
 127.0.0.1:47500..47509
 
 
 
 
 
   
   "

also copy the default-config.xml into any file such as
defaul-config-orgin.xml and set the client mode to true as follows:


test the connection. In the SQL editor panel, you can write any SELECT
statement. 

P.S. You can find other interesting informations in the sample chapter from
this  book <https://leanpub.com/ignite>   https://leanpub.com/ignite

Regards 
  Shamim




--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/GUI-based-SQL-Client-for-Apache-Ignite-tp8283p8366.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: GUI based SQL Client for Apache Ignite

[Sri Ganesh V]

Hi,

Thanks Val.

Will explore the web console application.


 - Ganesh



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/GUI-based-SQL-Client-for-Apache-Ignite-tp8283p8361.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: GUI based SQL Client for Apache Ignite

[vkulichenko]

Hi,

Yes, you can use JDBC driver in any JDBC tools. Only note that updates are
not supported for now, only SELECT queries.

There is also the Web Console application that has an SQL screen:
http://ignite.apache.org/addons.html#web-console

-Val



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/GUI-based-SQL-Client-for-Apache-Ignite-tp8283p8303.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

GUI based SQL Client for Apache Ignite

[Sri Ganesh V]

Hi,

Is there any GUI based SQL client (like SQL Developer) to access cache data
?

As ignite is shipped with a JDBC driver , was just curious to know if there
is a possibility of using the same with some existing GUI based SQL clients.


Thanks,
Sri Ganesh V



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/GUI-based-SQL-Client-for-Apache-Ignite-tp8283.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.