Need to connect ensemble with SQL server management studio using ODBC or jdbc

Question

Question

Ishan Srivastava · Feb 22

#JDBC #ODBC #SQL #Studio #Ensemble #InterSystems IRIS

Need to fetch data from SQL server management studio to ensemble, using jdbc or ODBC.

Step by step solution would be highly appreciated.

Product version: IRIS 2021.1

Discussion (3)3

Log in or sign up to continue

score 1 · Answer 1 · 2024-02-22T11:13:11-05:00

If using JDBC you can use a JDBC SQL Software like DBeaver or Squirrel SQL.

DBeaver officially supports InterSystems IRIS | InterSystems Developer
How to create a database connection in DBeaver - DBeaver

score 0 · Answer 2 · 2024-02-22T11:40:43-05:00

You mention you need to connect to Ensemble but your product version says IRIS. I assume you need to connect to IRIS.

In Windows you can install IRIS ODBC drivers and in Control Panel create a DSN to connect to a IRIS Namespace. Then in SSMS follow the instructions to connect to an external database using an ODBC DSN (I have no experience on this).
Make sure you use the correct 32 or 64 bits driver and DSN definitions (in Windows you can define 32 or 64 bits DSN), I'm not sure if Microsoft SQL Server Management Studio (SSMS) is 32 or 64 bits application, find that out first.

Another option is to use IRIS JDBC drivers, make sure you install the correct Java JRE for the JDBC drivers you are using.

Since this is windows, maybe ODBC is more convenient.

score 0 · Answer 3 · 2024-02-22T17:35:14-05:00

Here you can find an example about a jdbc connection, in the example is with MySQL, you only need to change the jar file and the class name.