Caché connection to Sql Developer

Question

Bálint KONCZ · Dec 2, 2019

Hello Community,

I would like to work in SQL developer with the tables from Caché.

Is it possible with JDBC tool?

What is the whole process in order to work in SQL developer? I have the access information to Caché, but i can only choose in SQL Developer software only Oracle or MySQL database type, therefore i think, that have to install any other tool.

Thank you in advance for your help!

br,

bálint

Discussion (2)0

Eduard Lebedyuk · Dec 2, 2019

You can use any ODBC/JDBC database management software. I use DataGrip. It has code completion for table/field names and standard SQL syntax.

Here's my URL template

jdbc:Cache://{host}[:{port}]/{database}

0 0

Robert Cemper · Dec 2, 2019

CACHE & IRIS have JDBC drivers as part of the installation.

see this:
https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGJD_preface

an example for SQLdeveloper using 3rd party JDBC (here DB2) might be a guideline how to proceed
https://www.db2tutorial.com/getting-started/sql-developer-db2/

2 0