cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect KDB to dbvisualizer.

sheroopratap
New Contributor
Hi All,

  I have a KDB stack all running fine. (Thanks to this group for the help).
  I want to connect dbvisualizer (link here: https://www.dbvis.com/) to my KDB or RDB to visualize the tables. 

  Just to bring in notice dbvisualizer doesn't support KDB implicitly but allows to configure with odbc connections.
  
  Could please anyone can help to set up the dbvisualizer with KDB. Or is there any other tool supported like dbvisualizer.

Thanks and Regards,
 Pratap
4 REPLIES 4

rahul_asati04
New Contributor
As dbvis supports jdbc connection, I have tried doing the setup using that which is working. Steps are mentioned below.
Also, I have not explored dbvis much so I don't know what all advance options it will support but at least basic operations are working.

 Or you can build also. Details here - https://code.kx.com/v2/interfaces/jdbc-client-for-kdb/

Copy this file to your QHOME.

2. Copy 's.k' file to QHOME if it is not present.
You can also get it from here -  https://github.com/KxSystems/kdb/blob/master/s.k

3. Now in dbvis, go to Tools->Driver Manager  and add a new driver. In the panel,
- give a name
- in URL Format specify: jdbc:q:server:port (example:  jdbc:q:localhost:5000)
- Add jdbc.jar file 
- After above step, 'Driver Class' option will show the available driver. Select that if not selected.

More details can be found here:

4. Go To Database-> Create Database Connection.  In the wizard select the driver you created in step 3, and in 'Database URL' field mention ' jdbc:q:localhost:5000' (replace server and port)

Thanks a lot, Rahul it works.
I am able to integrate dbvis with KDB server.

Regards,
Pratap

Hi Pratap,

I can help answer your question about other tools - along with our solutions stack which Rahul referred to (see Kx Dashboards), Kx also offer a free IDE called Kx Developer which has a Grammar of Graphics based visualization library written in q that might do the trick for you.

Some good visualization examples on the github here.

HTH,
Rebecca
Rebecca Kelly | Kx Technical Evangelist | ML COE US | Kx |  (646) 630-4381 | rebecca@kx.com




rahul_asati04
New Contributor
You could also try:

-  qstudio.

KX also has its own product.