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.

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.

Many thanks for your reply.

I'll have a read up through the above, which should hopefully answer most of my queries. Intersystems SQL seems to what I need.