Syndicate content 0  

I am using IRIS for Windows (x86-64) 2022.1 (Build 209) Tue May 31 2022 12:27:55 EDT [Health:3.5.0]. I created Interoperability Production with a Service to read file from S3 bucket and an Operation to write files to a different S3 bucket. I specified AWS ProviderCredentialsFile.

I see "Terminating Job 7096 / 'From S3 Bucket' with Status = ERROR #5023: Remote Gateway Error: Connection cannot be established, %QuitTask=

Do I need anything like Python libraries or AWS CLI to make this work?

0 2
0 27

In this final part of our introduction to Window Functions, we will explore the remaining functions that have not been covered yet. You will also discover performance tips and a practical guide to help you decide when (and when not) to use window functions effectively.


1. Offset and Positional Value Functions

Overview

These functions reference values are calculated from other rows relative to the current row, or they are extracted from the first, last, or nth values within a window.

2 0
0 29

I'm pleased to announce the publication of gj :: dataLoader, a new VS Code extension that simplifies the task of loading data from local CSV files into SQL tables on your InterSystems IRIS servers.

Here's an introductory video:

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

2 0
0 29

Within Provider Data Management, I wanted a way to capture the Code Table mapping errors thrown by HSPD.MDM.FlowControl.Process into a Workflow Task for someone to work. However, because HSPD.MDM.FlowControl.Process can get overwritten during the upgrade process, I cloned it into another Business Process so we can use Workflow Tasks to troubleshoot mapping errors.

0 1
0 27

I am trying to add validation to a RecordMap, because the source of the data sent file sent us bad data within the file. So, I am using PATTERN to verify certain fields start with Numeric, and Alpha where applicable. When the EnsLib.RecordMap.Service.FTPService runs into an issue it doesn't seem like it continues onto the next record if the record does not meet the validation requirements.

How can I tell EnsLib.RecordMap.Service.FTPService to log the error and continue onto the next record, so those records that fail are not processed?

0 1
0 26

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

Optimizing Parallel Aggregation Using Shared Globals @ Ready 2025

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

0 0
1 27
Announcement
· Dec 2
Share your insights!

We value your feedback on the learning resources you use to get the most from InterSystems products. Whether you've taken self-paced or live courses, explored the documentation, or gotten certified, we'd love to hear from you!

How can InterSystems improve its learning resources in 2026? Take the survey.

2 0
0 26

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

Query Optimization in Hybrid Databases @ Ready 2025

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

1 0
0 26

Hi,

We're working on new capabilities to help you build Agents and AI applications faster with InterSystems IRIS. In order to better understand which entry points and development methodologies would help you most, we've created this brief survey: Building AI solutions with InterSystems IRIS.

Filling it in should not take much more than 5 minutes, and your feedback on this exciting topic will help us fine tune our designs and prioritize the right features.

Thanks in advance!
benjamin

0 0
0 24

Hello, Community:

📆 On February 19 you have a very special event at Espacio Covarrubias The One, in Madrid.

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

Iberia InterSystems READY 2026 is coming. An opportunity to share knowledge about generative AI, real-time analytics, and meet powerful partners in the sector. We will have very special guests, lots of surprises, and details we will be revealing.

4 0
0 24

Overview

This release introduces major improvements to storage scalability and performance, a significant operating system upgrade across all offerings, and a new default version of the FHIR Server. Together, these updates enhance system reliability, flexibility, and security while ensuring long-term platform supportability.


New Features and Enhancements

Category

Feature / Improvement

0 0
0 23
Article
· Dec 4 6m read
Sub-Table Security

InterSystems IRIS provides extensive configurable security options, yet many developers primarily use roles and resources to secure entire tables or routines. Today, we will delve deeper. We can also secure individual columns and rows separately, but these two mechanisms operate very differently. Let's begin with the columns.

Column Security

For testing and demonstration, we will keep our table structure concise and straightforward. We have a table called "Person" in the USER namespace that contains an ID column, a date of birth column (DOB), first name, and last name.

2 0
0 22

Recently, we implemented some Java-based services using JDBC. And some time ago, I refactored some legacy PHP programs that used "csession" for communication between systems to use PDO with ODBC.

This raised a question for me about how license management is done in this scenario.
Is a license used per pool? Or per connection? How is this management done?

1 0
0 20

I copied a Business Process router and did a Save As on its routing rule. I added the new routing rule to my new Business Process router. However, when I click the green circle next to my new Business Process router it shows the old Business Process router connection. Anyone know the cause and fix for this? I found a old post that said to add a Route Alias. But that did not work.

0 1
0 17

Overview

Version 25.20.2 expands global availability, enhances Advanced Security flexibility, and widens Network Connect integrations. This release introduces support for additional regions, new application-aware security rules, and expanded connectivity options for critical InterSystems services.


New Features and Enhancements

Category

Feature / Improvement

0 0
0 17

Let’s spotlight the brilliant authors and contributors of our November Article Bounty! 💙
Thank you to everyone who took part and shared their knowledge with the community.

A special shout-out goes to those who created brand-new articles and contributed their expertise — each received 5,000 points 🎉

@Zion Amsalem -- "Consuming REST-APIs for dummies (beginner-friendly)"
@Robert Cemper -- "Network Debugging for Beginners - 1"
@Irène Mykhailova -- "Connecting C# to InterSystems IRIS via ODBC"
@Vachan C Rannore -- "My experience with APIs and POS integration."
@Padmaja Konduru -- "Production Terminal Commands"

2 0
1 16

Overview

This release focuses on performance optimization, improved security synchronization, and enhanced network management. The FHIR Server has been upgraded to a new version and migrated to ARM64, delivering significantly better efficiency and throughput. Additionally, several improvements enhance resiliency, subscription management, and network visibility.


New Features and Enhancements

Category

0 0
0 16

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

Smarter Table Statistics @ Ready 2025

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

<--break->

0 0
0 15

Hey Community!

We're happy to share the next video in the "Code to Care" series on our InterSystems Developers YouTube:

Using GenAI in Real Life: Daily Use Cases That Work

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

1 0
0 15