Hello, I'm using the InterSystems IRIS connector for Power BI to connect to our Iris for Health database, using Direct Query.

I have a column [Company] which is datatype bigint, and as far as I can tell the data is 2 for most (or all?) records.

When I bring the data into Power BI, every row shows as NULL (I think it should be 2 for most)

= Table.SelectRows(Table, each [Company] <> null and [Company] <> "")

-- removes all rows

Hi,

Looking for some guidance on setting up IRIS to use single sign on to authenticate with ADFS.

We have a request for users to automatically launch IRIS without the need to login, the user will be authenticated by Single Sign on (SSO) against ADFS.

Do we need to have a authorization server as well as a client, ADFS will handle all the authentication side, so would it be a case of configuring IRIS client up to communicate with ADFS, following the link below?

I am looking for any examples on hoe to use http request to connect to S3, list buckets and loop thru them to download files recursively.

Hi Guys,

Our clients are running Zen pages from Internet explorer and able to print with no issues but since they upgraded to Edge the can't print anymore, the user can select the printer from the listbox but it says "Printer Unavailable" ?

so far they installed MSDWebCient.msi and also set Edge to run in IE mode following these steps :

I am trying to do a rewrite using the webgateway-nginx docker container but getting an "unknown directive sub_filter' message. How can I add additional nginx modules into a webgateway nginx container?

Has anyone experienced exporting a deployment file and when deploying it, it is empty?

IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2021.1 (Build 215_0_21129U) Wed Sep 29 2021 10:10:37 EDT [HealthConnect:3.3.0] [HealthConnect:3.3.0]

Hi!

I'm playing with OAuth2 with FHIR Server, but returned tokens cause 401 or 403 errors when trying to get FHIR resources.

I tried using fhir-client.js and Postman. Access tokens returned have been failing for both, with a 401 when trying through fhir-client.js and a 403 using Postman.

Here are my settings:

Hi All,
I want to write testcase in objectscript but stuck at this point where I am getting a DynamicObject from the class method and how can I assert this and check it is okay.
Also if in any case error It will throw error custom exception class that I created. How to handle assertion for exception in this case also.

Hello Community,

Is there any way to avoid generating the built in validation inside the classmethod from the .disp class definition. I've added the resource with path parameter as integer in swagger 2.0 open API. The class method(in my case getRandom is the class method) inside .disp handles the integer validation by default. Is there a way to avoid/remove by default.

default validations for Integer

Hi,

I am trying to input an entire xml into a sql server table. I am doing this via an operation in Ensemble.

I keep getting the following error

[SQL Server]XML parsing: line 0, character 0, unrecognized input signature

I have setup the table with a column parameter XML.

Here is the request object that is being sent to the store procedure

I have updated some legacy VB/ASP.NET code and changed the references of InterSystems.Data.CacheClient to InterSystems.Data.IRISClient. I am struggling with the code as I am not a .NET expert and there is little or no documentation.

Hi,

I'm trying to access to my datas stored in a RecordMap from SQLAlchemy, and I need to access to any tables already created before using SQLAlchemy.

Here is some part of my code :

TestBase: