We're excited to continue to roll out new features to InterSystems IRIS Cloud SQL, such as the new Vector Search capability that was first released with InterSystems IRIS 2024.1. Cloud SQL is a cloud service that offers exactly that: SQL access in the cloud. That means you'll be using industry-standard driver technologies such as JDBC, ODBC, and DB-API to connect to this service and access your data. The documentation describes in proper detail how to configure the important driver-level settings, but doesn't cover specific third-party tools as - as you can imagine - there's an infinite number of them.

In this article, we'll complement that reference documentation with more detailed steps for a popular third-party data visualization tool that several of our customers use to access IRIS-based data: Microsoft Power BI.

8 17
0 427
Article
· May 24, 2024 15m read
VIP in GCP

If you're running IRIS in a mirrored configuration for HA in GCP, the question of providing a Mirror VIP (Virtual IP) becomes relevant. Virtual IP offers a way for downstream systems to interact with IRIS using one IP address. Even when a failover happens, downstream systems can reconnect to the same IP address and continue working.

The main issue, when deploying to GCP, is that an IRIS VIP has a requirement of IRIS being essentially a network admin, per the docs.

To get HA, IRIS mirror members must be deployed to different availability zones in one subnet (which is possible in GCP as subnets always span the entire region). One of the solutions might be load balancers, but they, of course, cost extra, and you need to administrate them.

In this article, I would like to provide a way to configure a Mirror VIP without using Load Balancers suggested in most other GCP reference architectures.

7 3
1 443

Based on a great sample and workshop built by @Luis Angel Pérez Ramos (see related articles and related Open Exchange app), which included a local InterSystems IRIS for Health container (and desired setup), this sample presented here, adapted the workshop for using the InterSystems Cloud FHIR Server, and it's related setup.

7 2
1 212
Article
· Aug 19, 2024 4m read
Accessing Azure Blob Storage

Accessing an Azure cloud storage to upload/download blobs is quite easy using the designated %Net.Cloud.Storage.Client class API methods, or using the EnsLib.CloudStorage.* inbound/outbound adaptors.

Note that you'll need to have the %JavaServer External Language Server up and running to use the cloud storage API or adaptors, since they both use the PEX framework using the Java Server.

Here is a quick summary:

9 0
2 249

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

Security In the Cloud - Assuring a Secure InterSystems IRIS Cloud Overlay @ Global Summit 2024

https://www.youtube.com/embed/BGQG7gwBxZc
[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
0 149

Introduction

In today's rapidly evolving threat landscape, organizations deploying mission-critical applications must implement robust security architectures that protect sensitive data while maintaining high availability and performance. This is especially crucial for enterprises utilizing advanced database management systems like InterSystems IRIS, which often powers applications handling highly sensitive healthcare, financial, or personal data.

9 3
1 76

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

InterSystems IRIS Cloud Document @ Global Summit 2024

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

Hi Community,

We're excited to invite you to the webinar 2025 Data Management: Technology Trends & Predictions.

Join this webinar for an engaging and insightful tech talk on the latest trends in data management technology in the UK and Ireland.

Date & Time: Thursday, January 23, 10:30 AM GMT

👨‍🏫 Speakers:

  • Andy Hayler, Practice Leader, Bloor Research
  • @Mike Fuller, Regional Director of Marketing, InterSystems UK&I

2025 Tech Talk Tech Trends & Predictions.png

2 0
0 109

Hi Developers!

With InterSystems IRIS Cloud SQL recently becoming Generally Available, some of you may have had a chance to try it out. Or maybe you used it for your contest entry or during the EAP period. We're curious to learn what YOU think of it. So, have you already tried the new service InterSystems IRIS Cloud SQL?

We have launched a new Ideas Portal category dedicated to this database-as-a-service (DBaaS) where we're looking for your ideas on how we can improve InterSystems IRIS Cloud SQL.

Or share your experience with the service in the comments to this post.

1 0
0 107

Not sure there are many that connect to MS SQL to execute queries, stored procedures, etc, but our Healthsystem has many different MS SQL based databases we use within the Interoperability environment for various reasons.

With the push to moving from on-prem to the Cloud we ran into some difficulties with our SQL Gateway connections and knowing how to config them to use Microsoft Entra for Active Directory Authentication.

1 0
1 98

Hi Community,

Play the new video on InterSystems Developers YouTube:

Introducing Smart Data Services @ Global Summit 2023

https://www.youtube.com/embed/8ZQf5m0HA5w
[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
0 98

Hi Community,

Play the new video on InterSystems Developers YouTube:

How Netsmart Moved to InterSystems IRIS in the Cloud @ Global Summit 2023

https://www.youtube.com/embed/JZ5xLLegOx8
[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
0 89

Regardless of whether an instance of IRIS is in the cloud or not, high availability and disaster recovery are always important considerations. While IKO already allows for the use of NodeSelectors to enforce the scheduling of IRISCluster nodes across multiple zones, multi-region k8s clusters are generally not recommended or even supported in the major CSP's managed Kubernetes solutions. However, when discussing HA and DR for IRIS, we may want to have an async member in a completely separate region, or even in a different cloud provider altogether.

6 0
2 72

Hi, Community!

Looking to streamline your data management? See how this fully managed, cloud-based solution can help:

Exploring InterSystems Data Fabric Studio

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

4 0
0 71

Hi, Community!

🔒Are you linking your InterSystems Cloud Services deployments to a private network? See how to do this securely:

Creating and Managing VPNs with InterSystems Network Connect

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

Hi, Community!

Are you using InterSystems Cloud Services? Take a tour of the central hub for managing your services and deployments:

InterSystems Cloud Services Portal Overview

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

Hi, Community!

Are you using InterSystems Cloud Services? See how to get support directly in the app:

Using iService for Cloud Product Support

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

3 0
0 53
Article
· Dec 11, 2024 2m read
Minimum IRIS container footprint

Sometimes customers need a small IRIS instance to do something in the cloud and shut it down, or they need hundreds of containers (i.e. one per end user or one per interface) with small workloads. This exercise came about to see how small an IRIS instance could be. For this exercise we focused on what is the smallest amount of memory we can configure for an IRIS instance. Do you know all the parameters that affect the memory allocated by IRIS ?

5 0
1 44

Hi, Community!

🔎Find out how you can simplify your document storage and queries with InterSystems IRIS® Cloud Document!

Getting Started with InterSystems IRIS Cloud Document

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

Hey Community,

We're excited to invite you to the next InterSystems UKI Tech Talk webinar:

👉 Cloud Health: FHIR Server

Join this webinar to dive into the world of HealthShare Health Connect Cloud with our upcoming session on Cloud Health: FHIR Server.

Date & Time: Thursday, March 20, 2025 2:30 PM GMT

👨‍🏫 Speaker: @Regilo Regilio Guedes de Souza, Director of Cloud Delivery, InterSystems

2025 Tech Talk Social Tile 20 березня (чернетка).png

1 0
0 30

Hi, Community!

How can you improve your team's work on interface components? See how source control can help:

Using Server-Side Source Control in Health Connect Cloud

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

Hi, Community!

Looking for a safe space to create interface components outside your live environment? See how interface branches can help:

Using Interface Branches in Health Connect Cloud

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