Search

At hackathons that InterSystems participated and I supported, many students were asking how all their teammates could use the same IRIS database that they spun up in a container. I suggested using ngrok to expose their localhost IRIS and realized we don't have documentation on that. Hence, I thought this would be great to let more people knwo about this powerful technique for enhancing collaboration during development and testing. ## Step-by-Step Guide to Exposing InterSystems IRIS with ngrok This guide will walk you through the process of exposing your local InterSystems IRIS instance using ngrok. Follow these steps to get started quickly. ### Step 1: Set Up Your IRIS Container 1. **Install Docker**: Ensure that Docker is installed on your machine. 2. **Run the IRIS Container**: Use the following command to start an InterSystems IRIS container: ```bash docker run --name iris -d --publish 52773:52773 containers.intersystems.com/intersystems/iris-community:latest ``` This command pulls the latest version of the IRIS Community Edition and runs it on port 52773. ### Step 2: Install ngrok 1. **Download ngrok**: Go to the [ngrok website](https://ngrok.com/download) and download the appropriate version for your operating system. 2. **Install ngrok**: - For **MacOS**: Use Homebrew: ```bash brew install ngrok/ngrok/ngrok ``` - For **Windows**: Use Chocolatey: ```bash choco install ngrok ``` - For **Linux**: Follow the installation instructions provided on the ngrok website. ### Step 3: Configure ngrok 1. **Authenticate ngrok**: After installing, you need to authenticate your ngrok account. Run the following command: ```bash ngrok config add-authtoken YOUR_AUTHTOKEN ``` Replace `YOUR_AUTHTOKEN` with your actual token from the ngrok dashboard. ### Step 4: Start the Tunnel 1. **Expose Your IRIS Instance**: Run this command to create a tunnel to your local IRIS instance: ```bash ngrok http 52773 ``` 2. **Access the Public URL**: After running the command, ngrok will provide a public URL (e.g., `https://abc123.ngrok.io`). This URL can be accessed by anyone over the internet. ### Step 5: Share Access - Share the public URL with your teammates or collaborators so they can access the IRIS database running on your local machine. ## Best Practices - **Security**: Implement authentication and authorization for your IRIS instance to protect sensitive data. - **Temporary Use**: Remember that ngrok is primarily for development and testing; avoid using it for production environments. - **Monitor Connections**: Keep an eye on the ngrok dashboard for connection statistics and potential issues. ## Conclusion Exposing your InterSystems IRIS container using ngrok is a straightforward process that enhances collaboration during development. By following this step-by-step guide, you can easily make your local database accessible to teammates, facilitating better teamwork and innovation. Always prioritize security when exposing local services, and enjoy seamless development with IRIS and ngrok!

You’ve been dropping memes into our inbox — here's our top 20!Get ready to laugh, nod in agreement, and maybe spot the one you created! 👀Let us know in the comments which meme is your favorite! 1. Author: Robert Cemper 2. Author: Aya Heshmat 3. Author: Matthew Thornhill 4. Author: Henry Ames 5. Author: Ben Spead 6. Author: Jonathan Zhou 7. Author: Alessandra Carena 8. Author: Haddon Baker 9. Author: Liam Evans 10. Author: Macey Minor 11. Author: Marco Di Giglio 12. Author: FRANCISCO LOPEZ 13. Author: Pietro Montorfano 14. Author: David Cho 15. Author: Henry Ames 16. Author: Andre Larsen Barbosa 17. Author: Liam Evans 18. Author: Mindy Caldwell 19. Author: Dinesh 20. Author: Mathieu Delagnes love it! great work everyone :) awesome !! 😁 🤣🤣🤣🤣🤣🤣 These are fun, great work by all the authors :)

Hello Community, Some of you have passed the InterSystems Official Certification and would like to get a nifty green tick on your profile avatar and all your certificates in your DC profile so that others know that you know... you know what we mean So, to add certification to your DC profile, you need to take 3 easy steps: 1️⃣ Go to your DC profile 2️⃣ Go to the InterSystems Certification section 3️⃣ Click on the Load my certification(s) button and that's it! The system will send the request to Credly with your DC email. If your certification is linked to the same email, your certificates will be loaded automatically: If not, please follow the detailed steps described on the page: And you're done. Now everyone knows that you know... ;) Congratulations on adding the Certification and on actually passing it. Well done! Ooooh, I have a green tick. That's one up on twitter :) Yeah, congrats!! 🎉 The certifications came across on my profile but for some reason I am not seeing the green checkmark. Is this supposed to work for InterSystems employees? nevermind - it shows up now for some reason :) Yes, it may take some time for the checkmark to load on your profile ;)

Hello community, The Certification Team of InterSystems Learning Services is excited to announce the release of our new InterSystems IRIS Development Professional exam. It is now available for purchase and scheduling in InterSystems exam catalog. Potential candidates can review the exam topics and the practice questions to help orient them to exam question approaches and content. Candidates who successfully pass the exam will receive a digital certification badge that can be shared on social media accounts like LinkedIn. If you are new to InterSystems Certification, please review our program pages that include information on taking exams, exam policies, FAQ and more. If you have ideas about creating new certifications that can help you advance your career, the Certification Team of InterSystems Learning Services is always open to ideas and suggestions. Please contact us at certification@intersystems.com if you would like to share any ideas. Looking forward to celebrating your success, Celeste Canzano - Certification Operations Specialist, InterSystems It's a great exam. I'm not just saying that because I helped develop it, but it has some great questions and topics on it that really make you think. I can't say I enjoyed the process of taking my last Intersystems exam, (not this one), but I certainly enjoyed the feeling after I passed it. :)It's great to get that validation that you do actually know what you're talking about!

Hey Community, We're pleased to invite all the developers to the upcoming kick-off webinar for the InterSystems External Languages Contest! During the webinar, you will discover the exciting challenges and opportunities that await developers in this contest. We will also discuss the topics we would like the participants to cover and show you how to develop, build, and deploy applications using the InterSystems IRIS data platform. Date & Time: Wednesday, September 24 – 11:30 am EDT | 5:30 pm CEST Speakers: 🗣 @DKG, Developer Relations Evangelist, InterSystems​​​🗣 @Evgeny.Shvarov, Senior Manager of Developer and Startup Programs, InterSystems🗣 @Stefan.Wittmann, Product Manager, InterSystems​​​🗣 @Raj.Singh5479, Product Manager - Developer Experience, InterSystems ✅ Register for the kick-off today!

Hey Community, We're excited to invite you to the next InterSystems UKI Tech Talk webinar: 👉The Future of Healthcare Integration with Health Connect & InterSystems ⏱ Date & Time: Thursday, July 3, 2025 10:30-11:30 UK Speakers:👨‍🏫 @Mark.Massias, Senior Sales Engineer, InterSystems👨‍🏫 Mike Fitzgerald. Head of Customer Solutions, ReStart As the NHS continues to advance its digital transformation agenda, seamless interoperability has become a crucial priority for healthcare IT professionals. InterSystems Health Connect is leading the way as a superior integration engine, offering enhanced scalability, security, and performance to support evolving data exchange needs. This exclusive webinar will explore how you can overcome interoperability challenges, streamline system migrations, and benefit from real-world success stories—ensuring you stay ahead of NHS standards for connected care. Join us for an insightful session where InterSystems and our highly experienced implementation partner ReStart will showcase the benefits of Health Connect, providing actionable strategies for seamless integration and transitioning from legacy solutions. Discover how Health Connect supports NHS standards out-of-the box and enhances connectivity across trust and regional healthcare networks. This is your opportunity to future-proof your healthcare IT strategy and drive smarter, more efficient data integration. >> REGISTER HERE << When I looked yesterday there was a "Learning Services, Dev Community and Partner Portal Overview" listed for 24th July. When I went to register for both the future of healthcare integration and the learning services, Dev Community etc one, the latter has disappeared. Any plans to reschedule? Hi Colin! You're correct, I also remember seeing the webinar about the Developer Community at the end of this month. But in the end, it was decided to cancel the tech talk on the 24th July. With the launch of the new partner portal at Ready 2025, it was decided to reschedule for a time when more confirmed details are available and it aligns better with the broader program. An email is scheduled to go out this morning to all those who have registered to date, and the meeting invite will be cancelled this PM.

Hey Community, We're excited to invite you to the next InterSystems UKI Tech Talk webinar: 👉AI Vector Search Technology in InterSystems IRIS ⏱ Date & Time: Thursday, September 25, 2025 10:30-11:30 UK Speakers:👨‍🏫 @Saurav.Gupta, Data Platform Team Leader, InterSystems👨‍🏫 @Ruby.Howard, Sales Engineer, InterSystems Traditional keyword search has limits — especially when users don't know the exact words to use. Enter vector search: a game-changing approach that captures semantic meaning, not just literal text. In this session, we’ll explore how InterSystems IRIS brings this powerful capability to life with native support for vector and embedding types. You’ll see: How vector search enhances results by understanding context and intent Use cases like semantic document search and retrieval-augmented generation (RAG) A high-level walkthrough of how to implement vector search in IRIS, from storing embeddings to using similarity functions like VECTOR_DOT_PRODUCT Tips on getting started quickly — whether you're integrating with AI models or building smart data experiences This session is ideal for developers, architects, and technical stakeholders curious about adding intelligent search to their apps. >> REGISTER HERE <<

Hello,I am not certain where to post this, but I am seeking to hire consultants with Intersystems Caché DBA experience. Is there a source for qualified professionals?Thank you!Brian Brian,For years this was the official InterSystems-sponsored site for this type of thing:http://skills.intersystems.com/However, it looks rather empty at the moment (I think things expire after 6 months or something like that). It wouldn't hurt to post your position there - perhaps with increased advertising on the Developer Community this will pick up in its usage again.HTH,Ben

In the next ten years the applications will radically change, see my vision about it: Today, the web apps are developed using modern HTML 5/CSS/Javascript frameworks like React, Angular, Bootstrap, etc. These web apps are focused on responsive views from the laptop to tablets and mobile screens. In the early future, new forms to interacting with the user come true, especially cognitive conversations based on voice, bots and augmented reality and IoT/Wearable conversations deployed on smart watches, clothing, shoes, glasses, portable healthcare devices and home smarts things like Amazon Alexa, smart TVs, and so on. These cognitive apps will retire current UX development and set up cognitive development kits to interact with user. Data platforms used as backend to the next front end apps will require real time intelligent data processing on multiple formats and volumes and SQL databases will be legacy technology. On this middleware layer or digital services layer, as I like to define, thanks to the trillion or more micro services instances operating, the current server technologies will be legacy technology too. ESB, Web App and MQ message servers will require operate like as Real Time Scalable Corporate Data Lakes with micro services API Management, not just dealing with request/response synchronous and asynchronous messages. These servers should be intelligent/cognitive data aware, understand sentiments and natural language requests. The future is not very promising too to business processes and business intelligent management servers, like BPMN engines, ECM and CMS repositories and traditional BI engines. Words as information will be not primary source of information, workflows will not run human tasks with HTML interfaces and automatic tasks with web services and the analytic information will be not sourced by SQL/Relational databases. In the future workflows will be cognitive and will learn at real time how to response to the user. Content will be unstructured, large, non-relational and the ownership defined by biometric identity and business decisions will be provided by machine learning, no more by prescriptive dashboards. App development to digital services layer will not use programming languages, that will be considered the new Assembly language. In the future, the digital and business logic will be developed using low code platforms with declarative programming and high level composite digital services ready to automate continuous business changing cognitive apps. The IT infrastructure and your assets will be dynamic, on the cloud and hyper converged to support big data scenarios, multiple elastic IT digital service instances to process, store and transmit data. Will be necessary automate the continuous deployment of the digital services developed to this new IT infrastructure, without human interaction, considering automatic QA process. For this, DevOps techniques will be mandatory, storages, network and services will have required to be digital services too. And thanks the IoT, Big Data and Cognitive Services dozens servers will be packaged on single hyper converged appliances and one VM has become dozens of Docker instances. The Intersystems IRIS is the most prepared Data Platform on the market to this future. It has on the same server data repository to SQL, NoSQL, Object, Document and Multimedia data. On the same server has an intelligent ESB/MQ engine connected with your Big Data/Data Lake implementation operating in real-time. With IRIS it is easy implement intelligent data aware micro-services with low code implementation and IRIS has a fantastic BI engine with natural processing language exposed as REST micro service interface to consume on traditional or future digital services. I see IRIS as a perfect central piece to deploy on the current and future digital layer and with support to Docker and cloud architecture. For me, using IRIS today is to be in conformity and alignment with the IT present and the future, preserving, in this way, the investments already made. Please consider posting it here. I don't think this kind of marketing material should be on IDC.My two cents. Hi, @Yuri.Gomes! I kind agree with Herman here - the post is great, well done and very thoughtful. But if you add to this one or two working technical solutions on IRIS to prove/describe the idea better, that will be much interesting for the audience if the Developer Community. I agree. I did not find option to remove this article from this channel. Can you remove @Evgeny? Thanks. Hi, Yuri! No need to remove, the topic is very interesting! It's just the request for technical content! It is always in a great demand on DC!

Hello,We're having troubles with working over Telnet on Caché Unicode with WRQ Reflection.We can't input extended characters (é,à,Ø,...), DELETE-key doesn't work, ...Has anyone a solution for working with WRQ Reflection or a decent alternative ?We tried Putty and Caché-terminal but these are not sufficent. Regards,Kurt Hofman. $zm = RY\Latin1\K\UTF-8\Reflection can show unicode's just fine, it's just that we can't input them ! Doesn't seem to work at all, ...The only thing that works is Caché Terminal, but soms F-keys don't work and our customer don't like it :-( The main thing I can suggest is to verify that the client and server agree on the encoding. It's been years since I've used Reflection; hopefully it supports UTF-8. Check your settings and/or documentation. When you're in a Caché session, look at the value of the $zmode special variable: USER>w $zm RY\Latin1\K\UTF8\ I'm not sure offhand what determines the default I/O translation table for a terminal, but if you see "RAW" instead of "UTF8", you can set it manually: USER>u 0:(/IOT="UTF8") USER>w $zm RY\Latin1\K\UTF8\ Hi Kurt,Some old terminal emulators cannot work with UTF8.I used AniTa which had the same problem connecting to a Caché Unicode server.I tried TeraTerm which is free and can at least work with UTF8 and VT320 emulation, but i haven't tried all our terminal tricks yet to see if it can do the job for 100%.Once you start TeraTerm, don't forget to change in Setup->General the language to UTF-8,.Setup -> Save Setup will save all your changes to a Teraterm.ini file so they will be in effect the next time.

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? Rob Hi I 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 query but 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 Thanks Rob Hello Robert, Did you resolve this or log with our helpdesk? Regards David Underhill @ Chess

Hello All,I have been associated with Intersystems technologies for over a decade working on Cache, Zen, Ensemble etc.This is a very niche field and a lovely community. I wanted to extend my hands to connect with people who are of same field or related to it.Here is my linkedin profile. Pls feel free to send me an invite or drop me a messagehttps://www.linkedin.com/in/vneerav/ Hi Neerav!Perhaps we just need to add the LinkedIn field in a member's profile?Would it help? What do you think? Yes. Definitely Issue is filed

We would like to use our Caché-server as the source for our PABX-addressbook.The PABX only supports LDAP.Is it possible to use our Caché-instance as an LDAP-server ?Regards, Kurt Hofman. The native Cache LDAP support is only for an LDAP client.

Hi guys, I have accidentally clicked the remember password option in my Ensemble studio. So it is now not asking for username and password and even the authentication popup is not showing every time i open the studio. Is there anyway to remove the remember password option for the cache studio. Thanks, You can do this via the following (it is a little hidden):Studio > File > Change Namespace > Connect > (select instance) > Enter credentials and uncheck "Remember Password"Could you please give this a try and let us know if it works for you? You can remove saved password from windows registryrun regedit.open path HKEY_CURRENT_USER\Software\InterSystems\Cache\Servers\choose serverremove Server Password

Someone, please point me to the location of the cache ODBC drivers.I don't have acess https://login.intersystems.com/login/SSO.UI.Login.cls?referrer=https%253.... I need driver for acess the BD Intersystems Cache in the Power BI. For what operative system? I'm not sure if this will solve your problem, but you can find JDBC drivers in the installation folder: Installation folder > dev > java > lib > 1.8 You'll find the file intersystems-jdbc-3.6.1.jar. I believe you can use this to connect to Power BI, if necessary. Win11 I'm new here. I don't know how to search, I'm sorry, but would it be here within this same forum? Error: No worries, you can find more information at Documentation:https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=BNETODBC_introhttps://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=BTPI_jdbc