Search

Hi Developers! The InterSystems IRIS AI Contest is over. Thank you all for participating in our IRIS AI Competition! And now it's time to announce the winners! A storm of applause goes to these developers and their applications: 🏆 Experts Nomination - winners were determined by a specially selected jury: 🥇 1st place and $2,000 go to the iris-integratedml-monitor-example project by @José.Pereira 🥈 2nd place and $1,000 go to the iris-ml-suite project by @Renato.Banzai 🥉 3rd place and $500 go to the ESKLP project by @Aleksandr.Kalinin6636 🏆 Community Nomination - an application that received the most votes in total: 🥇 1st place and $1,000 go to the iris-ml-suite project by @Renato.Banzai 🥈 2nd place and $250 go to the iris-integratedml-monitor-example project by @José.Pereira 🥈 2nd place and $250 go to the SAPPHIRE project by @Yuri.Gomes Congratulations to all the participants! Thank you for your attention to the contest and the efforts you pay in this exciting coding competition! And what's next? A whole series of programming contests awaits InterSystems Developers! We will announce the next competition very soon – stay tuned! ➡️ More details in this post. Congratulations to the winners! Thanks to all the participants and to the organizers. Congrats for all winners!! Congratulations to all winners, incredible applications !!! The organization was fantastic. The contest staff is great. The contest is responsible to increase IRIS adoption to new developers and increasing open apps and samples about intersystems tech. It is a valuable instrument! We are very happy to hear such feedback! Thanks @Yuri.Gomes! ☺️ I certainly agree with you @Yuri.Gomes! And the discord community is also great!

What is Selective Build? Selective Build is a BI feature in InterSystems IRIS (introduced in version 2020.1). Selective Build allows you to build specific elements of your cube while keeping your cube online. What is special about Selective Build? Before getting into the details of Selective Build, a brief recap of the different phases during a regular cube build is important. Here are the phases in a regular cube build:1) Delete existing data in cube2) Populate cube with full set of data3) Build all indices in the cube Now that we are familiar with how a normal build works, we can understand the benefits of Selective Build. During a regular build, the cube must be offline since the first step is to delete the existing cube data and then populate the full cube again. This is not the case with Selective Build. Selective build takes only the specified cube elements offline and updates the data for these specific elements. This means that existing data is not deleted. Since existing data is not deleted, the cube does not need to be offline. The elements being built will be offline, which means if a user tries to query against these offline elements, they will see an error message. When should this be used? Selective Build is a great way to deploy updates to a cube model without needing to take the cube offline for extended periods of time. Depending on the size of the cube, it can take hours or even days to fully build the cube. Having the cube offline for an extended period of time to add a new dimension does not encourage frequent updates to the model. How is it used? From UI In Architect, any modified elements will automatically be kept track of. When you try and build your cube from the UI, the dialog box will give you the option to use Selective Build by default. This default selection also has any modified elements automatically selected. If you prefer to build the entire cube by using a regular build, this option can be selected. Build Cube API A new parameter was added to the Build Cube API. This new parameter is described as follows from the documentation: "pFactList is a list of specific Property names in the cube's fact class. If pFactList is supplied, the build will only update the columns listed in that fact list. This list can have either comma-delimited or $LB format. The specific facts being updated will be individually marked as unavailable for queries and queries referencing dimensions based on those facts will throw an error on prepare." I expect that the UI is used while actively developing modifications to a cube and the API is used while deploying changes to a different system. To learn more about Selective Build, please see the documentation.

Hi Community! We are pleased to invite you to the upcoming Online Meetup supported by InterSystems Israel Team on May 26 at 3:00 PM IDT (Israel Daylight Time) / 8:00 EDT (Eastern Daylight Time) Topic: Introduction to Using Containers What awaits you? A general introduction with Containers and how to work with Docker Containers We will learn how to work easily with InterSystems IRIS using Containers Speaker: @Tani.Frankel, Senior Sales Engineer at InterSystems Israel Note: The session does not require any prior knowledge of Containers. Attendees who would be able to actively participate (hands-on) would need to have Docker pre-installed on their computer (Windows and Linux Ubuntu). The language of the webinar is Hebrew. We are waiting for you at this webinar! ✌🏼 PLEASE REGISTER HERE! Tomorrow! Don't miss this webinar! 😉 PLEASE REGISTER HERE! Hey Developers! Now this webinar recording is available on InterSystems Developers YouTube Channel: Enjoy watching this video! And big applause to @Tani.Frankel! 👏🏼

Hi Community! This week is a voting week for the InterSystems IRIS Native API Programming Contest! We have 8 applications — so you have a set of applications to choose from! How to vote? This is easy: you will have one vote, and your vote goes either in Experts Nomination or in Community Nomination. Experts Nomination If you are InterSystems Product Manager, or DC moderator, or Global Master from Specialist level and above cast your vote in the Expert nomination. Community Nomination If you ever contributed to DC (posts or replies) and this was not considered as spam you are able to vote for the applications in the Community nomination. Voting Voting takes place on the Open Exchange Contest Page and you need to sign in to Open Exchange - you can do it with your DC account credentials. If you changed your mind, cancel the choice and give your vote to another application - you have 7 days to choose! Contest participants are allowed to fix the bugs and make improvements to their applications during the voting week, so don't miss and subscribe to application releases! ➡️ Also, please check out the Judgment and Voting Rules for the Contest here. So, developers! Give the vote to the best solution on InterSystems IRIS! You decide! Ok! After the first day of the voting we have: Expert Nomination, Top 3 MongoDB to IRIS migration – 6 ObjectScript Kernel – 6 WebSocket Client JS with IRIS Native API as Docker Micro Server – 2 ______________ The leaderboard. Community Nomination, Top 3 WebSocket Client JS with IRIS Native API as Docker Micro Server – 10 iris-python-suite – 6 MongoDB to IRIS migration – 2 ______________ The leaderboard. Developers! Support the applications you like! Participants! Improve and promote your solutions! Hey Developers, Here are the results after 2 days of voting: Expert Nomination, Top 3 WebSocket Client JS with IRIS Native API as Docker Micro Server – 8 MongoDB to IRIS migration – 7 ObjectScript Kernel – 7 ➡️ The leaderboard. Community Nomination, Top 3 WebSocket Client JS with IRIS Native API as Docker Micro Server – 10 iris-python-suite – 8 Perfomance comparison of IRIS Native API and EAV-approach – 3 ➡️ The leaderboard. So, the voting continues! Full speed ahead! Voting for the IRIS Programming Contest goes ahead! And here're the results at the moment: Expert Nomination, Top 3 WebSocket Client JS with IRIS Native API as Docker Micro Server – 14 ObjectScript Kernel – 13 iris-python-suite – 5 IRIS import manager – 5 ➡️ The leaderboard. Community Nomination, Top 3 WebSocket Client JS with IRIS Native API as Docker Micro Server – 13 iris-python-suite – 9 ObjectScript Kernel – 3 OData Server for IRIS – 3 ➡️ The leaderboard. Hi guys! I just want to share with you a few details, that we have this whole week for voting and to let you fix bugs and improve the app, to describe (in articles) and show(in videos) how your application works and why is it cool! And so you do! And if you see sometimes that the number of your votes decreased that means that somebody from votes changed his mind in favor of another participant. Probably because your colleague just has posted an exciting article or submitted the video! To all participants! Thank you very much for your outstanding contributions! The only thing I regret that I can vote only once! Hey Developers! Last call! Please check out the Contest Board and vote for the applications you like! 👍🏼

Hi Developers, I'm pleased to announce that in May InterSystems Spanish Developer Community celebrates its 1st Anniversary! 🎉 Our Spanish Community is growing: 300+ articles have been published this year and about 900 web users visit the site every month! Together we did a lot this year, and a lot more is planned for the next years! Thank you for using it, thanks for making it useful, thanks for your knowledge, experience, and your passion! And let us warmly welcome our Spanish colleagues who make the Spanish site better every day. Many thanks to @David.Reche, @Esther.Sanchez, @Francisco.López1549 and @Nancy.Martinez! 👏🏼👏🏼👏🏼 Happy Birthday, Spanish Developer Community! Want something in Spanish? Don't miss these posts: ¡Cumplimos 1 año! — prizes are waiting for you! Lo más visto en la Comunidad en su primer año Yes! The Spanish community is celebrating its first anniversary. Everybody is celebrating it at office !!! Thank you @Anastasia.Dyubaylo !! We are preparing a great concert to celebrate it with world famous guests, such as Beyonce, Jenifer Lopez, Maluma, Elton John, Paul McCartney, Rosalia, and some other surprises ...We are waiting for the pandemic to allow us to do so, or we are going to have to suspend it. hehehe, just kidding ... we will have a couple of beers for what we have done and for what we are going to do. Thanks @Anastasia.Dyubaylo Thanks for your help during this year, @Anastasia.Dyubaylo and @Evgeny.Shvarov! And thanks to all of the authors and members that make the DC in Spanish possible! Guys, You're awesome as always! 😄 Miss you all and hope to see you soon! @David.Reche @Francisco.López1549 @Nancy.Martinez @Esther.Sanchez Felicidades @David.Reche , @Francisco.López1549, @Nancy.Martinez, @Esther.Sanchez! Spanish Community is growing and I think I need to study Spanish already now ) Congrats Everybody !!

Hi Community, The new video from Global Summit 2019 is already on InterSystems Developers YouTube: ⏯ Automated InterSystems IRIS Cloud Scaling Auto-scaling, the ability to automatically adjust resources to match load requirements, is a major benefit of cloud technology. In this video, we will show approaches to automatic scaling in the cloud using ECP and data sharding. Examples will include using the auto-scale features of AWS, GCP, and Azure. Takeaway: InterSystems IRIS provides several ways to take advantage of auto-scaling. Presenter: @Kenneth.Takemura, Performance Specialist, InterSystems Additional materials to this video you can find in this InterSystems Online Learning Course. If you would like to explore a wider range of topics related to this presentation, please use the Resource Guides below: Performance and Scalability Resource Guide - 2019 System Architecture (Running Fast and Safe) Resource Guide - 2019 Cloud Deployment Resource Guide - 2019 Enjoy watching this video! 👍🏼

Preview releases are now available for the first version (v1.0) of InterSystems System Alerting and Monitoring (InterSystems SAM for short). InterSystems SAM v1.0 provides a modern monitoring solution for InterSystems IRIS-based products. It allows high-level views of clusters and single-node drilled down metrics-visualization together with alerts notifications. This first version provides visualization for more than one hundred InterSystems IRIS kernel metrics, and users can extend the default-supplied Grafana template to their liking. V1.0 is meant to be a simple and intuitive baseline. Please help us make it great by trying it and sending us feedback! SAM can display information from InterSystems-based instance starting with version 2019.4 SAM is only available in container format. You will need the SAM Manager container plus a small set of additional open-source components (Prometheus and Grafana) that are added automatically by the composition file. SAM components and the SAM Manager Community Edition are available from The WRC Preview page: as “SAM Components” and “SAM Manager” Externally at the SAM components Github repo & the SAM Manager on Docker Hub if you want to download it before the docker-compose runs (this last link might not be available for few hours but the container is pullable) If you are traveling or prefer a voice-based Q&A description on what SAM is, here is a podcast we have prepared for you: SAM documentation can be found here. im having an issue generating a new cluster; any tips? Hi Max, Did you untar the tarball with the "p" flag as well? It is there to preserve the correct privileges. I think that might be your issue. see $ tar zpxvf sam-<version>.tar.gz Let me know

Hi Developers! We are having a series of InterSystems IRIS Online Programming contests this year! This announcement is for current and all future online contests. Below you'll find the judgment rules for the IRIS Contest. Judgment and Votes 1. Experts Nomination - winners will be determined by a limited jury. Judges for this nomination are InterSystems Product Managers, Developer Community Moderators, and Global Masters advocates with VIP, Ambassador, Expert and Specialist levels. One judge can vote only for one application. The power of the vote is as follows: PM vote - 3 points Moderator vote - 3 points VIP GM Advocate vote - 3 points Ambassador GM Advocate vote - 3 point Expert GM Advocate vote - 2 point Specialist GM Advocate vote - 1 point 2. Community Nomination - an application that will receive the most votes in total. The judges here are any registered community members who posted at least once. These judges will have 1 vote point. Note: Judges can participate in a contest, but cannot vote for their own applications. Judgment criteria In the Experts Nomination, we will choose the best application which: Idea and value - the app makes the world a better place or makes the life of a developer better at least; Functionality and usability - how well and how much the application/library does; The beauty of code - the application has a readable and effective code. Stay tuned!

Hi Developers! The InterSystems IRIS Native API Contest is over. Thank you all for participating in our IRIS Competition! As a result – 8 great apps! And now it's time to announce the winners! A storm of applause goes to these developers and their applications: 🏆 Experts Nomination - winners were determined by a specially selected jury: 🥇 1st place and $2,000 go to the iris-python-suite project by @Renato.Banzai 🥈 2nd place and $1,000 go to the WebSocket Client JS with IRIS Native API as Docker Micro Server project by @Robert.Cemper1003 🥉 3rd place and $500 go to the ObjectScript Kernel project by @Nikita.Mullin 🏆 Community Nomination - an application that received the most votes in total: 🥇 1st place and $1,000 go to the WebSocket Client JS with IRIS Native API as Docker Micro Server project by @Robert.Cemper1003 🥈 2nd place and $500 go to the iris-python-suite project by @Renato.Banzai Congratulations to all the participants! Thank you for your attention to the contest and the efforts you pay in this exciting coding competition! And what's next? A whole series of programming contests awaits InterSystems Developers! Join the next IRIS Contest already in this month! ➡️ More details in this post. Congratulations to the winners.... great job I'd like to say a big Thank You ! to all participants that gave me their vote. And I forgive the unknow experts that voted for me in the beginning and changed their mind shortly before closing as by the rules. Congratulations to all winners. Thank you all so much for organizing the contest. Thanks all competitors. It was a very exciting experience. Hi guys, We're pleased to invite you to the Online Meetup with the Winners of the InterSystems IRIS Native API Programming Contest on Friday, June 12 at 11:00 EDT! What awaits you at this virtual Meetup? Please find all the details in this post. Join us! 😉

Hi developers! We are starting InterSystems AI Programming Contest next week, and according to the rules, you can include some technology IRIS Features into your solutions, which will give you extra points in the voting. Here are the technology bonuses for InterSystems AI Programming Contest! 1. IntegratedML usage - 2 expert vote points IntegratedML is a new technology Introduced in InterSystems IRIS which you can use with InterSystems IRIS 2020.2 Advanced Analytics Preview release. IntegratedML: Gives users the ability to create, train, and deploy powerful models from simple SQL syntax without requiring data scientists. Wraps "best of breed" open source and proprietary "AutoML" frameworks including DataRobot. Focuses on easy deployment to IRIS, so you can easily add machine learning to your applications. Learn more in IntegratedML Resource Guide. You can use with IntegratedML template. 2. Python Gateway usage - 1 expert vote point Python Gateway is an addon to InterSystems IRIS which gives you the way to use Python in InterSystems IRIS environment: Execute arbitrary Python code. Seamlessly transfer data from InterSystems IRIS into Python. Build intelligent Interoperability business processes with Python Interoperability Adapter. Save, examine, modify and restore Python context from InterSystems IRIS. Learn more about Python Gateway. You can use the Python Gateway template, which includes IntegratedML too. 3. Docker container - 1 expert vote point The application gets a 'Docker container' bonus if it uses InterSystems IRIS running in a docker container. Both templates, IntegratedML template and Python Gateway template use docker so you can collect this bonus if you build your solution using these templates. Or you can use any other Docker-based templates, published on Open Exchange. Feel free to ask any questions about using the listed technologies. Good luck in the competition!

Hi Community!We're pleased to welcome @Sean.Connelly as our new Moderator in Developer Community Team! Let's greet Sean with big applause and take a closer look at his bio!Sean about his experience:— I help healthcare organisations solve complex integration problems using products such as Ensemble, Healthshare and Mirth.With 20 years of experience Sean has worked with over 20 NHS Trusts, Scottish Boards, NHS Digital, NHS Scotland and Primary Care system providers. This has included many large scale integration solutions such as replacing or implementing brand new Integration Engines, PAS replacements, OrderComms, and Electronic Document handling.Some words from Sean:— I'm also an InterSystems product specialist with deep knowledge of Cache, Ensemble, Healthshare and IRIS. I'm a moderator and active contributor on the InterSystems official community site where you can find many examples of my technical writing. I also actively write open source frameworks and tools for these products and regularly use them to accelerate development services. [CHECK OUT SEAN'S DC PROFILE]— I also specialize in web application development, I've written dozens of SPA applications over the years including large scale solutions for single record patient portals, document management, read code submissions, a dental claim system across Scotland and the modernization of a Trusts legacy green screen PAS system.Some facts about Sean's business:— I currently run my own successful consultancy business called MemCog Ltd which has been going for over 5 years. Some of my customers include the Manchester University Trust where I have helped implement large scale OrderComms solutions, merged Hospitals and Systems, as well as developing an electronic document solution that has delivered millions of electronic letters between the Trust and GP Practices every year. Welcome aboard and thanks for your great contribution, Sean!

ProblemI'm working on exporting data from an Intersystems Cache database through the Cache ODBC Driver. There is a particular table that is giving me an error message. The ODBC Driver crashes and reports an error from the Cache system. I think I was able to trace down where the error is coming from, but I do not know how to debug or fix the error.The table I am trying to extract is called SEDMIHP.Here's the Error: [Cache Error: <<UNDEFINED>%0AmBd16^%sqlcq.PRD.3284 ^SEDMIHP(4,77)>] [Location: <ServerLoop - Query Fetch>] Research/Trial & Error I was able to open up Cache Management Studio and find the class that matched up with the table name. I should mention that this is my very first time working with Intersystems Cache, so I apologize if I'm sounding dumb or inexperienced here. Within the SQLMap, I found this code: <Data name="DESCRIP_2"> <RetrievalCode> S {DESCRIP_2}=$P($G(^PHPROP({L1},"DESC_CODES")),"\",2) S {DESCRIP_2}=$S($L({DESCRIP_2}):^SEDMIHP($P({DESCRIP_2},","),$P({DESCRIP_2},",",2)),1:{DESCRIP_2}) S {DESCRIP_2}=$E({DESCRIP_2},1,80) </RetrievalCode> </Data> I'm thinking that the code in here is causing an issue. With my very limited understanding of ObjectScript, I think this code is manipulating the text/string, and maybe if there's an undefined or bad value in the data, its causing those functions to throw an error? I have limited access to the Cache Management Portal, and I am able to find the table in the SQL Schema and run a query on it. About 300 rows of data are loaded before the same Error as above shows up, and it stops loading any more rows. This is why I'm thinking there is bad data. I tried using ISNULL() and IFNULL() in the SELECT statement to try and skip any bad data, but had the same error in the same spot every time. Questions Is there an easy solution from the SQL side that can avoid this error?Is there anything I can do with the class code in Studio to debug or get more info about this error? Any and all help is greatly appreciated! Additional Info Cache Version: Cache for OpenVMS/IA64 V8.4 (Itanium) 2012.1.5 (Build 956 + Adhoc 12486) 17-APR-2013 19:49:58.07 Dmitry, Thank you so much! That worked perfectly and solved the issue! I've been coming up empty handed for hours trying to figure out this issue. I really appreciate your help! If you can edit this code, you can try change to this. <Data name="DESCRIP_2"> <RetrievalCode> S {DESCRIP_2}=$P($G(^PHPROP({L1},"DESC_CODES")),"\",2) S {DESCRIP_2}=$S($L({DESCRIP_2}):$Get(^SEDMIHP($P({DESCRIP_2},","),$P({DESCRIP_2},",",2))),1:{DESCRIP_2}) S {DESCRIP_2}=$E({DESCRIP_2},1,80) </RetrievalCode> </Data> But not sure, if this correct. What I did there, is, wrapped retrieving data from global ^SEDMIHP with the function $Get() Or this way, with the default value <Data name="DESCRIP_2"> <RetrievalCode> S {DESCRIP_2}=$P($G(^PHPROP({L1},"DESC_CODES")),"\",2) S {DESCRIP_2}=$S($L({DESCRIP_2}):$Get(^SEDMIHP($P({DESCRIP_2},","),$P({DESCRIP_2},",",2)),{DESCRIP_2}),1:{DESCRIP_2}) S {DESCRIP_2}=$E({DESCRIP_2},1,80) </RetrievalCode> </Data>

Hi Community!New video is already on InterSystems Developers YouTube Channel:InterSystems Platforms and FHIR STU3This video provides an overview of our FHIR STU3 support, with a demonstration to showcase key features, including data transformation APIs.Takeaway: InterSystems enables me to use the FHIR STU3 standard.Presenter: @Craig.Lee, @Marc.Mundt Additional materials to the video you can find in this InterSystems Online Learning Course.Enjoy watching the video!

Hi Everyone! You're very welcome to watch the new video on InterSystems Developers YouTube, recorded by @Sourabh.Sethi6829 in a new format called "Coding Talks": Locking in InterSystems ObjectScript In this video, we all are going to do a deep dive into a very common yet complex topic: locks in InterSystems ObjectScript.In this video, we will start from the very basics to the most complex and interesting aspects of locks and data integrity. Recommended Audience: All developers who are aware of MUMPS or Caché Objects. Codeset you can find here. For any questions, please write to @Sourabh.Sethi6829 at sethisourabh.hit@gmail.com. Enjoy watching this video! Thank you for another interesting video. However, if the sound quality was better, it would make the viewing much more enjoyable. Simply use lavalier microphone and adjust the compression for much better results. Hi Pasi,Thanks for your feedback! We will take into account your preferences. @Sourabh.Sethi6829, very helpful video and good work!But sharing the code in Google Docs? Could you please share it on Github and in ObjectScript? E.g. like in this project?

Hi Community!You're very welcome to watch a new video on InterSystems Developers YouTube, recorded by @Benjamin.DeBoe, InterSystems Product Manager:Natural Language Processing with InterSystems IRIS This video provides a quick overview of what kinds of problems InterSystems IRIS’ NLP capabilities can solve. The technology is available in the Community Edition, so no reason not to spend the first five minutes of your lunch break watching the video, and the remaining time on kicking the tires!And...Additional materials to the video you can find on the InterSystems Video Portal.Enjoy and stay tuned! @Benjamin.DeBoe !Transferring a question from YouTube where IRIS NLP could be found in IRIS Community Edition? Could you please help? IRIS NLP, previously known as iKnow, is an embedded technology, meaning it's there in the form of APIs. These articles on building a domain and using the knowledge portal should be a helpful start, as is this series of step-by-step videos (which are a little older I'll admit; start with the "fundamentals" one) and of course other articles on the developer community tagged for iKnow.