Search

Hi Community, Enjoy the new video on InterSystems Developers YouTube: ⏯ Integrating DBT and Apache Airflow with InterSystems IRIS @ Global Summit 2024 This session is your guide to setting up efficient, manageable data pipelines that save time and boost reliability. We'll show you how to bring together the processing power of dbt, the scheduling strength of Apache Airflow, and the robust data management capabilities of InterSystems IRIS. By the end of this session, you'll have a clear understanding of how to implement these tools in harmony, making your data workflows smoother and more effective. This is perfect for those looking to enhance their data operations with straightforward, effective solutions. Presenters:🗣 @Reven.Singh, Sales Engineer, InterSystems 🗣 @Hermanus.Bruwer, Sales Engineer, InterSystems Want to learn something new? Watch the video and subscribe for more!

Hi developers! This will be a very short article as in April 2025 with Lovable and other Prompt-to-UI tools it becomes possible to build the frontend with prompting. Even to the folks like me who is not familiar with modern UI techics at all. Well, I know at least the words javascript, typescript and ReactJS, so in this very short article we will be building the ReactJS UI to InterSystems FHIR server with Lovable.ai. Let's go! First of all we will need an InterSystems FHIR Server instance. You can get it on AWS or you can spin it out directly on your laptop with IRIS for Health if you have docker installed. I will follow the docker way - and the easiest step is to clone this Open Exchange repository with: > cd devfoloder >git clone git clone git@github.com:intersystems-community/iris-fhir-template.git >cd iris-fhir-template >docker compose up -d Once started you can check FHIR server REST API working with the swagger at localhost:32873/swagger-ui/index.html: Check some calls (e.g. Patient resource) and see that there is some data. OK! Let's build the UI now. Go to Lovable.dev and create an account, its free. Ask Lovable to build the UI vs FHIR server, including the resources and functionality you want. E.g. prompt could be: Dear Lovable! Please build the UI vs an FHIR server R4 to manipulate Patient, Medication, observation, and lab results resources. And it will build it out. After it is done, ask Lovable to point the UI to a FHIR REST API URL: localhost:52873/fhir/v4. And it should work. Make sure you set up proper user access (I'd start with no security initially just to make sure REST services receive and provide data properly) and feel free to improve the UI with prompting. Next you can ask lovable to deploy the solution to internet. To make it working make sure you deploy IRIS FHIR server as well or point to AWS one if you are there. That's it! Lovely, isn't it? Here is the video with all the steps and more:

Hello and welcome to the Developer Ecosystem News, Fourth Quarter! This last quarter of the year was full of exciting activities in the InterSystems Developer Ecosystem. In case you missed something, we've prepared for you a selection of the hottest news and topics to catch up on! News 🎇 Developer Community AI: InterSystems IRIS Documentation added 🎆 20,000 members on the InterSystems Developer Community! 🎆 400+ Ideas on the InterSystems Ideas Portal 🎇 Global Masters is back! Launch Date: October 3, 2024 🎊 2024 in Review: Celebrate Your Year with Developer Community! 🎊 Season's Greetings from the Developer Community! 🎊 Global Masters Holiday Cards 💡 InterSystems Ideas News #16 and #17 📝 Notifications & Co-Developers: New on Open Exchange! 📝 Faster Vector Searches with Approximate Nearest Neighbor index -- now available in the Vector Search Early Access Program 📝 InterSystems System Alerting and Monitoring (SAM) to Be Removed 📝 Production Decomposition - CCR Now Allows Source Controlling Individual Production Items 📝 InterSystems Package Manager (IPM) v0.9.0 Beta 👨‍🏫 InterSystems IRIS SQL Specialist Exam is now LIVE! Contests & Events InterSystems Developer Tools Contest 2024 Contest Announcement Kick-off Webinar Technology Bonuses Time to Vote Technical Bonuses Results Winners Announcement Meetup with Winners InterSystems Tech Video Challenge Announcement Bonuses Winners InterSystems Walking Challenge Announcement Winners InterSystems "Bringing Ideas to Reality" Contest Contest Announcement Kick-off Webinar Technology Bonuses Time to Vote Technical Bonuses Results Winners Announcement Advent of Code 2024 Contest Announcement Winners Announcement 🏆 First French Technical Article Contest 🏆 The 2nd InterSystems Japan Technical Writing Contest! 🏆 InterSystems IRIS Technical Tutorial Contest in Portuguese 👨‍💻 InterSystems at HackMIT 2024 👨‍💻 InterSystems at Hack Jak Brno Healthcare Hackathon 2024 🤝 Developer Meetup: Innovating on Health Data [GenAI, FHIR, Data Quality] 🤝 Developer Meetup on Security - October 15, Cambridge, MA 🤝 Developer Meetup on Gen AI, RAG, Hallucinations [Nov 19, Cambridge, MA] 🤝 Japan Developer Community Meetup in Tokyo 🎓 InterSystems DACH Symposium 2024 📺 Webinar in Spanish: ‘Facial recognition applied to application login using JavaScript+IRIS’ 📺 Webinar in Spanish: Unifying Data with InterSystems IRIS: Exploring the 'Connect or Collect' Paradigm 📺 [Webinar] Are you and your data AI ready? 📺 Webinar with the winners of the InterSystems IRIS Technical Tutorials Contest 🌐 [LinkedIn Live] Debunking AI Myths with Expert Insights Latest Releases ⬇️ General Availability of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect 2024.3 ⬇️ Maintenance Releases 2023.1.5 & 2024.1.2 of InterSystems IRIS, IRIS for Health, & HealthShare HealthConnect are now available ⬇️ First InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect 2025.1 Developer Preview available ⬇️ IPM 0.9.0 Released Best Practices & Key Questions 🔥 Best practices Build iris image with cpf merge .NET Client-Side Development on IRIS Data Platform Connect Microsoft Excel to InterSystems IRIS via ODBC (Windows) A Better data import experience for LOAD DATA Working Around SOAP Service Timeouts A Peek at IRIS Data Platform Performance Strategies Uncovering Clues by Querying the Interoperability Message tables OpenTelemetry Traces from IRIS implemented SOAP Web Services Journaling Overview - Configuration, Operations, and Utilities Bridge AI/ML with your Adaptive Analytics solution ❓ Key Questions: September, October, November, December People and Companies to Know About 👨‍💻 Celebrating a Star of the Developer Community 👨‍💻 Celebrating a Journey of Dedication 💼 Remote: Strong InterSystems HL7, ADT, CCDA to FHIR + IRIS + GCP 💼 IRIS InterSystems Engineer 💼 IRIS experience at CVS Healthcare So... Here is our take on the most interesting and important things! What were your highlights from this past quarter? Share them in the comments section and let's remember the fun we've had! Congratulations everyone on the great set of content created by this community in the past 3 months! Happy New Year everyone!

Hello and welcome to the Developer Ecosystem News! The first quarter of the year was full of exciting activities in the InterSystems Developer Ecosystem. In case you missed something, we've prepared a selection of the hottest news and topics for you to catch up on! News 🎇 Developer Community AI: descriptions of Open Exchange Applications added 🎆 Top InterSystems Developer Community Authors of 2024 🎆 Top Open Exchange Developers and Applications of 2024 🎇 Top InterSystems Ideas Contributors of 2024 🎊 Global Masters Update - Discover New Rewards 💡 InterSystems Ideas News #18, #19 and #20 📝 InterSystems Developer Ecosystem Annual Survey 2025 📝 Early Access Program for new Table Partitioning feature 📝 Alert: Invalid Data Introduced to Database and Journal files with Specific $LIST Operations 📝 Alert: SQL Queries Returning Wrong Results 📝 What's new with InterSystems Language Server 2.7 📝 Deprecation of MultiValue in InterSystems IRIS 2025.1 📝 InterSystems Platforms Update Q1-2025 📝 Using OpenEHR with InterSystems IRIS Contests & Events InterSystems Technical Article Contest 2025 Announcement Bonuses Winners "DC Search" Sweepstakes Announcement Winners UK&I Data Summit InterSystems UK & Ireland Data Summit 2025 [Video] Developer Ecosystem at UKI Data Summit UK&I Data Summit in Birmingham - freebies inside! 👨‍💻 InterSystems at European Healthcare Hackathon 2025 👨‍💻 InterSystems at TreeHacks 2025 👨‍💻 InterSystems GenAI challenge at NUS Health Hack 2025 hackathon 👨‍💻 InterSystems at IC HACK ‘25 🤝 AI Meetup with InterSystems Iberia 🤝 InterSystems Benelux and France Summit 2025 📺 Interoperability as a catalyst for AI 📺 Cloud Health: FHIR Server 📺 Webinar in Hebrew: GenAI + RAG - Leveraging InterSystems IRIS as your Vector DB 📺 Configuring a Web Server for use with InterSystems IRIS 📺 2025 Data Management: Technology Trends & Predictions Latest Releases ⬇️ General Availability of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect 2025.1 ⬇️ Maintenance Releases 2024.1.3 of InterSystems IRIS, IRIS for Health, & HealthShare HealthConnect are now available Best Practices & Key Questions 🔥 Best practices VIP in GCP IKO - Lessons Learned (Part 1 - Helm) IKO - Lessons Learned (Part 2 - The IrisCluster) IKO - Lessons Learned (Part 3 - Services 101 and The Sidecars) IKO - Lessons Learned (Part 4 - The Storage Class) Comfortable VSCode Auto Save and ObjectScript CompileOnSave settings Connecting to DynamoDB Using Embedded Python: A Tutorial for Using Boto3 and ObjectScript to Write to DynamoDB Getting data from InterSystems IRIS CloudSQL using xDBC Quickstart guide to IRIS DB on Linux Systems Orchestrating Secure Management Access in InterSystems IRIS with AWS EKS and ALB ❓ Key Questions: January, February, March (TBA) People and Companies to Know About 👩‍🏫 Celebrating a True Educator of the Developer Community 💼 IRIS Engineer Needed 💼 Role for IRIS Engineer 💼 Opportunity for HealthShare Engineers 💼 Principal Architect and Integration Engineer 👨‍💻 looking for new opportunity 👨‍💻 Looking for Opportunities in InterSystems Technology So... Here is our take on the most interesting and important things! What were your highlights from this past quarter? Share them in the comments section and let's remember the fun we've had!

Hi Developers! We are happy to present the bonuses page for the applications submitted to the InterSystems AI Programming Contest! See the results below. Project Agent AI Vector Search Embedded Python LLM AI or LangChain IntegratedML Docker IPM Online Demo Community Idea Implementation Find a bug First Article on DC Second Article on DC Video on YouTube First Time Contribution Suggest New Idea Total Bonus Nominal 5 4 3 3 3 2 2 2 4 2 2 1 3 3 1 40 ollama-ai-iris 4 3 3 2 3 15 mcp-server-iris 5 3 3 2 3 16 langchain-iris-tool 5 4 3 3 2 2 2 4 2 1 3 1 32 AiAssistant 4 3 3 2 2 3 17 pax-ai-iris 3 3 6 IRIS-Intelligent-Butler 4 3 3 3 13 iris-data-analysis 4 3 3 2 2 2 3 19 bg-iris-agent 5 3 2 2 2 2 3 3 22 Facilis 5 3 3 2 2 15 Vitals Lab 4 3 3 3 13 iris-AgenticAI 5 4 3 3 2 2 1 20 toot 4 3 2 2 3 14 iris-clinical-assistant 3 3 2 3 11 oncorag 5 4 3 2 3 17 iris-easybot 5 4 3 2 14 Please apply with your comments for new implementations and corrections to be made here in the comments or in Discord. Evgeny, hi! We have added a link to the demo in the description of the project (bg-iris-agent), this link is also available in our article. Could you please add bonuses for online demo on our project? Hi Elena! I've added bonus to your app. Thank you, Semion! Evgeny, hi! I have several apps that don't have bonuses, I want to confirm: Vector SearchDockerIPMFirst Time Contribution Hi! Your docker doesn't work after running. Ipm doesn’t work after installation. Fisrt Time I’ve fixed. First Article I’ve removed, because of it’s just copy of readme. Vector Search I’ve added. Thanks @Evgeny.Shvarov for sharing the Technological Bonuses Results.Note that the iris-AgenticAI application now supports Vector Search, and the second article is also published. Hi Muhammad! These bonuses have been added. Thank you!

The Data Platforms team is very pleased to announce the 2021.2 release of InterSystems IRIS Data Platform, InterSystems IRIS for Health and HealthShare Health Connect, which are now Generally Available (GA) to our customers and partners. Release Highlights InterSystems IRIS Data Platform 2021.2 makes it even easier to develop, deploy and manage augmented applications and business processes that bridge data and application silos. It has many new capabilities including: Enhancements for application and interface developers, including: Embedded Python Interoperability Productions in Python Updates to Visual Studio Code ObjectScript Extension Pack New Business Services and operations added allowing users to set and run SQL query with minimal custom coding Enhancements for Analytics and AI, including: New SQL LOAD command efficiently loads CSV and JDBC source data into tables Enhancements to Adaptive Analytics Enhancements for Cloud and Operations tasks, including: New Cloud Connectors make it simple to access and use cloud services within InterSystems IRIS applications IKO enhancements improve manageability of Kubernetes resources Enhancements for database and system administrators, including: Online Shard Rebalancing automates distribution of data across nodes without interrupting operations Adaptive SQL engine uses fast block sampling and automation to collect advanced table statistics and leverages runtime information for improved query planning Storage needs for InterSystems IRIS are reduced with new stream and journal file compression settings Support for TLS 1.3 and OpenSSL 1.1.1, using system-provided libraries New ^TRACE utility reports detailed process statistics such as cache hits and reads More details on all these features can be found in the product documentation: InterSystems IRIS 2021.2 documentation and release notes InterSystems IRIS for Health 2021.2 documentation and release notes HealthShare Health Connect 2021.2 documentation and release notes How to get the software InterSystems IRIS 2021.2 is a Continuous Delivery (CD) release, which now comes with classic installation packages for all supported platforms, as well as container images in OCI (Open Container Initiative) a.k.a. Docker container format. Container images are available for OCI compliant run-time engines for Linux x86-64 and Linux ARM64, as detailed in the Supported Platforms document. Full installation packages for each product are available from the WRC's product download site for CD releases. Using the "Custom" installation option enables users to pick the options they need, such as InterSystems Studio and IntegratedML, to right-size their installation footprint. Container images for the Enterprise Edition, Community Edition and all corresponding components are available from the InterSystems Container Registry using the following commands: docker pull containers.intersystems.com/intersystems/iris:2021.2.0.651.0 docker pull containers.intersystems.com/intersystems/iris-ml:2021.2.0.651.0 docker pull containers.intersystems.com/intersystems/irishealth:2021.2.0.651.0 docker pull containers.intersystems.com/intersystems/irishealth-ml:2021.2.0.651.0 For a full list of the available images, please refer to the ICR documentation. Alternatively, tarball versions of all container images are available via the WRC's product download site for CD containers. Our corresponding listings on the main cloud marketplaces will be updated in the next few days. Sharing your experiences We are excited to see this version now hitting the GA milestone and eager to hear your experiences with the new software. Please don't hesitate to get in touch through your account team or the Developer Community with any comments on the technology or the use cases you're addressing with it. For selected new capabilities and products, we've set up Early Access Programs to allow our users to evaluate software before it gets released. Through these focused initiatives, we can learn from our target audience and ensure the new product fulfills their needs when it gets released. Please reach out through your account team or watch the Developer Community if you're interested in participating in any of these. Please note that 2021.2 is also available via the InterSystems Evaluation Service: https://evaluation.InterSystems.com. If you are a supported customer you can request evaluation keys or get full/community edition kits/containers. Prospects can get Community Edition kits/containers (see https://community.intersystems.com/post/introducing-evaluation-service-community-edition-downloads). And images with ZPM package manager 0.3.2 are available accordingly: intersystemsdc/iris-community:2021.2.0.651.0-zpm intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm intersystemsdc/irishealth-community:2021.2.0.651.0-zpm intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm intersystemsdc/iris-community:2021.1.0.215.3-zpm intersystemsdc/irishealth-community:2021.1.0.215.3-zpm intersystemsdc/irishealth-ml-community:2021.1.0.215.3-zpm intersystemsdc/irishealth-community:2021.1.0.215.3-zpm And to launch IRIS do: docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm And for terminal do: docker exec -it my-iris iris session IRIS and to start the control panel: http://localhost:9092/csp/sys/UtilHome.csp To stop and destroy container do: docker stop my-iris And the FROM clause in dockerfile can look like: FROM intersystemsdc/iris-community:2021.2.0.651.0-zpm Or to take the latest image: FROM intersystemsdc/iris-community Are there any news on docker hub publication? docker pull store/intersystems/iris-community:2021.2.0.649.0 Error response from daemon: manifest for store/intersystems/iris-community:2021.2.0.649.0 not found: manifest unknown: manifest unknown InterSystems IRIS 2021.2 is now available on docker hub, you can retry that command. However, due to Docker changing the terms of licensing, InterSystems is phasing out its Community version listings on docker hub after January 31, 2022. In the future, we may have a listing there, but that is not finalized. Currently, as well as in the future, these images can be obtained with docker CLI via: docker pull containers.intersystems.com/intersystems/iris-community:2021.2.0.651.0 Note that containers.intersystems.com does not require authentication when pulling Community Edition (CE) of InterSystems IRIS (see InterSystems Container Registry). Stay tuned for an announcement about our plans for docker hub, and please let us know if you have concerns or questions! docker pull containers.intersystems.com/intersystemscorp/iris-community:2021.2.0.649.0 is probably docker pull containers.intersystems.com/intersystems/iris-community:2021.2.0.649.0 Interesting news. Question: as access to containers.intersystems.com requires a WRC account, how do prospects/new users/people without WRC access can get community version of InterSystems IRIS? Thanks, Eduard! I updated the above comment to fix the typo! The Community Edition (CE) of InterSystems IRIS are available from containters.intersystems.com without credentials. This should work for anyone: docker pull containers.intersystems.com/intersystems/iris-ml-community:2021.2.0.651.0 That's good to hear. UPDATE! We discovered a defect in the Windows builds of InterSystems IRIS 2021.2, and have now updated those images on the WRC download site for Continuous Delivery releases. The new build number for the Windows kits is 651. Please change all the 649's in this to 651 - 2021.2 was republished Updated to 651, thanks, @Jeffrey.Fried! Also, we have the latest tag for ZPM images, so this will take the latest: FROM intersystemsdc/iris-community:latest Or just like this: FROM intersystemsdc/iris-community Hi Ben. For some reason, only IRIS 2021.1CE is available for Windows, although IRIS 2021.2CE is available for many other operating systems, such as MacOSX. Is it possible for Windows to update the version to 2021.2 too? @Vitaliy.Serdtsev - thank you very much for bringing this to our attention! There was a small issue resulting in the version listing being out of date. This has been corrected and you should be able to get access to 2021.2 for Windows now (please let me know if you still have issues). Thanks for reaching out! Now everything is OK, thanks. Now on evaluation.intersystems.com for Windows/MacOSX/Container allows to download the version of IRIS 2020.1CE, and for the rest - IRIS 2021.2CE. What happened and when will the problem with downloading the latest version disappear once and for all? This is a bug. We'll look into it. Thank you for bringing it to our attention. @Vitaliy.Serdtsev2149 thank you for pointing this out. We've fixed the issue; it was actually a separate root cause from before. Now everything is OK, thanks.

Hey Developers, We'd like to invite you to join our next contest dedicated to creating AI/ML solutions that use Cloud SQL to work with data: 🏆 InterSystems IRIS Cloud SQL and IntegratedML Contest 🏆 Duration: April 3 - April 23, 2023 Prize pool: $13,500 The topic 💡 InterSystems IRIS Cloud SQL with IntegratedML Contest 💡 In this contest, we expect to see applications full-stack, frontend, or backend applications that make use of InterSystems IRIS Cloud SQL to work with data and optionally will utilize its IntegratedML option to create AI/ML solutions. Your application could be a library, package, tool, or any SQL or/and AI/ML solution which uses InterSystems IRIS Cloud SQL on a backend. Basically, we invite you to use InterSystems IRIS in this contest as a 100% SQL engine with an AutoML option via IntegratedML offering. Here you can deploy InterSystems IRIS Cloud SQL. Here you can get information on InterSystems IRIS Cloud SQL product along with the IntegratedML feature. General Requirements: Accepted applications: new to Open Exchange apps or existing ones, but with a significant improvement. Our experts will review all applications before approving them for the contest. The application should use InterSystems IRIS Cloud SQL instance as a backend. Deploy it here. Types of applications that match: - anything. Any business solution, technology example, backend, frontend or full-stack application. The application should be an Open Source and published on GitHub. The README file to the application should be in English, contain the installation steps, and contain either the video demo or/and a description of how the application works. One developer can enter the competition with a maximum of 3 applications. Prizes 1. Experts Nomination - a specially selected jury will determine the winners: 🥇 1st place - $5,000 🥈 2nd place - $3,000 🥉 3rd place - $1,500 🏅 4th place - $750 🏅 5th place - $500 🌟 6-10th places - $100 2. Community winners - an application that will receive the most votes in total: 🥇 1st place - $1000 🥈 2nd place - $750 🥉 3rd place - $500 If several participants score the same amount of votes, they all are considered winners, and the money prize is shared among the winners. Important Deadlines: 🛠 Application development and registration phase: April 3, 2023 (00:00 EST): Contest begins. April 16, 2023 (23:59 EST): Deadline for submissions. ✅ Voting period: April 17, 2023 (00:00 EST): Voting begins. April 23, 2023 (23:59 EST): Voting ends. Note: Developers can improve their apps throughout the entire registration and voting period. Who can participate? Any Developer Community member, except for InterSystems employees. Create an account! 👥 Developers can team up to create a collaborative application. Allowed from 2 to 5 developers in one team. Do not forget to highlight your team members in the README of your application – DC user profiles. Helpful resources ✓ Documentation: InterSystems IRIS Cloud SQL InterSystems IRIS Cloud IntegratedML ✓ Tools: irissqlcli - python SQL terminal for InterSystems IRIS Connect to IRIS Cloud SQL: irissqlcli -h your-iris-cloud-sql-server -p 1972 -u SQLAdmin -n USER -W Connect to IRIS Cloud SQL via SSL: irissqlcli -h your-iris-cloud-sql-server -p 1972 -u SQLAdmin -c certificateSQLaaS.pem -n USER -W DBeaver - SQL-driven database tool. DBeaver and IRIS. Using docker container with iris-sql locally for development purposeses: Start IRIS in docker container locally: docker run --rm --name iris-sql -d -p 9091:1972 -p 9092:52773 -e IRIS_PASSWORD=demo -e IRIS_USERNAME=demo intersystemsdc/iris-community And connect via irissqlcli: irissqlcli iris://demo:demo@localhost:9091/USER You can connect also via other SQL tools. ✓ Example applications: iris-cloud-sql-demo ✓ Online Learning Material: Connect to InterSystems IRIS Cloud SQL via Python, C++, Java, .NET. ✓ How to submit your app to the contest: How to publish an application on Open Exchange How to submit an application for the contest Need Help? Join the contest channel on InterSystems' Discord server or talk with us in the comment to this post. We can't wait to see your projects! Good luck 👍 By participating in this contest, you agree to the competition terms laid out here. Please read them carefully before proceeding. NB Dear contestants, please take into consideration that support for the contest cloud sql environment is only available during business hours M-F 9-5 US Eastern Time. We seem to be experiencing a failure of the cloud environment such that deployments are stuck in Pending status for some users. Yay! This time you can develop the solution for the contest in ANY language that understands SQL! Python, java, .NET, js, C++, Rust, Go, ObjectScript - anything! Looking forward! Looking forward to this one! ;-) Have a look at some of my projects which can help with this contest irissqlcli - REPL for IRIS SQL sqlalchemy-iris dialect for SQLAlchemy, can be used with Pandas, Flask or FastAPI django-iris driver for Django dbt-iris adapter for dbt Give it a try and let me know if you have any issues with them, I can help to solve  Hi, Developers! The cloud portal of InterSystems IRIS Cloud SQL is now available! Feel free to launch deployments and prepare to the contest! Example of using SQLAlchemy+Pandas, works with this Cloud SQL as well from sqlalchemy import create_engine import pandas as pd server = '<your-server-hostname>' port = 1972 namespace = 'USER' username = 'SQLAdmin' password = '<YOUR_PASSWORD>' url = f"iris://{username}:{password}@{server}:{port}/{namespace}" print(url) engine = create_engine(url) df = pd.DataFrame({ 'int': [1, 2, 3, 4, 5], 'float': [1.1, 2.2, 3.3, 4.4, 5.5], 'string': ['a', 'b', 'c', 'd', 'e'], 'datetime': pd.date_range('20130101', periods=5), 'bool': [True, False, True, False, True] }) # create a table in IRIS df.to_sql('iris_table', engine, if_exists='replace', schema='sqlalchemy') # read the table back from IRIS df2 = pd.read_sql_table('iris_table', engine, schema='sqlalchemy') # print the dataframe print(df2) Added a small cheat sheet for IRIS SQL Hey Devs! The recording of the "[Kick-off Webinar] InterSystems IRIS Cloud SQL and IntegratedML Contest" is on InterSystems Developers YouTube! I tried to create an account on https://portal.sql-contest.isccloud.io/account/login Just the welcome mail never arrived.the page proposed to contact admin in this case Note: If you do not receive an email, it might be that the username or email address entered is not registered for an account. If you are unable to remember the username or email address you used to sign up for an account, please contact your system administrator for assistance. No further notice. Who is that system admin? Which mail ?Not so impressive ACCOUNT SOLVED: with a new account name. may be a typo in the e-mailTHOUGH OPEN: where is the admin contact Thanks, Robert -- we will look into that and see what the problem is. Granted, it is Easter Sunday so my apologies that our team will likely get to it at some point tomorrow Note: Our InterSystems IRIS Cloud SQL service is not yet publicly available, and we hope this contest uncovers bugs -- so we encourage all the participants in the contest to let us know when they see anything that doesn't match their expectations, no matter how trivial! Good luck hacking! Often we need to clean-up IRIS and start from a clear page with empty database. Docker containers could be an ideal option for that. Start IRIS in docker container locally: docker run --rm --name iris-sql -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community -a "iris session iris -U%SYS '##class(Security.Users).UnExpireUserPasswords(\"*\")'" And connect via irissqlcli: irissqlcli iris://_SYSTEM:SYS@localhost:9091/USER You can connect also via other SQL tools. Use the approach only for development purposes. other SQL tools. confirmed: I used ODBC + SQLGateway for access and operation from local IRISworks perfectly. There are already many useful suggestions and tools on display here... amazing community! Thank you! There was a new release of intersystemsdc vanilla images. Now you can use ENV variables to start IRIS with user, pass and namespace created. E.g. here is how to start: docker run --rm --name iris-sql -d -p 9091:1972 -p 9092:52773 -e IRIS_PASSWORD=demo -e IRIS_USERNAME=demo intersystemsdc/iris-community Here is how to connect via irissqlcli: irissqlcli iris://demo:demo@localhost:9091/USER Hey, Devs! There are three articles have been added to the contest! IntegratedML-IRIS-Cloud-Height-prediction by @珊珊.喻audit-consolidator by @Oliver.Wilms Tokenizator by @Yuri.Gomes Developers today is the last day for submissions!Don't miss your chance to join! I try to test contributions to the contestbut IRIS Cloud SQL just shows Deployment Pendingfor HOURS !!And no contact or mail to report this breakdownIt is really disappointing! I see that it's a known situation, they even added a NB in the post: NB Dear contestants, please take into consideration that support for the contest cloud sql environment is only available during business hours M-F 9-5 US Eastern Time. We seem to be experiencing a failure of the cloud environment such that deployments are stuck in Pending status for some users.

Hey Community, Enjoy the new video on InterSystems Developers YouTube: ⏯ Quick wins with InterSystems IRIS Vector DB This demo shows how to enhance an existing tools using vector search. With it we can provide more relevant search results for user queries and help mitigate data redundancy in the application. 🗣 Presenter: @Vivian.Lee, Applications Developer, InterSystems Enjoy watching, and look for more videos! 👍

Hey Developers, Watch this video to learn about InterSystems IRIS's new ability to integrate seamlessly with industry-standard observability tools to gather and visualize your InterSystems IRIS metrics, logs, and traces. ⏯ Modern Observability with InterSystems IRIS & Open Telemetry@ Global Summit 2024 Presenters:🗣 @Michelle.Stolwyk​​​​​, Director of Development, InterSystems🗣 @Robert.Kuszewski, Product Manager, Developer Experience, InterSystems Subscribe to our YouTube channel InterSystems Developers to stay up to date!

As of InterSystems IRIS® data platform version 2025.1, InterSystems is officially deprecating MultiValue and including it in the Deprecated and Discontinued Features list. While InterSystems will continue to support existing customers using MultiValue, it is not recommended for new applications. What This Means for You: Continued Support: Support for MultiValue will still be available through the Worldwide Response Center (WRC) on a "best effort" basis, as is provided for releases older than our Minimum Supported Versions. Future Removal Possibility: While there are no immediate plans to remove MultiValue from our products, InterSystems reserves the right to do so in a future release. Customer Guidance: If you have questions about your current or planned use of MultiValue, we encourage you to reach out to your InterSystems account team for guidance. The deprecated designation signals that customers should plan to eliminate their use of MultiValue. We recognize that this may impact ongoing projects, and we appreciate your cooperation as we continue evolving our platform. For further information or concerns, please feel free to comment below or contact your InterSystems representative.

Hi Community! Check out the new video on how to build the frontend UI by prompting it in lovable or (potentially) any spec first REST API in InterSystems IRIS: 📺 Prompt the frontend UI for InterSystems IRIS with Lovable 🗣 Presenter: @Evgeny.Shvarov, Senior Manager of Developer and Startup Programs, InterSystems Share your thoughts or questions in the comments to this post. Enjoy!

Hi group, I am trying to take the InterSystems HL7 Interface Specialist certificate test. So is this an open book test? is there any Lab involved with vm? I did the search but I am not able to find such information. I am trying to find out more information before I actually take the test. Thank you Hi Yuhong, The InterSystems HL7 Interface Specialist certification exam is not an open book exam. It consists of a series of 68 multiple choice/multiple response questions. You can read more about the exam here. If you already have the InterSystems HL7 Interface Specialist certification, and that certification is within 6 months of its expiration date, then you have the option of extending your certification by 5 more years by taking the performance-based recertification project. In this project, you are given a vm with an IRIS instance and your task is to create an HL7 production according to the provided specification. You can read more about the recertification project here. Please feel free to ask any more questions here or you can email your questions to certification@intersystems.com

Hi Developers, We are happy to announce the new InterSystems online programming contest dedicated to all things health-related: 🏆 InterSystems FHIR and Digital Health Interoperability Contest 🏆 Duration: May 12 - June 1, 2025 Prize pool: $12,000 The topic Develop any interoperability FHIR solution or Healthcare Interoperability solution or a solution that helps to develop or/and maintain interoperability solutions using InterSystems IRIS for Health, Health Connect, or FHIR server. General Requirements: An application or library must be fully functional. It should not be an import or a direct interface for an already existing library in another language (except for C++, there you really need to do a lot of work to create an interface for IRIS). It should not be a copy-paste of an existing application or library. Accepted applications: new to Open Exchange apps or existing ones, but with a significant improvement. Our team will review all applications before approving them for the contest. The application should work either on IRIS Community Edition or IRIS for Health Community Edition. Both could be downloaded as host (Mac, Windows) versions from Evaluation site, or can be used in a form of containers pulled from InterSystems Container Registry or Community Containers: intersystemsdc/iris-community:latest or intersystemsdc/irishealth-community:latest . The application should be Open Source and published on GitHub or GitLab. The README file to the application should be in English, contain the installation steps, and contain either the video demo or/and a description of how the application works. Only 3 submissions from one developer are allowed. NB. Our experts will have the final say in whether the application is approved for the contest or not based on the criteria of complexity and usefulness. Their decision is final and not subject to appeal. Prizes 1. Experts Nomination - a specially selected jury will determine winners: 🥇 1st place - $5,000 🥈 2nd place - $2,500 🥉 3rd place - $1,000 🏅 4th place - $500 🏅 5th place - $300 🌟 6-10th places - $100 2. Community winners - applications that will receive the most votes in total: 🥇 1st place - $1,000 🥈 2nd place - $600 🥉 3rd place - $300 🏅 4th place - $200 🏅 5th place - $100 ❗ If several participants score the same number of votes, they are all considered winners, and the prize money is shared among the winners.❗ Cash prizes are awarded only to those who can verify their identity. If there are any doubts, organizers will reach out and request additional information about the participant(s). Who can participate? Any Developer Community member, except for InterSystems employees (ISC contractors allowed). Create an account! Developers can team up to create a collaborative application. 2 to 5 developers are allowed in one team. Do not forget to highlight your team members in the README of your application – DC user profiles. Important Deadlines: 🛠 Application development and registration phase: May 12, 2025 (00:00 EST): Contest begins. May 25, 2025 (23:59 EST): Deadline for submissions. ✅ Voting period: May 26, 2025 (00:00 EST): Voting begins. June 1, 2025 (23:59 EST): Voting ends. Note: Developers can improve their apps throughout the entire registration and voting period. Helpful Resources: ✓ Documentation: InterSystems IRIS for Health FHIR Components documentation InterSystems Cloud FHIR Server documentation InterSystems Interoperability documentation Healthcare Data Transformations documentation ✓ Tools: Clinfhir - FHIR visualization and developer tool. ✓ Example applications: FHIR Server Template iris-healthtoolkit-template interoperability-embedded-python FHIR HL7 SQL Demo FHIR DropBox HL7 and SMS Interoperability Demo IrisHealth Ensdemo UnitTest DTL HL7 Healthcare HL7 XML FHIR Interoperability Examples FHIR-Orga-dt FHIR Peudoanonimisation Proxy FHIR-client-java FHIR-client-.net FHIR-client-python FHIR related apps on Open Exchange HL7 applications on Open Exchange ✓ Online courses: Interactive Digital Health Interoperability Foundation - An intro course into Digital Health Interoperability productions built with InterSystems IRIS for Health FHIR Data Architecture FHIR Integrations HL7 Integrations Learn FHIR for Software Developers Exploring FHIR Resource APIs Using InterSystems IRIS for Health to Reduce Readmissions Connecting Devices to InterSystems IRIS for Health Monitoring Oxygen Saturation in Infants FHIR Integration QuickStart ✓ Videos: 6 Rapid FHIR Questions SMART on FHIR: The Basics Developing with FHIR - REST APIs FHIR in InterSystems IRIS for Health FHIR API Management Searching for FHIR Resources in IRIS for Health ✓ For beginners with IRIS: Build a Server-Side Application with InterSystems IRIS Learning Path for beginners ✓ For beginners with ObjectScript Package Manager (IPM): How to Build, Test and Publish IPM Package with REST Application for InterSystems IRIS Package First Development Approach with InterSystems IRIS and IPM ✓ How to submit your app to the contest: How to publish an application on Open Exchange How to submit an application for the contest Need Help? Join the contest channel on InterSystems' Discord server or talk with us in the comment to this post. We're waiting for YOUR project – join our coding marathon to win! By participating in this contest, you agree to the competition terms laid out here. Please read them carefully before proceeding.

My organization is looking for a full time Intersystems Solutions Engineer to join the team. Based in NY, the Solutions Engineer will design technical architectures to support efforts across the health system focused on clinical data exchange with other provider organizations and payors.

Edit:May have found the issue but not the solution."SELECT * FROM wmhISTORYdETAIL" runs as a passthrough without asking for the DNS.but'SELECT Count([wmhISTORYdETAIL].[HistHMNumber] AS CountOfHistHMNumber FROM [wmhISTORYdETAIL] WHERE ((([wmhISTORYdETAIL].[HistMovType])='Receipt') AND (([wmhISTORYdETAIL].[HistMovDate])>=Date()-1) AND (([wmhISTORYdETAIL].[HistMovDate])<Date()));'asks for the DNS but both are linked to a table that has the password saved.Any Ideas please?RobHiI have created an MS Access database with a passthrough query to our Intersystems Cache WMS system. If I use "SELECT * from thetable" as the passthough query I can use VB.NET to query the passthrough and it works fine but this dataset getting rather large so I changed it to"Select field1, field2, filed3 from thetable" but the passthrough no longer works as it did.....it works in MS Access but not from the VB.NET app.The VB.Net Query is:SELECT Count([xxx].[HistHMNumber] AS CountOfHistHMNumber FROM [xxx] WHERE ((([xxx].[HistMovType])='Receipt') AND (([xxx].[HistMovDate])>=Date()-1) AND (([xxx].[HistMovDate])<Date()));where [xxx] is the passthrough querybut now I get an ODBC error in the VB.Net app"System.Data.OleDb.OleDbException: 'ODBC--call failed.'"The error/issue appears to be in the SQL but if Im lift it and paste it into the MS Access database. it works?!?!Any help would be appreciated.Many ThanksRob Hello Robert, Did you resolve this or log with our helpdesk? Regards David Underhill @ Chess