Search

Hi!Sometimes I need to filter the widget on a dashboard from a different cube. And I face the following problem:Widget A refers to a query from Cube A and I want to filter Widget B from Widget B.Widget's B pivot refers to Cube B, and which has different dimensions for the same data.E.g. cube A has the dimension Author and the Cube B has the dimension Member for the same data. So there is no way to filter such a widget B from the widget A.Actually, once we filter a given widget B with another widget A, we add the Filter Expression to the MDX query which looks like member's expression from Cube A, like:[Outlet].[H1].[Region].&[Asia]Is there any way to alter the filter expression for Widget B, just changing the value of the last part (Asia in this case) of the filter expression? One way to do this is by using a pivot variable. Create the same pivot variable "Region" in both pivots on which your widgets are based. These pivot variables should return the members, in your example Asia, Europe, N. America, S. America. You can define the manually or in a termlist, or use a kpi to retrieve them. For the example in the screenshot below I created a HoleFood2 cube with a Outlet2.H1.Region2 level. This level is "incompatible" with an Outlet.H1.Region level in HoleFoods. In my manual Region pivot variable I simply defined two regions, which can be selected manually. Once you have these two pivot variables create a calculated dimension on each pivot using the pivot variable. In your example in HoleFoods the expression should be Outlet.[$variable.Region]. Place the calculated dimension on Filters.This is how I did it in HoleFoods:and this is how I did it in HoleFoods2:Finally, add an ApplyVariable control on one of your widgets with "*" as target. Selecting a region will filter both widgets.

This summer the Database Platforms department here at InterSystems tried out a new approach to our internship program. We hired 10 bright students from some of the top colleges in the US and gave them the autonomy to create their own projects which would show off some of the new features of the InterSystems IRIS Data Platform. The team consisting of Ruchi Asthana, Nathaniel Brennan, and Zhe “Lily” Wang used this opportunity to develop a smart review analysis engine, which they named Lumière. As they explain:A rapid increase in Internet users along with the growing power of online reviews has given birth to fields like opinion mining and sentiment analysis. Today, most people seek positive and negative opinions of a product before making a purchase. Customers find information from reviews extremely useful because they want to know what people are saying about the product they want to buy. Information from reviews is also crucial to marketing teams, who are constantly seeking customer feedback to improve the quality of their products. While it is universal that people want feedback about online products, they are often not willing to read through all the hundreds or even thousands of customer reviews that are available. Therefore our tool extracts the information both vendors and customers need so they can make the best decision without having to read through any reviews.That sounds really great, doesn’t it? Check out the rest of their whitepaper to get more details about what they were able to accomplish and how InterSystems IRIS enabled them to do it!

There are several options how to deliver user interface(UI) for DeepSee BI solutions. The most common approaches are: use native DeepSee Dashboards, get web UI in Zen and deliver it in your web apps. use DeepSee REST API, get and build your own UI widgets and dashboards. The 1st approach is good because of the possibility to build BI dashboards without coding relatively fast, but you are limited with preset widgets library which is expandable but with a lot of development efforts. The 2nd provides you the way to use any comprehensive js framework (D3, Highcharts, etc) to visualize your DeepSee data, but you need to code widgets and dashboards on your own. Today I want to tell you about yet another approach which combines both listed above and provides Angular based web UI for DeepSee Dashboards - DeepSee Web library. What is it? DeepSee Web(DSW) is an Angular.js web app which renders DeepSee Dashboards, available to a user in a given Namespace using Highcharts.js, OpenStreetMap and some self-written js widgets. How it works DSW requests dashboards and widgets metadata available in a namespace using MDX2SJON library. To visualize a dashboard DSW reads the list of widgets and their types and uses js-widget analogs which were implemented for almost every DeepSee widget. It instantiates js widgets listed in a dashboard, requests the data according to widgets’ datasources using DeepSee REST API and MDX2JSON, retrieves the data in JSON format and performs the visualization. Why is it cool? DSW is great because: You can develop DeepSee Dashboards using standard editor and then have a UI on Angular without any line of coding. You can expand the library of widgets easily with any js library or self-written widget. You can introduce smart-tiles on DSW covers. You can display the data on map. What about mobile devices? DSW works pretty well in Mobile browsers (Safari, Chrome), and it has standalone DeepSight iOS app, here are some screenshots: How much it costs? It is free. You are very welcome to download latest release, open issues, make forks and send pull requests with fixes and new features. Is it suitable for production usage? Yes. DSW was started in 2014 and has about 60 releases to the date. Dozens of companies use DSW successfully in their DeepSee solutions. For example, we are using DSW for developer community: But be aware that according to the DSW license (MIT license) you are using it at your own risk. Is it supported? It is supported by the community. You are very welcome to open issues, make forks and send pull requests with fixes and new features. Key contributors are [@Anton.Gnibeda​], [@Nikita.Savchenko] and [@Eduard.Lebedyuk]. How to install? It’s easy. First, install MDX2JSON. Download the latest installer from release, import/compile installer.xml in USER namespace, run USER> D ##class(MDX2JSON.Installer).setup() It will download the latest release from github, create MDX2JSON database and namespace, map it to %All and create the /MDX2JSON web app. To check if everything installed well open localhost:57772/MDX2JSON/Test. If everything is fine it will return something like this: { "DefaultApp":"\/dsw", "Mappings": { "Mapped":["%SYS","MDX2JSON","SAMPLES","USER" ], "Unmapped":["DOCBOOK" ] }, "Parent":"18872dc518d8009bdc105425f541953d2c9d461e", "ParentTS":"2017-05-26 16:20:17.307", "Status":"OK", "User":"", "Version":2.2 }​ Then install DSW. Download the latest release xml. Import/compile it to USER Namespace. Run: USER> Do ##class(DSW.Installer).setup() It will create /dsw app and install all the js files in the /csp/dsw folder. Open localhost:57772/dsw/index.html#!/?ns=SAMPLES to see how it works. Known issues: On some systems you need to set UTF8 support for non-CSP files in CSP Gateway. Run the following in terminal to turn it on: USER> set ^%SYS("CSP","DefaultFileCharset")="utf-8" Any demos? Sure! Online demo for Samples, login=dswdemo, password=dswdemopass! Online demo for Maps, login=dswdemo, password=dswdemopass! When should I install it? Now! ) To be continued, stay tuned! Evgeny,are there any plans to port it to Angular2+ ? e.g. connecting to ngx-charts? Hi, Dan!What are the benefits of using ngx-charts? Better performance? Wider chart library? Also available on OpenExchangeThe new version has independent mobile UI for DeepSee dashboards. Hello, i have some troubles to set up DSW with IIS, do you have some guide? everything works right with port 57772 (apache private server), but i need use port 80 (IIS live server)thanks in advance.Best Hi Jose!it's not the matter of DSW, it's the matter of setup IRIS or Caché with an external web server (which is recommended of course).E.g. check this discussion or the documentation. Thanks for your help Evgeny, now works right!! Looks like demo login not working anymore. Demo login was fixed. Thank you for the feedback!login=dswdemo, password=dswdemopass I have a very important question: Can this extension be used in a productive/ commercial environment? You wrote: But be aware that according to the DSW license (MIT license) you are using it at your own risk. But the extension uses HighchartsJS and this is only free for "Non-commercial". Unfortunately, no statement was made and it may be a dangerous license trap, if my guess is correct. Hi T! Thanks for this, you are right. Highcharts.js changes license terms through time. I haven't found the license agreement actual for highcharts.js 3.0 which is delivered with the current DSW release. I remember it was something like "You pay for the support". The license for the current version highcharts.js 7.2 is the following and could be purchased for commercial usage. Images are broken in this article and Part 2. Which one? Don't see any broken images. Could you please point URLs? All images are not loaded when privacy protection is enabled in Firefox (which is enabled by default). Copy them on community maybe? where is the demo? Hi Gethsemani! It looks like we have shut down this demo server. But you can test it on your laptop easily. Testing with Docker: 0. Install Docker desktop 0.1. Install VSCode and Open it and install Docker and ObjectScript plugins. 1. Download this archive. 2. Unpack and open the folder in VSCode. 3. Right-click on Docker-compose.yml and choose Compose Restart. Wait for docker says in terminal "done". 4. Connect VSCode - click on the "disconnected" status bar and then choose "Refresh Connection". 5. You will see IRIS Terminal. Open ZPM (package manager) and install samples-bi module. Node: 04319ab688f6, Instance: IRIS IRISAPP>zpm zpm: IRISAPP>install samples-bi 6. Then install DeepSee Web zpm: IRISAPP>install dsw 7. Click on VSCode bar again and open Management Portal. It will be another port in your case. Open DSW web-app in IRISAPP namespace with default credentials: Then you will see DSW working in action: HTH Hi Gethesemani! Recently I crafted a small dashboard on DeepSeeWeb and it is available online: You can drill down to China and the USA.

AbstractIn a recent benchmark test of an application based on InterSystems Caché, a sustainable rate of 8.9million database accesses/second, with peaks of 16.9 million database accesses/second, was achieved. These results were from a test performed on a connected system of eight applications servers, using Intel Xeon 5570 processors, and running Linux as the operating system. This benchmark shows that:Caché can achieve unheard of levels of performance for an object database. It provides full persistence of data at speeds that are normally only reached by in-memory databases.Caché demonstrates this high performance while running on inexpensive servers.Caché offers excellent horizontal scalability, with throughput scaling linearly as application servers are added.

Hi, Community!I’m sure you are using Developer Community analytics built with InterSystems Analytics technology DeepSee: You can find DC analytics n InterSystems->Analytics menu.DC Analytics shows interactive dashboards on key figures of DC entities: Posts, Comments, and Members. Since the last week, this analytics project is available for everyone with source code and data on DC Github!It is available for everyone (who is familiar with InterSystems data platform ;) to download and install on Caché/Ensemble/IRIS, load the data and have same analytics locally. And what is more interesting IMHO you can improve the analytics and pull request to the Github!So! What is the data?The schema of persistent classes is very complex and consists of 3 classes: Posts, Comments, and Members. See the diagram built in ClassExplorer, courtesy of @Nikita.Savchenko .Another portion of persistent data is a daily data on views and achievements of members.This data can be imported and is available in Releases section in a form of gz with globals in xml format.InstallationHow to get this on your InterSystems Data Platform instance?You would need IDP instance of 2014.1 and newer.1 Install MDX2JSON (30 sec)2 Install DeepSee Web(DSW) (1 minute)3 Create a new Namespace (name it e.g. DCANALYTICS), enable DeepSee and iKnow.4 Go to Releases and download the latest DCAnalytics_classes*.xml file.Import it into DCANALYTICS namespace e.g. with $System.OBJ.ObjLoad(), Atelier or Class Import UI in Control Panel:5. Start the data import and installation. Call the setup method and provide the path to DCAnalytics_globals.gz file. : DCANALYTICS> do ##class(Community.Utils).setup("DCAnalytics_globals.gz") The setup does the following: 1. Imports globals for persistent classes (without indices) 2. Builds indices 3. Builds cubes 6. Setup tiles for DSW. Download from releases the latest DSW.config.and.iKnow.files.zip, unpack and move file dcanalytics.json from archive to <your_instance>/CSP/dcanalytics/configs/. The name of dcanalytics.json should match the name of the namespace. DONE! Open the url <server:port>/dsw/index.html?ns=DCANALYTICS and get your own DC Analytics. There are also dashboards, which use iKnow to show links between terms and articles. To setup iKnow part of the solution do the following: Download from release DSW.config.and.iKnow.files.zip and move files sets.txt and backlist.txt from archive to <your_instance>/Mgr/DCANALYTICS/.Run in the terminal following: DCANALYTICS> do ##class(Community.iKnow.Utils).setup() DCANALYTICS> do ##class(Community.iKnow.Utils).update() DCANALYTICS> do ##class(Community.Utils).UpdateСubes() Open iKnow dashboard on: <server:port>/dsw/index.html#!/d/iKnow.dashboard?ns=DCANALYTICS And you will see something like this: What’s Next? – Make it better! Hope, as a usual developer, you don’t like the implementation, don’t like the style, dashboards are awful or not enough - this is great! You can fix it! Let the collaboration started! So, fork it, make it better and provide the pull request. We’ll review it, merge it and introduce to the solution. Make your own better Developer Community Analytics with InterSystems Data Platform! Hi, guys!There is a community project of DSW reports - which provides a way to prepare and send DeepSee Web reports in PDF by schedule.So, we introduced this feature to DC online analytics to have a weekly report in PDF - like this one.If you want to receive this report on Mondays too please put your comment here, we'll put you on the list.And you are very welcome to introduce your issues how we can improve it, or provide your pull requests.

Hi Everybody! We are pleased to invite you to the upcoming webinar "Sharding as the basis of Scaling in InterSystems IRIS Data Platform" on 24th of July at 10:00 (Moscow time)! The webinar focuses on the sharding technology that offers new capabilities for horizontal scalability of data in the InterSystems IRIS platform. Parallelization of data storage and processing power allows you to dynamically scale your applications. In particular, the following topics would be discussed in detail: sharding basics; usecases where it's advisable to use sharding; rapid creation of a sharding cluster with ICM; creating sharded cluster LIVE; advantages of using sharding with Apache Spark, JDBC. Presenter: @Vladimir.Prushkovskiy, InterSystems Sales Engineer. Audience: The webinar is designed for developers. Note: The language of the webinar is Russian. We are waiting for you at our webinar! Register now!

System Monitor is a flexible and highly configurable tool supplied with Caché (Ensemble, HealthShare), which collects the essential metrics of the operating system and Caché itself. System Monitor also notifies administrators about issues with Caché and the operating system, when one or several parameters reach the admin-defined thresholds. Notifications are sent by email or delivered otherwise via a custom notifications class. Notifications can be configured with the help of the ^%SYSMONMGR tool. For email delivery, the admin needs to to specify the parameters of the email server, the recipient’s email address and authentication settings. After that, the user can add the required addresses to the delivery list and test the settings by sending a test message. Once done, the tool will send email notifications about the remaining hard drive space, license expiry information and more. Additional information about notifications can be found here. Immediately after startup (by default, the tool is launched along with a Caché instance), System Monitor starts collecting metrics and recording them to system tables. Collected data is available via SQL. Besides, you can use SYSMON Dashboards to view and analyze these metrics starting from version 2015.1. SYSMON Dashboards is an open-source project for viewing and analyzing metrics. The project is supplied with a set of analytical dashboards featuring graphs for OS and Caché parameters. SYSMON Dashboards uses the DeepSee technology for analytics and building analytical dashboards. The installation process is fairly simple. Here’s what you need to do: Download the latest release,Import the class to any space (for example, USER),Start the installation using the following command: do ##class(kutac.monitor.utils.Installer).setup(). All other settings will be configured automatically. After installation, the DeepSee portal will get a set of DeepSee toolbars for viewing and analyzing performance metrics. In order to view DeepSee toolbars, I use DeepSeeWeb, an open-source project that uses an extended set of components for visualizing DeepSee analytical panels. SYSMON Dashboards also includes a web interface for configuring the monitor and notifications. For detailed configuration, I recommend using the ^%SYSMONMGR utility. The SYSMON Dashboards settings page helps monitor a set of metrics, as well as to start/stop the monitor. Configuration of Email notification settings via the web interface is no different than the standard process: you need to specify the server parameters, address and authentication details. Example of email settings configuration: This way, by using the standard Caché tool, SYSMON Dashboards and DeepSeeWeb, you can considerably simplify the task of monitoring InterSystems platforms. Thanks Semion. I downloaded and installed SYSMON dashboards on a development server but I can't find the SYSMON Configurator tool you're mentioning and showing. Where is that located? Sorry for waiting. Go to URL: "{yourserver:port}/csp/sysmon/index.html".

Hi Everyone!If you are attending VMworld Las Vegas remember to look for two sessions on InterSystems IRIS in the content catalog!InterSystems IRIS sessions at VMworld:1. "Accelerating Digital Transformation with InterSystems IRIS and vSAN" is a '100' level session. This session will show examples from multiple industries, including financial services, logistics, transportation, and manufacturing, and describe benefits and use cases of a unified data platform running on vSAN. I will also review recent benchmark results and scalability choices for InterSystems IRIS. Time: Wednesday, Aug 29, 2:00 p.m. - 3:00 p.m.2. "Best Practices for Deploying the InterSystems IRIS Data Platform on vSAN" is a more technically focused '200' level session. If you are considering moving your InterSystems IRIS or Caché application to hyper-converged infrastructure this session offers practical guidance and explains key architecture and configuration decisions and best practices for a successful deployment. Time: Wednesday, Aug 29, 3:30 p.m. - 4:30 p.m.Join us on the 29th of August!

Hello Everyone, The Certification Team of InterSystems Learning Services is in the process of developing two exams focused on using SQL in InterSystems IRIS and we need input from our InterSystems IRIS SQL community. Your input will be used to evaluate and establish the contents of the exam. How do I provide my input? We will present you with a list of job tasks, and you will rate them on their importance as well as other factors. How much effort is involved? It takes about 20-30 minutes to fill out each survey. You can be anonymous or identify yourself and ask us to get back to you. If you see yourself as an expert in this area, then please complete both surveys as we would love to have your feedback for both exams. How can I access the surveys? You can access them here InterSystems IRIS SQL Specialist Exam InterSystems IRIS SQL Expert Exam What’s in it for me? Aside from our eternal gratitude, you will be entered in a raffle where 15 lucky winners will be given a $50 Tango* card (Available for US based employees. VA employees are not eligible). Completing both surveys will double your chance to win. *Tango cards are a popular digital reward platform that provides a wide selection of e-gift cards from various retailers. NOTE: Survey doesn't work on mobile devices Here are the exam titles and the definition: InterSystems IRIS SQL Specialist Exam An IT professional who has: Experience with standard ANSI SQL. 1 to 2 years of experience on designing and managing InterSystems IRIS SQL applications or expertise in other SQL platforms. 1 year experience on managing InterSystems IRIS SQL applications. InterSystems IRIS SQL Expert Exam Developer or Solutions Architect who has the following: 4 to 6 years experience developing and managing InterSystems IRIS SQL applications 2 years experience working with ObjectScript and globals in InterSystems IRIS Thank you Ali Nasser, Certification Exam Developer, InterSystems Only InterSystems employees may take part in the surveys? No, any IRIS SQL user can complete the surveys. Please be note that this post was updated to include the following information: Survey doesn't work on mobile devices

A set of 14 interactive practice questions are now available for the InterSystems HL7® Interface Specialist Certification exam. These questions have all been developed by our subject matter experts. Feedback for these questions include documentation resources and online learning content. If you're interested in taking our InterSystems HL7® Interface Specialist exam, we highly recommend these questions.

Hi Developers, We'd like to highlight some outstanding projects created during the European Healthcare Hackathon 2023 in Prague. Participants were presented with nine real-world healthcare challenges by IKEM and AstraZeneca. InterSystems introduced to the participants an opportunity to use the FHIR repository and perform FHIR availability into their solutions by providing FHIR cloud services on AWS. Meet the winners of our challenge: 1st place Čarodějové (PathoSync) "The PathoSync software is a solid base for complex pathologist platforms. With the use of custom mapping, any laboratory can project their data into FHIR7 standard, which soon will be mandatory worldwide. This makes the digitalization process smoother. The connection with InterSystems assures quality and implements many healthcare features. Furthermore, the GDPR norms are strictly followed using the FHIR server based in Europe, so the usage of software follows the European standards." Project details | Video presentation | GitHub link 1 link 2 2nd place ICU SPYEYES (Vital Vision) "The ICU requires a system to automatically record video loops capturing key activities like patient and personnel movements. This system will allow retrospective annotations by humans, pre-annotate and identify persons, and optionally blur patient faces. It aims to collect data for developing future patient surveillance algorithms in hospitals. We've developed a system for the ICU that utilizes motion detection, LLM, and standard CV techniques for video analysis. It builds an annotated video database essential for training algorithms focused on patient monitoring. Our solution generates structured reports and videos shared via FHIR, ensuring efficient data handling. Quality is enhanced by manual review through the open-source platform CVAT, optimizing our real-time alarm system for monitoring patient recovery." Project details | Video Presentation | GitHub 3rd place VariantCall (PathoX) "End-to-end solution PathoX is a platform for easy data ingestion, feature extraction and mapping to enhance pathologists’ workflow. An importer workflow supports the mapping of columns and notifies users about missing information. We use FHIR to guarantee future interoperability and compliance with future legislation. Pathologists can also highlight and leave comments on the data, as in their usual workflows, and look at analytics on all files." Project details | Video Presentation | GitHub Well done, congratulations!We are looking forward to seeing how your projects are developing into innovative and impactful startups!

Hey Community, It's time for the first programming contest of the year, and there's a surprise so read on! Please welcome: 🏆 InterSystems AI Programming Contest: Vector Search, GenAI, and AI Agents 🏆 Duration: March 17 - April 6, 2025 Prize pool: $12,000 + a chance to be invited to the Global Summit 2025! The topic Develop any solution on InterSystems IRIS, InterSystems IRIS for Health, or IRIS Cloud SQL that uses AI (IntegratedML included). General Requirements: An application or library must be fully functional. It should not be an import or a direct interface for an already existing library in another language (except for C++, where you really need to do a lot of work to create an interface for IRIS). It should not be a copy-paste of an existing application or library. Accepted applications: new to Open Exchange apps or existing ones, but with a significant improvement. Our team will review all applications before approving them for the contest. The application should work on either IRIS, IRIS for Health or IRIS Cloud SQL. The first two could be downloaded as host (Mac, Windows) versions from Evaluation site, or can be used in the form of containers pulled from InterSystems Container Registry or Community Containers: intersystemsdc/iris-community:latest or intersystemsdc/irishealth-community:latest . The application should be Open Source and published on GitHub or GitLab. The README file to the application should be in English, contain the installation steps, and either the video demo or/and a description of how the application works. No more than 3 submissions from one developer are allowed. NB. Our experts will have the final say in whether the application is approved for the contest based on the criteria of complexity and usefulness. Their decision is final and not subject to appeal. Prizes ❗The authors of the most interesting projects showcasing the use of AI agents will be invited to the Global Summit 2025 (provided the event tickets and accommodation). 1. Experts Nomination - a specially selected jury will determine winners: 🥇 1st place - $5,000 🥈 2nd place - $2,500 🥉 3rd place - $1,000 🏅 4th place - $500 🏅 5th place - $300 🌟 6-10th places - $100 2. Community winners - applications that will receive the most votes in total: 🥇 1st place - $1,000 🥈 2nd place - $600 🥉 3rd place - $300 🏅 4th place - $200 🏅 5th place - $100 If several participants score the same number of votes, they are all considered winners, and the prize money is shared among the winners.❗Cash prizes are awarded only to those who can verify their identity. If there are any doubts, organizers will reach out and request additional information about the participant(s). Who can participate? Any Developer Community member, except InterSystems employees (ISC contractors allowed). Create an account! Developers can team up to create a collaborative application. 2 to 5 developers are allowed in one team. Do not forget to highlight your team members in the README of your application – DC user profiles. Important Deadlines: 🛠 Application development and registration phase: March 17, 2025 (00:00 EST): Contest begins. March 30, 2025 (23:59 EST): Deadline for submissions. ✅ Voting period: March 31, 2025 (00:00 EST): Voting begins. April 6, 2025 (23:59 EST): Voting ends. Note: Developers can improve their apps throughout the entire registration and voting period. Helpful Resources: ✓ Documentation: InterSystems IRIS Vector Search documentation InterSystems IntegratedML documentation Boosting Facial Recognition Vector Search ✓ Example applications and libraries: IRIS Vector Search llamaindex-iris langchain-iris workshop-vector-face IRIS FHIR SQL Builder DBT IntegratedML integratedml-demo-template integratedml-demo - Embedded Python demo suite iris-local-ml - Hugging Face and python usage with IRIS iris-fine-tune-ml - training and tuning ml models with python and InterSystems IRIS QuinielaML - soccer match predictions with IntegratedML workshop-integratedml-csv iris-rag-demo - RAG demo implementation ✓ Online courses: Using Vector Search for Generative AI IntegratedML Interactive Intro Course Hands-on with IntegratedML ✓ Videos: Using Vector Search for Generative AI Adding AI into Interoperability Production Building Models with integratedML in the cloud Generative AI Use Cases in Healthcare ✓ For beginners with IRIS: Build a Server-Side Application with InterSystems IRIS Learning Path for beginners ✓ For beginners with ObjectScript Package Manager (IPM): How to Build, Test and Publish IPM Package with REST Application for InterSystems IRIS Package First Development Approach with InterSystems IRIS and IPM ✓ How to submit your app to the contest: How to publish an application on Open Exchange How to submit an application for the contest Need Help? Join the contest channel on InterSystems' Discord server or talk with us in the comments section of this post. We're waiting for YOUR project – join our coding marathon to win! By participating in this contest, you agree to the competition terms laid out here. Please read them carefully before proceeding. IntegratedML apps will be accepted also? Yes!! 🙂 I'd love to see (and would be inclined to vote for) use of Model Context Protocol specifically - e.g., implementation of IRIS-based MCP servers/clients. looks like an interesting challenge. Hi Developers! Don't miss the recording of the kick-off webinar: ⏯️ The InterSystems AI Programming Contest Kick-Off Webinar Hey Devs! The first application has already been added to the contest!🚀 Check it out! ollama-ai-iris by @Rodolfo.Pscheidt Looks like there is no one specific use case for server, and there are so many variants on how it can be implemented Do you have something in mind, how would you use it? Just thinking about the list of tools to add in server implementation Implemented for Interoperability: it can check status, including items in it, restart, update, recover, and check for queues and errors.There is also SQL Query executon Developers! The deadline for submissions ends on March 30! Upload your application and join the contest!And one more project has been added to the InterSystems AI Programming Contest, check it out: mcp-server-iris by @Dmitry.Maslennikov Community! These are the last hours before the end of the registration phase. Eight more apps have been added to the contest; check them out! langchain-iris-tool by @Yuri.Gomes AiAssistant by @XININGMApax-ai-iris by @Parani.Kiris-data-analysis by @lando.millerbg-iris-agent by @Elena.Karpova Facilis by @Henrique Vitals Lab by Gabriel Yang

How to include IRIS Data into your Google Big Query Data Warehouse and in your Data Studio data explorations. In this article we will be using Google Cloud Dataflow to connect to our InterSystems Cloud SQL Service and build a job to persist the results of an IRIS query in Big Query on an interval. If you were lucky enough to get access to Cloud SQL at Global Summit 2022 as mentioned in "InterSystems IRIS: What's New, What's Next", it makes the example a snap, but you can pull this off with any publicly or vpc accessible listener you have provisioned instead. Prerequisites Provision InterSystems Cloud SQL for temporary use You may need to make some phone calls or request access through the portal as I did to take the InterSystems Cloud SQL for a spin, but it is a very fast way to get up and running in seconds to carry out this demonstration or your IRIS Workloads.Inspecting your deployment, you can head over to the "External Connections" pane on the overview tab and build yourself a connection URL and retaining your credentials. We went wide open for public access (0.0.0.0/0) to the listener and chose not to encrypt the listener either. From above, you'll to disseminate the following information...ConnectionURL: jdbc:IRIS://k8s-c5ce7068-a4244044-265532e16d-2be47d3d6962f6cc.elb.us-east-1.amazonaws.com:1972/USERUser/Pass:SQLAdmin/Testing12!DriverClassName:com.intersystems.jdbc.IRISDriver Setup Google Cloud Platform Provision a GCP Project gcloud projects create iris-2-datastudio --set-as-default Enable Big Query Enable DataFlow Enable Cloud Storage gcloud services enable bigquery.googleapis.com gcloud services enable dataflow.googleapis.com gcloud services enable storage.googleapis.com Create a Cloud Storage Bucket gsutil mb gs://iris-2-datastudio Upload the latest connection driver to the root of the bucket wget https://github.com/intersystems-community/iris-driver-distribution/raw/main/intersystems-jdbc-3.3.0.jar gsutil cp intersystems-jdbc-3.3.0.jar gs://iris-2-datastudio Create a Big Query DataSet bq --location=us mk \ --dataset \ --description "sqlaas to big query" \ iris-2-datastudio:irisdata Create a Big Query Destination Table Now this is where a super powerful advantage becomes somewhat of a nuisance to us. Big Query can create tables on the fly if you supply a schema along with your payload, this is super great inside of pipelines and solutions, but in our case, we need to establish the table beforehand. The process is straightforward as you can export a CSV from the IRIS Database quite easily with something like DBeaver etc, and when you have it, you can invoke the "create table" dialog underneath the dataset you created and use the CSV to create your table. Make sure you have "auto generate schema" checked at the bottom of the dialog. This should complete your Google Cloud Platform setup, and we should be ready configure and run our Dataflow job. Google Dataflow JobIf you followed the steps above you should have the following in your inventory to execute the job to read your InterSystems IRIS data and ingest it into Google Big Query using Google Dataflow.In the Google Cloud Console, head over to Dataflow and select "Create Job from Template" This is a rather unnecessary/exhaustive illustration on how to instruct you to fill out a form with the generated pre-requisites, but it calls out the source of the components... ... to round it out, make sure you expand the bottom section and supply your credentials for IRIS. For the ones who found those screenshots offensive to your intelligence, here is the alternate route to go to keep you inside your comfort zone in the CLI to run the job: gcloud dataflow jobs run iris-2-bq-dataflow \ --gcs-location gs://dataflow-templates-us-central1/latest/Jdbc_to_BigQuery \ --region us-central1 --num-workers 2 \ --staging-location gs://iris-2-datastudio/tmp \ --parameters connectionURL=jdbc:IRIS://k8s-c5ce7068-a4244044-265532e16d-2be47d3d6962f6cc.elb.us-east-1.amazonaws.com:1972/USER,driverClassName=com.intersystems.jdbc.IRISDriver,query=SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, SELF_REFERENCING_COLUMN_NAME, REFERENCE_GENERATION, USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA, USER_DEFINED_TYPE_NAME, IS_INSERTABLE_INTO, IS_TYPED, CLASSNAME, DESCRIPTION, OWNER, IS_SHARDED FROM INFORMATION_SCHEMA.TABLES;,outputTable=iris-2-datastudio:irisdata.dataflowtable,driverJars=gs://iris-2-datastudio/intersystems-jdbc-3.3.0.jar,bigQueryLoadingTemporaryDirectory=gs://iris-2-datastudio/input,username=SQLAdmin,password=Testing12! Once you have kicked off your job, you can bask in the glory a successful job run: ResultsTaking a look at our source data and query in InterSystems Cloud SQL... ... and then Inspecting the results in Big Query, it appears we do in fact, have InterSystems IRIS Data in Big Query. Once we have the data in Big Query, it is trivial to include our IRIS data into Data Studio by selecting Big Query as the data source... this example below is missing some flair, but you can quickly see the IRIS data ready for manipulation in your Data Studio project. First InterSystems IRIS Cloud use case! Whoahoo Thanks Ron Sweeney Hi Ron, Do you have an example of doing the reverse ?... that is, have IRIS extract data from Google Big Query ? Thanks 💡 This article is considered as InterSystems Data Platform Best Practice.

Hey Community, We're pleased to invite all the developers to the upcoming kick-off webinar for the InterSystems FHIR and Digital Health Interoperability Contest! Date & Time: Monday, May 12 – 9 am EDT | 3 pm CEST Discover the exciting challenges and opportunities that await health enthusiasts in this contest. We will also discuss the topics we expect from participants and show you how to develop, build, and deploy applications using the InterSystems IRIS data platform. Speakers: 🗣 @Daniel.Franco, Senior Manager - Interoperability Product Management🗣 @Elijah.Cotterrell, Product Manager - Health Informatics Platform🗣 @Qi.Li, Physician Executive, InterSystems🗣 ​​​@Dean.Andrews2971, Head of Developer Relations🗣 @Evgeny.Shvarov, Senior Startups and Community Programs Manager🗣 ​​​@DKG, Developer Relations Evangelist ✅ Register for the kick-off today! Please join the webinar right now!

Hey Community, Enjoy the new video on InterSystems Developers YouTube: ⏯ Creating an InterSystems IRIS Cross Functional App in 150 Lines of Code @ Global Summit 2024 Based on the speaker's popular Developer Community article with the same title, this talk will walk you through a number of InterSystems IRIS features that can be leveraged to build applications with relatively little code. 🗣 Presenter: @Chris.Stewart, Principal Technical Specialist, InterSystems Your next favorite video is just one click away. Watch now and subscribe!👍 The original article is here: https://community.intersystems.com/post/creating-iris-cross-functional-app The recorded demo is slightly different for a few reasons, and <spoilers> the final demo does not work, but only because of time constraints and a slight typo in code. See if you can spot it! Thank you @Chris.Stewart for the detailed explanation! The video was very informative and clear. I appreciate how well it covered the key points.