Using SQL Gateway with Python, Vector Search, and Interoperability in InterSystems Iris

Part 2 – Python and Vector Search

Since we have access to the data from our external table, we can use everything that Iris has to offer with this data. Let's, for example, read the data from our external table and generate a polynomial regression with it.

For more information on using python with Iris, see the documentation available at https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=AFL_epython

Let's now consume the data from the external database to calculate a polynomial regression. To do this, we will use a python code to run a SQL that will read our MySQL table and turn it into a pandas dataframe:

Hi, Community!

Are you using generative AI tools for development? Let InterSystems principles be your guiding star! 🌟 Learn about the company's approach:

Using Generative AI Responsibly

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

how can I get the classMethod name ?
like we get class name using "$CLASSNAME($THIS)", same way I need class Method ?

during an upgrade, a customer wants to load custom schemas in a particular order.
For this, they renamed a file EPIC_MDM.HL7 to 1EPIC_MDM.HL7
Upon importing this file into their server using VSCode, the custom schema was renamed to 1EPIC_MDM.HL7 inside the <Category>

This is impacting the upgrade and they are looking for a way to import a custom schema without renaming the schema itself.

If you're migrating from Oracle to InterSystems IRIS—like many of my customers—you may run into Oracle-specific SQL patterns that need translation.

Take this example:

SELECT (TO_DATE('2023-05-12','YYYY-MM-DD') - LEVEL + 1) AS gap_date
FROM dual
CONNECT BY LEVEL <= (TO_DATE('2023-05-12','YYYY-MM-DD') - TO_DATE('2023-05-02','YYYY-MM-DD') + 1);

In Oracle:

I'm creating a Business Process that:

1. Transforms one object into another using DTL
2. Sends this object to an operation
3. Transform the object obtained in first point into another one using DTL
4. Sends the second object to an operation

The Business Process is created with BPL, and objects are stored in BP context. When I execute this Process, in the 3rd point the object obtained in first transformation doesn't exist. It's empty.

I have tried to make transformation before making CALL's, I mean:

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Make Upgrades Easier - Introducing the Upgrade Impact Checklist @ Global Summit 2024

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

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Adapt AI to your Existing Architecture @ Global Summit 2024

https://www.youtube.com/embed/odGAzFwsB5E
[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 am working on a scenario where source will be sending 6 files to HealthConnect. In HealthConnect we need to process all the 6 files and send them to MoveIT through the Operation. In Health Connect we need to configure a property file through the data that we will be receiving in one for the six files.
Can someone help me with the workflow that can be setup to achieve this.

Hello,

Since version 2.12.6 of "Intersystems ObjectScript" extension in VS Code, the compile process force the EOF automatically to LF.
Have you encountered this issue and do you know how to resolve it?

Thank you,

Maxime

1. I like the Application Error Log functionality a lot. However, it becomes time consuming to inspect it date by date and directory by directory on a multidirectory server. Ideally, I would use an existing error class to write a custom error report by date, selected namespaces, etc. Does such a system class actually exist? Not that I found. The detail level on the screenshot below is enough.

I am struggling with returning a SQL Query Result that may have multiple rows that can be searched.

We have some ObjectScript code in a custom business process:

When Log Trace Events is ticked on the business process in the Production view in the management portal, the argument is obviously computed.