Search

Hi folks! How do you edit data in IRIS or Caché? What do you use? Change globals directly via Management Portal? Change data using SQL? Use your favorite dev tool? Which one? Crafted your own? Share your experience, please? Hi, we are updating the data using an update query via the management portal. Globals need to change then we are using the terminal to change it. Recently, started to Visual studio code extension of SQL Tools. but frequently check and update the above would not work out. each time change query parameters. so we created a zen page to do the CRUD operations to the particular table. I see, thank you @Karunanithi.Veerarajan I don't have a real favorite. - for similar changes in multiple records, I use SQL in SMP, rarely also $system.SQL.Shell() from terminal- for single changes, I use Global Edit in SMP and direct access in terminal equally- for special objects I often write my class related customized edit method I believe the best answer is: It depends.Depends on the data architecture of the original project, whether the data structure is GLOBAL, relative SQL or Objects. For example, in my current project, I have data in objects originating from Ensemble and metrics and monitoring data in relational tables. The native part of Ensemble is never subject to change, but the part concerning relational tables sometimes needs editing. When it happens I prefer to use third party SQL manager like DBeaver. In another project, fully specified in Globals, the preferred way of editing large amounts of data was to write scripts in ObjectScript. Edit globals directly, only in very specific situations. And keep in mind that, if the global is referring to an SQL table, there is always the risk of corrupting an index. Hi. The team I work in has been supporting old MUMPS and then Cache systems for many years, and have two rules for fixing data on live systems: 1. Never write a kill statement directly at the command line.It's quick and convenient, but we've seen many occasions where big chunks of, or, before the database parameter to stop it, whole globals were removed by accident. Cue major panics, hours of restore and de-journal. etc. 2. Don't write SQL updates directly (SMP, command line, etc). Because if you get the WHERE wrong then all rows in a table suddenly vanish or have the same value. :-) So we use a local command line tool for global amendments that uses the old %G style selection search to display one node at a time, so that you can then edit the data, or kill (with a warning first if there are sub nodes you may have forgotten about). We also have a local command line tool for SQL/objects. This takes in a table name and WHERE clause, and only allows editing and deleting when the query finds only one row. Anything more than a few nodes/rows and we usually write a proper bit of script on our dev server, and get it checked and tested before running in live. Better safe than sorry. What a thrilling and scary story, Mike! I need this editing feature for development purposes only. Thanks Marcio, I agree Why such a complicated question, I wonder. Can anyone answer immediately the "Best Tool" for any given job (other than a salesman, of course)? I'm a fan of writing my own SQL commands on the SQL Browser (it gives me a sense of power that comes from using the raw tools some deity provided for me) but hey, if it's as simple as editing a bunch of records, well my choice is Dbeaver Community Edition (through JDBC) but it's not the only one based on java (that's why JDBC driver is needed). The one I downloaded came with its own OpenJDK (but it's not full java as some .dll, .dylib or .so libraries are included). It seems you can even install it as some Eclipse plugin if you want! I haven't tested this one yet though. Well it's simple and you can use the jar that's in the <instance-dir>/dev/java/lib/JDK11/intersystems-jdbc-<version>.jar. It offers to download one as you establish your first connection to an "InterSystems IRIS" or "Cache" database, check this Dbeaver officially supports .... It has a nice "view data" for a table and allows to edit in a grid (you have to "save" in order to trigger all the UPDATE commands necessary or see them prior to submitting/saving). It's filterable so you see just a range of data you want to edit as in "ID between 40 and 50". If you have some primary key (other than the ID column which is hidden to the beaver but you still can use it to filter data) then the updates will use it no questions asked, otherwise you can use all the columns for the updates but you know how that can have unwanted repercussions. It also has the usual import and export (using csv files with mapped columns, just don't use any identity columns!) and the community edition is supposed to be under an apache license. If you really like of course you can buy some license that gives you a full load of functionalities but if it's just to edit some records, I'd stick to the community edition. Thanks, Robert! For those who are not aware - SMP stands for System Management Portal - the web UI to manage IRIS. Thanks, Robert! For those who are not aware - SMP stands for System Management Portal - the web UI to manage IRIS. Thanks, Pablo! Yes, I like DBeaver too. RESTForms, duh.

Hi All, We have a requirement for one webpage that should be access in our VPN with out authentication. If it asks user name password that also fine. This page should be a dashboard for the ensemble health monitoring. Support Team seating Area we have big SMART Monitor which always shows this webpage. Support engineers keep on eye on this monitor, if it shows action required then . they will act upon immediately. Expecting some widgets like Queue Status Inbound application status Out bound operations status Database statistics Mirror Information etc. I can see some widgets in management portal. But We need separate web application page. I am developing one solution for my support team requirements. Here I am going to Propose Solution. Ensemble Integration: Create Customized Business Service to poll Cache to get the required details and send to Business Process Create Customised Business Process to check the configured business rules and invoke Business Operation. Create a Business Operation to make a POST call for to my Rest Service. Rest Service: This Service Parse JSON Payload and insert or update into respective table in MYSQL database instance React Web Page: This UI will show the DB summary in respective widgets Please advice me any alternative Idea? Is there any tolls available for this? Thanks, Prashanth It's better to look at something like Grafana. Here are a few articles about using it. Big article with many details and my article with direct connection to IRIS If you need some help with the development and configuration of such monitoring, I can help with it. Another solution can be with SAM : https://docs.intersystems.com/components/csp/docbook/DocBook.UI.Page.cls?KEY=ASAM https://community.intersystems.com/post/new-video-viewing-customizing-metrics-sam You can also enable interoperability metrics (only on IRIS 2021.1+) with : // Enable Intero metrics for SAM zw ##class(Ens.Util.Statistics).EnableSAMForNamespace() zw ##class(Ens.Util.Statistics).EnableSAMIncludeHostLabel()

Hi, I have VSCode on my Windows 10 notebook with intersystems-community.objectscript-pack installed. I'm successfully connected to remote IRIS (2021.1). I can export classes, change them, save and import back to IRIS. But every time VSCode starts, the message "Request initialize failed with message: Dynamic Linking Error: Win32 error 126" is displayed and InterSystems Language Server does not start. Has anyone solved this problem yet? Windows 32bit, is not it? Only 64 bit is supported. Are you using 32-bit Windows? If so, see https://github.com/intersystems/language-server/issues/197 I think same issue as https://githubmemory.com/repo/intersystems/language-server/issues/186?page=2 . @pvdmm Thanks for the log, I think that your problem is due to a couple of missing DLLs: msvcp120.dll and msvcr120.dll These can be installed using the Visual C++ 2013 redistributable package available from https://support.microsoft.com/en-us/topic/update-for-visual-c-2013-redistributable-package-d8ccd6a5-4e26-c290-517b-8da6cfdf4f10 This is a link to an page talking about a bugfix update but it is the latest version (5) of these tools, linked from a Microsoft page titled "The latest supported Visual C++ downloads". Please install this and then try running VSCode again. If this fixes your problem the Language Server team can work out the best way to fix this issue for future installations of the extension. Thank you @Ohata.Yuji You seem to be right. In the meantime, I managed to start Language Server as follows:VScode runs smoothly on my second computer, so I looked for differences. I have Caché installed on the second computer, Iris on the troubled one. The problem disappeared when I installed Caché on the troubled one. It is Windows 64 bit. But the problem is solved now.

In 2017, Forbes published an article talking about API Economy (see: https://www.forbes.com/sites/louiscolumbus/2017/01/29/2017-is-quickly-becoming-the-year-of-the-api-economy/). This article was the trigger to popularize the use of API and API Management by large companies. The article published a maturity model. My understanding is that Intersystems IRIS allows you to reach the top of the pyramid with your current technologies. See the figure above.For this it is important to combine % CSP.REST package, IRIS API Manager (IAM), ML Pack and IntegratedML, Native API for Python, BPL and interoperability adapters.

Hey Developers, Are you ready to participate in the annual December competition? Join the Advent of Code 2020 with InterSystems and participate in our ObjectScript contest to win some $$$ prizes! 🏆 Our Leaderboard 🏆 Here you can find our last year's participants. 👉🏼 Join the ObjectScript private leaderboard with 130669-ab1f69bf code. Note: You need to sign in to Advent of code (e.g. with GitHub / Google / Twitter / Reddit account) to see the leaderboard and participate in the contest. Prizes: 🥇 1st place - $3,000 🥈 2nd place - $2,000 🥉 3rd place - $1,000 All winners will also get a special high-level Global Master badge. Note: InterSystems employees are not eligible for money prizes. Win Conditions: To win our prize you should be on the top of the ObjectScript Leaderboard and upload all the solutions in a public repository on GitHub and present the code in InterSystems ObjectScript in UDL form as presented in the template below. ⬇️ The Advent of Code 2020 contest ObjectScript template So! The first puzzles will unlock on December 1st at midnight EST (UTC-5). See you then and good luck to all of you! Also join the discord channel to discuss terms, rules, everything. As we discussed and decided in discord it's OK to keep the repo private until the end of the contest. At the moment the following members are in the top 20 🔥 top 20 🔥 participants according to today's results: Hey Devs! Let's see the top 20 participants 🤩 Our 🔥 top 20! Today's best 20 🔥 Top 20)) Brilliant 20 participants 🤩 Please enjoy the best 20 participants! Only 4 days left till the end of the competition 💪 Let’s see the results! Devs! Please enjoy the results of the best 20🤩 Only 2 days left! Best 20 participants at the moment 🤩 Another way to look at results -- by medal count. Border is part 1 (doesn't count), background is part 2. https://bitbucket.org/bertsarens/aoc2020/src/master/ https://github.com/uvg/AdventOfCode/tree/master/2020/COS OK. The first time I followed to the end. The code I was forced to produce by time pressure is so ugly and dirty that I refuse to publish it.Nevertheless a clear demonstration for what was ISOS (aka COS) NOT designed for:Higher mathematical calculus, matrix transformations, arrays with independent dimensions, ....[ Though I have to admit that I encountered tensors, rotors, matrix transformations, Mr. Fermat's theories, ... only at university 50+ years ago. And I didn't miss it in between ] There was no demand for the real strengths of IRIS!In addition, I verified my personal credo that writing some code in ISOS/COSonly because it is possible makes no sense and is of no commercial value.Especially with the broad range of options in IRIS to include external code.

The ObjectScript language of InterSystems IRIS has a very powerful metadata engine called XData. This feature allows the creation of metadata definitions for your classes, to be used by the compiler or by programs that will extend the standard features of the language, based on the XData definitions of its scope. An example is IRIS Publisher, an Open Source application from the community capable of collecting all XData definitions in HTML and / or Markdown format and generating a Web Portal with all the application documentation assembled from these XData elements. See the whole process here: Let's see a practical example, follow the steps: Access the link https://openexchange.intersystems.com/package/IRIS-Publisher to download IRIS Publisher. Clone the project repository in git in a local folder of your choice: git clone https://github.com/yurimarx/iris-publisher Open the project's source code. It is in the iris-publisher folder. We will create some XData elements. Go to the Person class inside src / dc / Sample. Inspect the two example XData definitions between lines 34 to 43. /// Documentation for Person in HTML XData PersonDocHtml [ MimeType = text/html ] { <h1>This is the Person class</h1> } /// Documentation for Person in Markdown XData PersonDocMarkdown [ MimeType = text/markdown ] { <h1>This is the Person class in MD</h1> } There are 3 large blocks, the text after ///, where it is possible to write a description of the XData element; the very definition of XData and MimeType (only HTML and Markdown are captured) and finally, between {}, all the HTML or Markdown content that will compose your documentation. In this example we use both, but we recommend defining only 1 of them. It is possible to annotate all classes of the project, or part of them with XData, creating a very complete documentation of your application. After documenting your classes using XData, we will compile the project documentation, in the terminal, execute: docker-compose up -d --build After execution, your instance will be live and you will be able to run the IRIS Publisher API. Run http://localhost:52773/swagger-ui/index.html?Url=http://localhost:52773/api/mgmnt/v1/USER/spec/crud#/default/UpdateDocConfig to define title, developer information and describe your application, use the following content as an example: { "SiteName":"Publisher", "Summary":"Documentation of the Publisher", "Description":"This an Application to generate documentation from XDATA", "DeveloperName":"Yuri Gomes", "DeveloperEmail": "yurimarx@gmail.com", "DeveloperWebsite": "ymservices.tech" } Run http://localhost:52773/swagger-ui/index.html?url=http://localhost:52773/api/mgmnt/v1/USER/spec/crud#/default/InitiatePublisher to generate the documentation and start Documentation portal for your application. Go to http: // localhost: 8000 and see all the documentation online! If you enjoyed, vote in my app: https://openexchange.intersystems.com/contest/current

Hey Developers, This week is a voting week for the InterSystems Developer Tools programming contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS. 🔥 You decide: VOTING IS HERE 🔥 How to vote and what's new? All InterSystems employees can vote in both Expert and Community nominations. Any developer can vote for their application – votes will be counted in both Expert and Community nominations automatically (in accordance with the Global Masters level). DC Members: You can select 3 projects: the 1st, the 2nd, and the 3rd place upon your decision. This is how it works for the Community leaderboard: Community Leaderboard: Conditions Place 1st 2nd 3rd If you have an article posted on DC and an app uploaded to Open Exchange (OEX) 9 6 3 If you have at least 1 article posted on DC or 1 app uploaded to OEX 6 4 2 If you make any valid contribution to DC (posted a comment/question, etc.) 3 2 1 For the Experts leaderboard, different levels of experts have more "points" power: Experts Leaderboard: Level Place 1st 2nd 3rd VIP Global Masters level or ISC Product Managers 15 10 5 Ambassador GM level 12 8 4 Expert GM level or DC Moderators 9 6 3 Specialist GM level 6 4 2 Advocate GM level or ISC Employees 3 2 1 For those who have any of the above expert levels, votes will be counted in both Expert and Community nominations automatically. This is how it works: To take part in the voting, you need: Sign in to Open Exchange – DC credentials will work. Make any valid contribution to the Developer Community – answer or ask questions, write an article, contribute applications on Open Exchange – and you'll be able to vote. Check this post on the options to make helpful contributions to the Developer Community. 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 full voting rules for InterSystems online contest here. Hey Developers, After the first day of the voting we have: Expert Nomination, Top 3 Server Manager for VSCode – 69 Config-API – 48 Grafana Plugin for InterSystems – 23 ➡️ The leaderboard. Community Nomination, Top 3 Server Manager for VSCode – 109 Config-API – 82 zpm-explorer – 48 ➡️ The leaderboard. Experts, we are waiting for your votes! 🔥 Participants, improve & promote your solutions! @Iryna_Mologa wrote: Participants, improve & promote your solutions! But in the contest posting I see this (my highlighting): The way I read it, we participants should not be changing our entries during voting week. @Evgeny.Shvarov what do you say? Hi John! Not exactly. For some reason, we don't mention here that we allow editing and improvements during the voting week too. @Anastasia.Dyubaylo, don't you know why? ALL the previous contests had this option and all the contestants used it this week for improvements, bug-fixing, and advertising. @Anastasia.Dyubaylo, could you please add that everyone is able to improve applications during the voting week too? In all contests, developers were able to improve their applications throughout the entire registration and voting period. And from the announcement above: So, we need to fix the main announcement. Thanks, @John.Murray! ;) Here are the results after 2 days of voting: Expert Nomination, Top 3 Server Manager for VSCode – 101 Grafana Plugin for InterSystems – 70 zpm-explorer – 64 ➡️ The leaderboard. Community Nomination, Top 3 Server Manager for VSCode – 163 zpm-explorer – 119 Config-API – 118 ➡️ The leaderboard. So, the voting continues. Please support the application you like! Voting for the InterSystems Developer Tools programming contest goes ahead! And here're the results at the moment: Expert Nomination, Top 3 Server Manager for VSCode – 128 zpm-explorer – 88 Config-API – 87 ➡️ The leaderboard. Community Nomination, Top 3 Server Manager for VSCode – 209 zpm-explorer – 160 Config-API – 152 ➡️ The leaderboard. Please check out today's voting results: Expert Nomination, Top 3 Server Manager for VSCode – 152 zpm-explorer – 101 Grafana Plugin for InterSystems – 89 ➡️ The leaderboard. Community Nomination, Top 3 Server Manager for VSCode – 241 zpm-explorer – 181 Grafana Plugin for InterSystems – 157 ➡️ The leaderboard. Keep voting!Our participants need your support! Developers! Only 1 day left before the end of voting. Please check out the Contest Board and vote for the solutions you like! 👍🏼

Hi Community! We're pleased to invite you to the Online meetup with the winners of the InterSystems Full Stack contest! Date & Time: Friday, October 16, 2020 – 11:00 EDT What awaits you at this virtual Meetup? Our winners' bios. Short demos on their applications. An open discussion about technologies being used, bonuses, questions. Plans for the next contests. Our speakers: @Henrique, System Management Specialist / Database Administrator, Sao Paulo Federal Court @Dmitry.Maslennikov, Co-founder, CTO and Developer Advocate, CaretDev Corp @MikhailenkoSergey, Chief Specialist, JSC Mosvodokanal @Vasiliy.Bondar, Chief technical officer, Yagoda LLC @Evgeny.Shvarov, InterSystems Developer Ecosystem Manager You will also have the opportunity to ask any questions to our developers in a special webinar chat. We will be happy to talk to you at our Virtual Meetup! ➡️ JOIN US ON THE ONLINE MEETUP! TOMORROW! Don't miss our virtual meetup! 😉 Register here ➡️ Please join today's meetup using this link. See you! Hey Developers! The recording of this virtual Meetup is available on InterSystems Developers YouTube: ⏯ Online Meetup with the Winners of the InterSystems Full Stack Programming Contest Big applause to all the speakers! 👏🏼 And thanks to everyone for joining our online Meetup!

I can't find a case of spark or Kafka connecting to InterSystems Iris on the Internet. Are there any related resources can share? InterSystems provides a specialized Spark connector. Documentation. And, of course, you can use a JDBC driver. As for Kafka here's some examples showing InterSystems IRIS<>Kafka interoperability: PEX Demo Kafka demo

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 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! 👏🏼

Hey Developers! This week is a voting week for the InterSystems IRIS for Health FHIR Contest! So, it's time to give your vote to the best FHIR solutions built with InterSystems IRIS for Health. 🔥 You decide: VOTING IS HERE 🔥 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. Hey Developers, After first day of the voting we have: Community Nomination, Top 3 iris-fhir-portal – 8 iris4health-fhir-analytics – 2 fhir-chatbot – 1 ➡️ The leaderboard. Experts, we are waiting for your votes!🔥 Participants! Improve and promote your solutions! Full speed ahead! 🚀 Ok! Here are the results after 2 days of voting: Expert Nomination, Top 3 iris-fhir-portal – 10 fhir-chatbot – 5 iris4health-fhir-analytics – 4 ➡️ The leaderboard. Community Nomination, Top 3 iris-fhir-portal – 10 iris4health-fhir-analytics – 5 fhir-chatbot – 2 ➡️ The leaderboard. So, the voting continues. Please support the application you like with your vote! Voting for the for the FHIR Contest goes ahead! And here're the results at the moment: Expert Nomination, Top 3 iris4health-fhir-analytics – 14 iris-fhir-portal – 13 fhir-chatbot – 6 ➡️ The leaderboard. Community Nomination, Top 3 iris-fhir-portal – 12 iris4health-fhir-analytics – 6 fhir-chatbot – 2 ➡️ The leaderboard. Hey Developers! 3 days left before the end of voting! Please check out the Contest Board and vote for the applications you like! 👍🏼 Please check out today's voting results: Expert Nomination, Top 3 iris4health-fhir-analytics – 22 iris-fhir-portal – 22 fhir-chatbot – 6 ➡️ The leaderboard. Community Nomination, Top 3 ​​​​​​​iris-fhir-portal – 16 iris4health-fhir-analytics– 5 fhir-chatbot – 4 ➡️ The leaderboard. Keep voting!Our participants need your support! Hey Developers! Last call! Please check out the Contest Board and vote for the applications you like! 👍🏼

Hi Community! We're pleased to invite you to the Online meetup with the winners of the InterSystems FHIR programming contest! Date & Time: Friday, September 4, 2020 – 11:00 EDT What awaits you at this virtual Meetup? Our winners' bios. Short demos on their applications. A short interview with all the winners about the past contest. Plans for the next contests. Our speakers: @Henrique, System Management Specialist / Database Administrator for the Sao Paulo Federal Court @José.Pereira, Business Intelligence Developer at Shift Consultoria e Sistemas Ltda @Renato.Banzai, Machine Learning Engineer Coordinator at Itaú Unibanco @Evgeny.Shvarov, InterSystems Developer Ecosystem Manager @Patrick.Jamieson3621, InterSystems Product Manager - Health Informatics Platform @Craig.Lee, InterSystems Product Specialist You will also have the opportunity to ask any questions to our developers in a special webinar chat. We will be happy to talk to you at our Virtual Meetup! ➡️ JOIN US ON THE ONLINE MEETUP! Tomorrow! Don't miss our virtual meetup! 😉 Developers! We'll start in a couple of hours. You can still register here! Hey Developers! The recording of this virtual Meetup is available on InterSystems Developers YouTube: ⏯ Online Meetup with the Winners of the InterSystems FHIR Programming Contest Big applause to all the speakers! 👏🏼 And thanks to everyone for joining our online Meetup!

Hi Community, Please welcome the new video from Global Summit 2019 on InterSystems Developers YouTube: ⏯ Scaling Up and Out on InterSystems IRIS In this video, we will discuss the basics of scaling applications based on InterSystems IRIS. We will pay special attention to employing sharding for horizontal scalability, including recent advances to our sharding technology that introduced support for object access to your sharded data. Takeaway: InterSystems continues to expand the types of applications that can scale horizontally. Presenter: Louise Parberry, Senior Sales Engineer, 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 Guide below: ➡️ Performance and Scalability Resource Guide - 2019 Enjoy watching this video! 👍🏼

Hey Developers, See how to use the DTL Generator in InterSystems IRIS to create a data transformation: ⏯ Using the DTL Generator in InterSystems IRIS 👉🏼 Subscribe to InterSystems Developers YouTube. Enjoy and stay tuned! Hi all, I was wondering in which version I can find the DTL Generator, or is it still in development? In version ' IRIS for Windows (x86-64) 2020.1.1 (Build 408U) Sun Mar 21 2021 22:04:53 EDT' I cannot find it. @Stefan.Wittmann maybe you can help answer this question? Hi @Menno.Voerman the DTL Generator is still in development and was presented at the last Virtual Summit to gather some feedback, which we are still incorporating and fine-tuning with some partners. Are you interested in the DTL generator for migrating interfaces to InterSystems IRIS or for other reasons? Hi @Stefan.Wittmann, I was just curious about this functionality. For a project I need to convert ORU~R01 to MDM~T02 messages. For now it's fine to write the DTL by myself (small messages). I would be happy to see this functionality in a further release. It can indeed be very useful with migration projects.