Caché connection to Sql Developer
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
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}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/