[Video] Using SQL with InterSystems IRIS

Announcement

Anastasia Dyubaylo · May 6, 2022

Hey Developers,

See how you can get high-performance relational access using SQL to manage data within your InterSystems products:

https://www.youtube.com/embed/7l-YT5y-nJo
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Subscribe to the InterSystems Developers YouTube channel and stay tuned!

Discussion (2)0

Andrew Barber · May 9, 2022

That's great.

Right at the end it says you can use your favourite SQL client to write SQL code against IRIS. Does this include SQL Server Management Studio, only I am not being successful in getting this achieved at my work?

What SQL clients are best used for IRIS?

Many thanks.

0 0

Andrew Barber · May 9, 2022

I should add, I'm not having much success in terms of reporting. We don't have (or I can't get) the Management Portal, and I can't seem to use SSMS to write queries against the data, and in Power BI, the IRIS connector isn't allowed for dataflows.

I am missing something super obvious, I know I am!

What tools do other people use to write reports against IRIS?

Thanks.

0 0