​🚀 Learn how #InterSystemsIRIS makes working with #JSON simple: from creating and manipulating data structures to leveraging #SQL functions for advanced interoperability in #healthcare systems 👇

https://community.intersystems.com/post/intersystems-iris-json

Start creating #AI agents that go far beyond simple chatbots!

​⚙️ Want to run FastAPI apps natively in #InterSystemsIRIS? This template shows how to deploy a full #FastAPI app using #Docker, with built-in support for #SQL, #JSON, and more 👇

https://community.intersystems.com/post/running-fastapi-applications-iris

Give it a spin and supercharge your #Python + IRIS workflow!

​🧩 Want to run Django apps natively in #InterSystemsIRIS? This ready-to-use template lets you deploy #Django via #Docker with support for #RESTAPIs, SQL, #JSON & more 👇

https://community.intersystems.com/post/running-django-applications-iris

Try it out and build secure, scalable web apps with Django + IRIS! #Python #SQL

​🚀 Welcome a new entry from the InterSystems Demo Games 2025!

Watch this #video to see how InterSystems FHIR #SQL Builder projects #FHIR data into a dataset for vector embedding, and then powers a #RAG chain with an #LLM + chatbot for smarter insights 👇

https://community.intersystems.com/post/demo-video-fhir-powered-ai-healthcare-assistant

🗳️ If you like this demo, vote for it here: https://community.intersystems.com/contests/current?sort=creation#:~:text=%5BDemo%20Video%5D%20FHIR%2DPowered%20AI%20Healthcare%20Assistant

​🚀 Welcome a new entry from the InterSystems Demo Games 2025!

Explore a text-to-#SQL demo that transforms MQTT data #analytics with the power of #RAG 👇

https://community.intersystems.com/post/demo-video-text-sql-and-mqtt-monitoring

🗳️ If you like this demo, vote here: https://community.intersystems.com/contests/current?sort=creation#:~:text=%5BDemo%20Video%5D%20Text%2Dto%2DSQL%20and%20MQTT%20Monitoring

​🚀 Welcome a new entry from the InterSystems Demo Games 2025!

Join an #interoperability adventure where #InterSystemsIRIS brings together data from any format into #FHIR, ready for analytics with FHIR #SQL Builder + DeepSee Web 👇

https://community.intersystems.com/post/demo-video-data-transformation-adventures-intersystems-iris

🗳️ If you like this demo, vote here: https://community.intersystems.com/contests/current?sort=creation#:~:text=%5BDemo%20Video%5D%20Data%20Transformation%20Adventures%20with%20InterSystems%20IRIS

​🚀 Welcome a new entry from the InterSystems Demo Games 2025!

Explore a 6-part #video demo of #InterSystemsIRIS Managed #Cloud Solutions covering MQTT → HL7v2, #FHIR transformation, FHIR #SQL Builder, IntelliChat, #OMOP integration, and Data Fabric Studio👇

https://community.intersystems.com/post/demo-video-being-ready-tackle-healthcare-enterprise-challenges-few-clicks

🗳️ If you like this demo, vote here: https://community.intersystems.com/contests/current?sort=creation#:~:text=%5BDemo%20Video%5D%20Being%20READY%20to%20Tackle%20Healthcare%20Enterprise%20Challenges%20in%20a%20Few%20Clicks

​🧠 #InterSystemsIRIS 2024 brings #vector types to #SQL! Learn how to harness SQLEmbeddings for similarity search, clustering, and more, right in your #database 👇

https://community.intersystems.com/post/unleashing-power-vector-search-sql-embedding

Unlock powerful new search and #AI features with just #SQL! #VectorSearch

🔗 Need to connect #InterSystemsIRIS to #SQL Server? This step-by-step #tutorial shows how to set up an #ODBC connection using the Management Portal 👇

https://community.intersystems.com/post/connecting-iris-sql-server-using-odbc-connection

Start integrating your data platforms today!

​🔥Curious how to make your #SQL LIKE queries in #InterSystemsIRIS not just work, but run efficiently, securely, and at scale? This article breaks down the key best practices every developer should know 👇

https://community.intersystems.com/post/optimizing-sql-security-performance-and-best-practices

Dive in and level up your SQL game!

​📊 Learn how to calculate running totals, ranks, and moving averages without cumbersome joins and loops! Dive in for a detailed look at #SQL window functions in #InterSystemsIRIS and see how they provide more accurate and faster #analytics 👇

https://community.intersystems.com/post/understanding-sql-window-functions-part-1

Improve your SQL analysis skills!

​📡 Discover how #InterSystemsIRIS interoperability powers real-time data architectures using CDC - enabling seamless streaming from #SQL and CSV sources into columnar #databases and Kafka for high-performance analytics 👇

https://community.intersystems.com/post/data-streaming-intersystems-iris-interoperability

Learn how to build scalable, continuous, and robust #interoperability data flows!

​🗂️ Check out this article to learn the best ways to work with #JSON in SQL. For your convenience, #InterSystemsIRIS has built-in functions like JSON_OBJECT, JSON_ARRAY, and JSON_TABLE to make it easy 👇

https://community.intersystems.com/post/json-support-iris-sql

See how to level up your #SQL with native JSON handling!

​☁️ Moving to the cloud with #Azure #SQL? Here’s an example of how you can configure #JDBC connections in #InterSystemsIRIS using Microsoft Entra & AD Password Auth 👇

https://community.intersystems.com/post/connecting-jdbc-ms-azure-sql-through-microsoft-entra-and-active-directory-password

Get the most out of the #cloud!

​🤖 Build, train, and run ML models using just #SQL! #InterSystemsIRIS makes it possible with #IntegratedML. See how to configure it and apply it to real-world use cases like solar energy prediction 👇

https://community.intersystems.com/post/integratedml-configuration-and-application-intersystems-iris

Bring #MachineLearning closer to your data!

​📊 Understanding SQL Window Functions: learn how aggregate-over-window functions like SUM() and AVG() add powerful #analytics without collapsing rows with clear, practical examples 👇

https://community.intersystems.com/post/understanding-sql-window-functions-part-2

Read the article and level up your #SQL analytics skills!

​📈 Understanding #SQL Functions : explore LAG, LEAD, FIRST_VALUE, and more plus #performance tips and guidance on when window functions really shine 👇

https://community.intersystems.com/post/understanding-sql-window-functions-part-3

Read the final part and master advanced SQL #analytics!

​If you're new to #InterSystemsIRIS and want a clear, practical introduction to its multi-model capabilities, we’ve just published a free short hands-on #tutorial for you.

In just 5–10 minutes, you’ll explore how the same data can be accessed through:

- Object methods
- #SQL queries
- Hierarchical globals

It’s a concise walkthrough of how IRIS projects multiple data models on top of a single unified data engine — one of its key architectural strengths.

No setup required. Just open and try it 👇

https://play.instruqt.com/embed/intersystems/tracks/quickstart?token=em_DzT96hG3anblDBdY

​Curious how #InterSystemsIRIS actually ties together objects, SQL, and globals under the hood? We’ve created a new free hands-on tutorial that lets you see it in action — no installation, no setup, just 5–10 minutes of interactive learning.

You’ll:
✔️ Create objects
✔️ Query them with #SQL
✔️ Inspect how they’re stored in globals
✔️ See how the multi-model architecture really works

It’s designed for developers who are just getting started with IRIS — but we’d love feedback from seasoned pros too.

Try it here 👇
https://play.instruqt.com/embed/intersystems/tracks/quickstart?token=em_DzT96hG3anblDBdY

Let us know what you think!

​🗄️ Discover a truly multi-model platform: one set of data, six ways to work with it.

This article shows how #InterSystemsIRIS lets the same record live as a hierarchical tree, key-value store, #object, #JSON document, #SQL table, and columnar dataset with zero duplication involved. Using a patient record example, it walks through three layers of the data model: Storage, Application, and Analytics, with ObjectScript and SQL code examples.

Dive in and see how one engine can power your transactional, SQL, and analytical processes at once: https://community.intersystems.com/post/intersystems-iris-data-models-explained-hierarchical-key-value-object-document-relational-and