Search

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 In this video, @Gunnar.Hammonds shows how to set up your VPN connections and manage routing. He also introduces networking concepts like BGP peering. New to InterSystems Cloud Services? Get an overview (video, 4m).

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 In this video, @Stefan.Wittmann shows how to deploy this cloud service and easily import data, run SQL queries, and integrate with your applications.

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.

Hey Community, We're pleased to invite all the developers to the upcoming kick-off webinar for the InterSystems AI Programming Contest! Discover the exciting challenges and opportunities that await Vector Search, GenAI and AI Agents enthusiasts in this contest. We'll discuss the topics we expect from participants and show you how to develop, build, and deploy applications using the InterSystems IRIS data platform. Date & Time: Monday, March 17 – 11 am EST | 5 pm CET Speakers: 🗣 @tomd, Product Manager🗣 ​​​@Dean.Andrews2971, Head of Developer Relations🗣 ​​​@DKG, Developer Relations Evangelist ✅ Register for the kick-off today! Hi Devs! Please join the kick-off webinar in 15 minutes in Zoom: https://us06web.zoom.us/j/5635395305?pwd=mkfbpaSr5QotWR1JqKbAOm3PYPwwog.1 Or enjoy watching the stream via YouTube: https://youtube.com/live/OlxmpFCipMk?feature=share

Hey Community, We're happy to announce that there's a preliminary list of sessions available for you to peruse at your leisure while waiting for the Ready 2025! At InterSystems READY 2025 we are planning over 60 individual sessions. We have sessions for everyone on a wide variety of topics and technologies. All the sessions are divided into 8 categories based on the points of interest: Put AI into Action Transform Health Plans Boost Product Impact Get Health Data Connected Secure. Fast. Scalable. Robust. Develop Innovative Solutions Maximize Your Data Architecture Make the Most of the Cloud We're still finalizing the session descriptions and schedule. Stay tuned for updates and more information soon!

Hey Community, We're excited to invite you to the next InterSystems UKI Tech Talk webinar: 👉Unlocking the Power of InterSystems Data Fabric Studio ⏱ Date & Time: Thursday, May 29, 2025 10:30-11:30 UK 👨‍🏫 Speaker: @Saurav.Gupta, Data Platform Team Lead, InterSystems Business leaders across every industry – including healthcare, financial services, supply chain, manufacturing, and the public sector – struggle with accessing unified, timely data spread across applications, data feeds, data warehouses, data lakes, and data marts. Join us for our next exclusive Tech Talk Webinar hosted by InterSystems expert Saurav Gupta as he introduces InterSystems Data Fabric Studio™—the latest innovation designed to offer a new approach to accessing data, delivering the right data to the right person at the right time, in a secure and controlled environment. It's a fully managed, self-service, cloud solution with all the necessary components to create and maintain an enterprise data fabric. An enterprise data fabric is a new architectural approach that speeds and simplifies access to data assets across the entire business. It accesses, transforms, and harmonises data from multiple sources, on demand, to make it usable and actionable for a wide variety of business applications. >> REGISTER HERE <<

Hi all! In this article I would like to review those VS Code extensions which I use myself to work with InterSystems and which make my work much more convenient. I am sure this article will be useful for those who are just starting their journey to learn InterSystems technologies. However, I also hope that this article could be useful for experienced developers with many years of experience and open up new possibilities for them when using VS Code for development. I recommend that everyone who works with InterSystems has these extensions installed and in this article I will show how to use some of them. You can read more about the functionality and use of each extension in the Extensions section of VS Code, there you can also download, update and uninstall extensions: After installation, extension icons appear on the side or at the bottom of the code editor. Mandatory extensions I think it makes sense to start our journey with those basic extensions, without which working with InterSystems in VS Code becomes impossible. The InterSystems Server Manager Extension for VS Code assists in specifying server connections. The InterSystems ObjectScript Extension for VS Code assists in writing and compiling code files. The InterSystems Language Server Extension for VS Code provides a language server implementation for ObjectScript, enabling coloring, code completion, linting, and more. Together, these extensions provide developers with a streamlined way of creating, testing, and deploying full-stack applications built on InterSystems. Additional extensions In addition to the basic necessary extensions, VS Code offers many other extensions. You can write code without them, but using them makes development more efficient when using any technology stack, including InterSystems technologies. I will describe a few which seem to me to be a must-have. The Docker extension makes the management of dockerised projects a little easier. You can automatically generate a Dockerfile for projects, run images and manage running containers. SQLTools Driver for InterSystems IRIS and SqlTools - are two very handy extensions that work together. Using them, you can create and execute the database SQL queries in VS Code without having to go into the management portal and perform sql queries to interact with the table contents there. Today, it's hard to imagine developing a project without using version control. Most often this is Git, and Visual Studio Code has minimal support for it right out of the box. But if that's not enough for you, check out the next two extensions: Git Graph - shows branches and their status schematically. This is useful in situations where you need to quickly understand the status of branches, e.g. when they merge. Git Lens - allows you to see the history of changes to the highlighted line and its author. It is indispensable for teamwork! EditorConfig - an extension to improve code appearance, requires writing .editorconfig file, in which you can specify any code formatting settings. It's important to note that by default such functionality can be implemented by InterSystems Language Server extension for VS Code, to apply standard ObjectScript code formatting in VS Code you need to use key combination: Windows - [Shift + Alt + F], Mac - [Shift + Option + F], Ubuntu - [Ctrl + Shift + I]. But when using .editorconfig file you can specify your own code formatting for different files within the project. In this article, I've only looked at the extensions I've used myself. I would be grateful if you could take the time to write in the comments what else can be used to make development more convenient. Then this article will become even more useful! Very nice initial How-To! Thank you especially for the animated GIFs! Excellent read, will be installing a couple of these now! Hi @Maria.Gladkova, Nice article and very well explained. Thanks Very nice article @Maria.Gladkova to start developing with VSCode! The most noteworthy extensions I'm using too in my VSCode setup: Encode decode (convert text to other formats like Base64) OpenAPI (swagger) Editor (specifying & documenting your REST api endpoints) WSL (enabling direct use of the Windows Subsystem for Linux in VSCode) Thank you very much, I've already installed and tried some of them out! Good luck coding! Thanks! Thank you! The marketplace search is a little sensitive, so note that it's "GitLens", not "Git Lens". Also worth noting that developments in VS Code itself since the original article have added new Git features, so the GitLens and/or Git Graph extensions are arguably less relevant/needed.

Hey Developers, We'd like to invite you to join our next 🏆 InterSystems Tech Article Contest in Portuguese 🏆 Duration: May 12 - Jun 12, 2023 We can't wait for your articles! Good luck 🍀

Hi Developers! InterSystems continues the Developer Meetup event series. The next one will happen on November 17th from 5:30 pm-8 pm ET in Boston, MA, USA.At this meetup, you will learn more about Kubernetes, Mirantis Lens tool, and how to run Lens with InterSystems IRIS IKO (InterSystems Kubernetes Operator). Food and drink will be provided. > Register here < Agenda:👉 "InterSystems Overview and Developer Resources" by @Dean.Andrews2971, Head of Developer Relations, InterSystems👉 "Mirantis Overview and Developer Resources" by Tommy Decker, Account Executive, Mirantis👉 "Scaling Stateful Workloads in Kubernetes" by @Robert.Kuszewski, Product Manager - Developer Experience, InterSystems👉 "Demo of Lens with InterSystems IRIS IKO (InterSystems Kubernetes Operator)" by Toby Goodlock, Solution Architect, Mirantis ⏱ Date and Time: November 17th from 5:30pm-8pm ET📍 Location: Democracy Brewing, Boston

Here're the technology bonuses for the InterSystems Developer Tools Contest 2023 that will give you extra points in the voting: Embedded Python usage Docker container usage ZPM Package Deployment Online Demo Code Quality pass Article on Developer Community The second article on Developer Community Video on YouTube First Time Contribution Community Idea Implementation See the details below. Embedded Python - 3 points Use Embedded Python in your application and collect 3 extra points. You'll need at least InterSystems IRIS 2021.2 for it. Docker container usage - 2 points The application gets a 'Docker container' bonus if it uses InterSystems IRIS running in a docker container. Here is the simplest template to start from. ZPM Package deployment - 2 points You can collect the bonus if you build and publish the ZPM(ObjectScript Package Manager) package for your Full-Stack application so it could be deployed with: zpm "install your-multi-model-solution" command on IRIS with ZPM client installed. ZPM client. Documentation. Online Demo of your project - 2 pointsCollect 3 more bonus points if you provision your project to the cloud as an online demo. You can do it on your own or you can use this template - here is an Example. Here is the video on how to use it. Code quality pass with zero bugs - 1 point Include the code quality Github action for code static control and make it show 0 bugs for ObjectScript. Article on Developer Community - 2 points Post an article on Developer Community that describes the features of your project. Collect 2 points for each article. Translations to different languages work too. The Second article on Developer Community - 1 point You can collect one more bonus point for the second article or the translation regarding the application. The 3rd and more will not bring more points but the attention will all be yours. Video on YouTube - 3 points Make the Youtube video that demonstrates your product in action and collect 3 bonus points per each. Examples. First Time Contribution - 3 points Collect 3 bonus points if you participate in InterSystems Open Exchange contests for the first time! Community Idea Implementation - 3 points You can get 3 extra bonus points if the dev tool implements one of the ideas listed as Community Opportunity on the InterSystems Idea portal. The list of bonuses is subject to change. Stay tuned! Good luck with the competition! Bonus for the Community Idea implementation is introduced Rules changing to get additional points halfway through the contest period? Hi Stefan! Usually not. We know, that rules changing doesn’t help. But sometimes, very rarely, we add bonuses on-the-go. Like this time we believe that this bonus will help to pay attention to ideas, published by community members, and implement solutions, that community requested and voted for. And there is still 10 days to submit the app and one week more to polish it. We believe this bonus will not harm anyone. If it does - we can discuss it. Hi Evgeny, As you can see in the article below, we used one idea from InterSystems Idea. https://community.intersystems.com/post/iris-tripleslash-lets-rock-together We only saw this additional (and very welcome) bonus now. Here it's the idea that inspired us, as mentioned in the article: https://ideas.intersystems.com/ideas/DP-I-175

Hey Community, We are glad to invite you to the upcoming kick-off webinar on the InterSystems Developer Tools Contest. In this webinar, we'll talk about how to choose a project and show you how to develop, build and deploy applications on InterSystems IRIS data platform. Also, there will be information about the hot internal projects at the moment (SQL client, VS Code unit tests and Jupyter notebooks), how to look at community opportunities in the Ideas portal, and what InterSystems would like to do with the management portal. Date & Time: Monday, January 23 – 12 pm EST | 6 PM CET Speakers: 🗣 @Raj.Singh5479, InterSystems Product Manager 🗣 @Dean.Andrews2971, InterSystems Head of Developer Relations 🗣 @Evgeny.Shvarov, InterSystems Developer Ecosystem Manager >> Register here << Developers! Don't miss the opportunity to register for the upcoming webinar! The webinar will start tomorrow at 12 pm EST | 6 PM CET. Hi dear community, If you lack inspiration for the contest, here are some ideas: * A tool to improve the load of DDL or SQL statements in IRIS. * Why, because for now, we have to run an iris terminal then run an objectscritp command to load the DDL or SQL statements. * I wish a way that we can have a tool that bring the ability to parse a DDL or SQL file from a shell. * Example : iris load -f /path/to/file.sql * A tool to automatically export objectscript classes to the local folder * I know we can do it with Timothy's tool, but I wish a simple hook that just export new classes or modified classes to the local folder. Not the whole source control system.

Hi Community, Let's meet together at the online meetup with the winners of the InterSystems Developer Tools Contest – a great opportunity to have a discussion with the InterSystems Experts team as well as our contestants. Winners' demo included! Date & Time: Thursday, February 16, 5 PM GMT | 12 PM EST Join us to learn more about winners' applications and to have a talk with our experts. ➡️ REGISTER TODAY See you all at our virtual meetup!

Hi Community! 🎆 We're stoked to share the fantastic news with you! Our ❤️‍🔥 InterSystems Developer Hub ❤️‍🔥 is up and running and ready to welcome its users! There's loads of helpful info there: InterSystems tutorials Explanations on how to use different tools Info about contests much more And in general most of what you may need to start working with InterSystems technologies! Check it out! As usual, all your input is very welcome in the comments. Tell us what you think ;) very nice hotsite nice landing page! InterSystems Developer Hub - best place for developers!) Cool!

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! There are occasions when you really need to get in touch with a member of our Community a.k.a. author of a post or developer of a particular project, to discuss something, catch up, or whatever. And exactly for this reason, we have Direct Messages where you can send a message directly to a specific person or even have a group chat! Accessing Direct Messages is easy. Just click on the Envelope button near your profile picture: And you will get lots of options: First of all, you can see all the messages you've received in the Inbox section, all the unread messages in the Unread, and all the bookmarked - you guessed it - in Bookmarks. Also, via this left menu you can set the settings for direct messages using the Settings section: Getting back to the Inbox section, if you select one or several (or Select all) messages you can Delete, Mark as unread / read, or Add to bookmarks the whole batch. And if you add a message to bookmarks you will be able to quickly find it in the Bookmarks section. Another way to add a message to bookmarks is to hover your mouse over it and click the star that appears near the date: Messages that are in bookmarks will have a green star in this line. There are a few more ways to quickly send a DM to a Community member: go to the profile of the member you want to contact you can also quickly start a private discussion from the post page on a specific topic described in the post – the post title will automatically pull up as the subject of the DM This is it, easy-peasy. Happy messaging!