when doing ETL process from cache database to mysql database(ods) and to another mysql database(dwd).

There are lots of DR columns in one table.

In the first step we need two databases to be totally consistent(ods=cache database)

However, the DR column in another database lost its meaning and become to normal number.

In the last step we do the data governance in ODS to DWD. My question is how to write sql without many `join` in this step.

I'm trying to leverage the workflow from this repo so I can create an online demo for my project: https://github.com/intersystems-community/iris-google-run-deploy-template.

I saw that we need to ask for the service account token because I mistakenly tried to obtain my own and obviously was getting permission errors.

So how should I go about getting the token? Thanks!

I am trying to use IRIS for Health as a Facade for an external FHIR Server, where IRIS provides the proper authentication.
The client authenticates using a bearer token obtained from the IRIS OAuth2 server via a jwt client assertion.
The IRIS endpoint, however, returns a 401 as soon as I remove the Unauthenticated access

Is there w way to make this work through configuration?

What table would I find the MRN in? I'm trying to write a crystal report and pull that field, but I cannot seem to find it in any of the tables, to be able to add to the report.

Thank you in advance for any help.

Hello community

I sent a http post message with a large message body (approx. 200 kB) to a standard EnsLib.REST.GenericService using a standard EnsLib.HTTP.InboundAdapter.

When inspecting the message in the message viewer I expected to see a HTTPMessage XML in the Contents preview, but I found a GenericMessage with no HTTPHeaders section. After a while, I found out that the display in the message's Visual Trace differs from what is shown, when going to the View Full Contents view in the Contents tab of the message viewer.

I'm fairly new to InterSystems and I've been tasked with building a portal that can show DataCheck States among other details, the GetStateBySystem seems to be fit the bill but I don't see a why to call directly from the .Net SDK. I tried sql and can get data from the table but does include "state" information ("starting, stopping, running etc..."). I did find github example around .Net but none fit the bill. If anyone can point me to the right example or documentation it would be greatly appreciated.

Thank you,

If you are using the client-side development paradigm (i.e. editing code in local files that get imported and compiled onto the IRIS server your `objectscript.conn` settings point to) you can now use IPM in VS Code to manage the packages in your IRIS target by launching it from the Explorer view.

HealthShare Patient Index – Virtual July 30-August 1, 2024 9:00am-5:00pm US-Eastern Time (EDT)

• HealthShare Unified Care Record Overview – Virtual October 8-9, 2024

Hi Community,

🔐 Make sure your data is secure! Learn some strategies for enhancing security in InterSystems IRIS® data platform:

Navigating SQL Privileges and Security in InterSystems IRIS

https://www.youtube.com/embed/_lBHnrm5Ot4?utm_source=youtube&utm_medium=social&utm_campaign=_lBHnrm5Ot4
[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]

I'm trying to make a connection to an external database using %SQLGatewayConnection, but the connection always fails. DSN properly configured. I try to make the same connection through isql in bash, and the connection is successful.

This same connection fails in Caché.

Is it possible to deploy a license server in a cloud and then download licenses from it to the host location at customer's data center?

Hey Community,

Watch this video to learn about AI Co-Pilot, which simplifies DTL coding and offers personalized assistance which makes it accessible to users with varying levels of technical expertise:

⏯ Accelerate DTL Coding with AI Cloud Service @ Global Summit 2024

https://www.youtube.com/embed/C0YfTYiRqzI
[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]