Clear filter
Announcement
Irène Mykhailova · Jun 23
Hi Community!
We have great news for those of you who are interested in what's happening at the InterSystems Ready 2025 but couldn't attend in person. All the keynotes are being streamed! Moreover, you can watch them afterwards if they happen at an inopportune time.
Keynotes from Day 1 are already ready 😉
And don't forget to check out the rest of the keynotes:
Keynotes from day 2
Keynotes from day 3
It promises to be epic!
Announcement
Olga Zavrazhnova · Jun 19, 2019
It’s no secret that the InterSystems Global Masters program is integrated with Developer Community, Open Exchange, and Ideas Portal. Whenever you contribute to any of these platforms, you automatically earn points and badges on Global Masters.
We’ve created a short guide to help you discover the best ways to earn points on Global Masters:
Please note that points are automatically awarded on the 4th day after you make a contribution on DC, OEX, or the Ideas Portal (activities made outside of the Global Masters platform).
HOW TO EARN POINTS ON GLOBAL MASTERS
Each published post on Developer Community
Published post on DC ES / PT / JP / CN / FR
200400
1st Comment on DC / Each comment*
Comment on DC ES / PT / JP / CN / FR
300 / 30
60
1st answer marked as Accepted / Each accepted answer
1 000 / 150
Translate an article / a question
150 / 30
Publish 1 / 5 / 10 / 25 / 50 articles on DC
1 500 / 7 500 / 15 000 / 40 000 / 75 000
First published question on DC
Publish 1 / 5 / 10 / 25 / 50 questions on DC
500
500 / 2 000 / 5 000 / 15 000 / 30 000
Each application on Open ExchangeBonus points for each ZPM applicationPublish 1 / 5 / 10 / 25 applications on Open Exchange
8004001 000 / 10 000 / 25 000 / 75 000
1 / 5 / 10 / 25 / 50 Accepted Answers on DC
1 000 / 4 000 / 8 000 / 20 000 / 40 000
Bonus points for each your DC post gathered 750+ / 2000+ / 5000+ / 15000+ views
200 / 500 / 1000 / 3000
Read an article on DCWatch the videoShare an article / video in Social Networks
101050
Write 1 / 2 / 3 / 4 / 5 Articles with Best Practices tag
1000 / 3000 / 7000 / 10 000 / 15 000
50 / 100 / 250 / 500 / 1000 application's downloads on Open Exchange
2 500 / 5 000 / 7 500 / 12 500 / 25 000
Make a review for InterSystems / InterSystems products
2 000 - 3 000
Invite your colleague to Developer Community
1000
Create a video about your OEX application
3000
*counted only comments that were published after registration on the Global Masters Advocate Hub.
Complete challenges, get badges and climb up the levels: Insider > Advocate > Specialist > Expert >Ambassador> Legend.**Please note the level system is not available on a new Global Masters platform starting from April 2024. We are working on bringing it back!
The higher level you are, the more interesting prizes available!
And...
Please check the additional information about Global Masters:
What is Global Masters? Start Here
Global Masters Badges Descriptions
Global Masters Levels Descriptions
If you have not joined InterSystems Global Masters Advocacy Hub yet, let's get started right now!
Feel free to ask your questions in the comments to this post. Thanks, Anastasia!Very helpful! I believe we also have a series upon the number of accepted answers, like 10,25,50,100 accepted answers. Do we? Thank you for this quick reference table (and for my *looks up amount of points for comments* 30 points!) Hi Evgeny,let me answer - we do not have so far, and I think that would be good to have such series & badges to recognize the authors. Are these automated in any way? Wondering if mine is bugged because I've certainly posted questions and comments before but those badges were never unlocked. Their descriptions below say "first" question/comment and I don't know if mine are being detected:https://community.intersystems.com/post/changes-global-masters-program-new-level-new-badges-new-possibilities Hi David! This should be automatic. We'll investigate. I wrote a post on DC in 2017? Do I have to 'register' it to get points on Global Masters?Kind regards, Stephen Hi David!We have fixed this issue. Thank you for the feedback! Thank you! You're very quick! Hi Stephen, I see you have joined recently the Global Masters, that is so great! -this post is not counted in "Write a post on Developer Community" challenge (100 points), as it has been published before you registered- it is counted in all other type of challenges listed above e.g. "Write 10 posts on DC". This was really helpful
Thank you
This is an excellent article and is worth bumping the thread :) Great! This is very helpful! This is helpful. Thank you! "Invite your colleague to Developer Community" - is there a formal way to do this via the D.C. interface? I looked around and couldn't seem to find an 'invite a friend' option or anything like that. I have some colleagues whom I think would benefit from getting involved in the D.C. (CC: @Anastasia.Dyubaylo / @Evgeny.Shvarov ) Hi @Benjamin.Spead you can do that via this Global Masters challenge (this challenge is currently in your "Later" tab) Thank you @Olga.Zavrazhnova2637! I knew I had seen it somewhere at some point. I just had a conversation with a new colleague yesterday about the value of the D.C. and Global Masters, so I will send her an invite :) It's a good idea! Do you mean to have the UI on DC to prepare an email invitation to join DC to a friend developer with a standard invitation text? This was more to figure out the proper way to do this in order for tracking for the badge, etc on the G.M. platform. It makes sense that it needs to originate in a challenge (and than you to Olga for pointing that out).
I don't think that just having a form on the D.C. to invite a friend necessarily makes sense, as anyone can just shoot a friend an email with the link. If others would like to see this as a new feature I won't object though. Hello,please, can you explain how to translate an article/question?
Regards You can see the language of the article in the upper left side of the window, click on it and a list of language will be deployed, select the language to translate the article and a new window will be shown with 2 options, translate and request translate, select the first and you will be able to translate the article. Oh, I see.
Unfortunally there is not Italian language available. Puoi dare un suggerimento in Ideas Portal
Penso che ci sia abbastanza supporto lì.
Perciò ?? @Luca.Ravazzolo ?? Thank you for the table! Thanks, Anastasia!
Very helpful! Thanks for the help. Hello! Thank you very much for remembering these points! I was reading and noticed that the option "Share an article / video in Social Networks" is no longer available in publications, I think this referred to the old platform, right? Hi Marcelo! Yes, the option to share was available for any article and video on the old platform. On the new platform, we still have some articles/videos for sharing, but only for selected content. Social sharing “asks” are tagged with the “social share” tag on the platform when available. Thank you!! Thank for the tips thanks for the information it is very useful Very helpful, thanks I was curious, how long should it take for there to be an update to your points after reading an article / posting a reply? Is this something that should happen immediately, or take some time? This is so cool! Can't wait to get active in the Intersystems community and earn some points Hi Henry! The points are awarded on the 4th day after you post a comment or article — this delay is intentional, for moderation purposes.
However, if you notice a delay longer than that, please let me know. That could indicate a possible issue with the integration between your profiles on DC and GM that we may need to look into 😊 Hi Olga! Thank you for the quick response. That definitely makes sense Hi Olga,
I had a question about the point structure regarding comments. Do you get 300 points for being the first to comment on a post, or is it 300 points for your first ever comment, then 30 points for every subsequent one?
Thanks for your help! That’s a good question! You get 300 points for your first-ever comment on DC — and it comes with a badge too. Then, 30 points for every subsequent one. We’ll update the table to make this clearer.
Now I really like the idea of awarding bonus points to the author of the first answer to a question 😄 — maybe we should introduce something like that! Thanks for the clarification! And I agree, that would be a good way to incentivize initiation on posts.
I also think you should give points to those who suggested great ideas on how to score points 😄
Announcement
Fabiano Sanches · Jun 27
Reference: Build 2025.1.0.1.24372U.25e14d55
Overview
This release introduces significant enhancements to security, analytics capabilities, and user experience, along with important operational improvements aimed at reducing downtime and improving reliability.
New Features and Enhancements
Category
Feature / Improvement
Details
Analytics
Adaptive Analytics in Data Fabric Studio
InterSystems Data Fabric Studio now includes Adaptive Analytics as an optional feature, offering advanced analytics capabilities directly within your workflow.
Security
Enhanced Firewall Management
Firewall management page now supports creating explicit inbound and outbound firewall rules specifically for port 22, providing greater security and access control.
Custom APIs Security Update
Custom APIs have transitioned from ID tokens to access tokens, strengthening security by improving authentication mechanisms.
Enforcement of HTTPS for Custom APIs
Custom APIs no longer support HTTP; all communication is now exclusively over HTTPS, ensuring encrypted and secure data transmission.
General Security Improvements
Multiple security enhancements applied, reinforcing the security posture across the platform.
User Experience
New Feature Announcements and Widgets
Additional widgets have been introduced to effectively communicate new features, announcements, and important updates directly within the Cloud Service Portal.
Operations
Improved Timezone Change Performance
Downtime associated with the timezone-change operation on prod environments significantly reduced from approximately 2 minutes to about 15 seconds, minimizing impact on operations.
Recommended Actions
Explore Adaptive Analytics within Data Fabric Studio to enhance your data-driven decision-making capabilities.
Review firewall settings to leverage the new inbound/outbound port 22 rules. The first deploy you perform will define the rules. Make sure to review the outbound rules.
Ensure Custom APIs use updated SDKs that utilize access tokens instead of ID tokens, and confirm HTTPS-only configurations are correctly applied.
Support
For assistance, open a support case via iService or directly through the InterSystems Cloud Service Portal.
Thank you for choosing InterSystems Cloud Services.
Announcement
Anastasia Dyubaylo · Jul 9
Hey Community,
We're pleased to invite all the developers to the upcoming kick-off webinar for the InterSystems Developer Tools Contest!
Date & Time: Monday, July 14 – 11 am EDT | 5 pm CEST
Discover the exciting challenges and opportunities that await developers in this contest. We will also discuss the topics we would like the participants to cover and show you how to develop, build, and deploy applications using the InterSystems IRIS data platform.
Speakers: 🗣 @Raj.Singh5479, Project Manager - Developer Experience, InterSystems🗣 @Evgeny.Shvarov, Senior Startups and Community Programs Manager, InterSystems🗣 @DKG, Developer Relations Evangelist, InterSystems
✅ Register for the kick-off today!
Announcement
Thomas Dyar · Dec 14, 2021
Preview releases are now available for the 2021.2 version of InterSystems IRIS, IRIS for Health, and HealthShare Health Connect.
As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability release next month. Please share your feedback through the Developer Community so we can build a better product together.
InterSystems IRIS Data Platform 2021.2 makes it even easier to develop, deploy and manage augmented applications and business processes that bridge data and application silos. It has many new capabilities including:
Enhancements for application and interface developers, including:
Embedded Python
Interoperability Productions in Python
Updates to Visual Studio Code ObjectScript Extension Pack
New Business Services and operations added allowing users to set and run SQL query with minimal custom coding
Enhancements for Analytics and AI, including:
New SQL LOAD command efficiently loads CSV and JDBC source data into tables
Enhancements to Adaptive Analytics
Enhancements for Cloud and Operations tasks, including:
New Cloud Connectors make it simple to access and use cloud services within InterSystems IRIS applications
IKO enhancements improve manageability of Kubernetes resources
Enhancements for database and system administrators, including:
Online Shard Rebalancing automates distribution of data across nodes without interrupting operations
Adaptive SQL engine uses fast block sampling and automation to collect advanced table statistics and leverages runtime information for improved query planning
Storage needs for InterSystems IRIS are reduced with new stream and journal file compression settings
Support for TLS 1.3 and OpenSSL 1.1.1, using system-provided libraries
New ^TRACE utility reports detailed process statistics such as cache hits and reads
More details on all of these features can be found in the product documentation:
InterSystems IRIS 2021.1 documentation and release notes
InterSystems IRIS for Health 2021.1 documentation and release notes
HealthShare Health Connect 2021.1 documentation and release notes
InterSystems IRIS 2021.2 is a Continuous Delivery (CD) release, which now comes with classic installation packages for all supported platforms, as well as container images in OCI (Open Container Initiative) a.k.a. Docker container format. Container images are available for OCI compliant run-time engines for Linux x86-64 and Linux ARM64, as detailed in the Supported Platforms document.
Full installation packages for each product are available from the WRC's product download site. Using the "Custom" installation option enables users to pick the options they need, such as InterSystems Studio and IntegratedML, to right-size their installation footprint.
Installation packages and preview keys are available from the WRC's preview download site.
Container images for the Enterprise Edition, Community Edition and all corresponding components are available from the InterSystems Container Registry using the following commands:
docker pull containers.intersystems.com/intersystems/iris:2021.2.0.617.0
docker pull containers.intersystems.com/intersystems/iris-ml:2021.2.0.617.0
docker pull containers.intersystems.com/intersystems/irishealth:2021.2.0.617.0
docker pull containers.intersystems.com/intersystems/irishealth-ml:2021.2.0.617.0
For a full list of the available images, please refer to the ICR documentation.
Alternatively, tarball versions of all container images are available via the WRC's preview download site.
The build number for this preview release is 2021.2.0.617.0. Interoperability productions with Python and Cloud connectors? YEEEESSSSSSS.
However, containers.intersystems.com is giving up bad credentials.... or am I the sole brunt of cruelty here?
```
(base) sween @ dimsecloud-pop-os ~
└─ $ ▶ docker login -u="ron.sweeney@integrationrequired.com" containers.intersystems.com
Password:
Error response from daemon: Get https://containers.intersystems.com/v2/: unauthorized: BAD_CREDENTIAL
```
I was able to get in, for example:
$ docker-ls tags --registry https://containers.intersystems.com intersystems/irishealth ...
requesting list . done
repository: intersystems/irishealth
tags:
- 2019.1.1.615.1
- 2020.1.0.217.1
- 2020.1.1.408.0
- 2020.2.0.211.0
- 2020.3.0.221.0
- 2020.4.0.547.0
- 2021.1.0.215.0
- 2021.2.0.617.0 No problem:
download from wrc>previews some .tar.gz
docker load -i <downloaded> ...
off it goes with Docker run or Dockerfile + docker-compose
And here it is, containers.intersystems.com gone
$ docker pull containers.intersystems.com/intersystems/irishealth-community:2021.2.0.617.0
Error response from daemon: Get "https://containers.intersystems.com/v2/": Service Unavailable
Could you push those images to the docker hub, as usual before? It's more stable. Hi Dmitry,
Thanks for the heads-up, we are working to bring containers.intersystems.com back online. The docker hub listings will be updated with the 2021.2 preview images in the next day or so, and we will update this announcement when they're available!
Kind Regards,Thomas Dyar Good news -- containers.intersystems.com is back online. Please let us know if you encounter any issues!
Regards,
Thomas Dyar And images with ZPM package manager 0.3.2 are available accordingly:
intersystemsdc/iris-community:2021.2.0.617.0-zpm
intersystemsdc/iris-ml-community:2021.2.0.617.0-zpm
intersystemsdc/iris-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-ml-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-community:2021.1.0.215.3-zpm
And to launch IRIS do:
docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.617.0-zpm
docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-ml-community:2021.2.0.617.0-zpm
docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.617.0-zpm
docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.617.0-zpm
docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-ml-community:2021.2.0.617.0-zpm
docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.617.0-zpm
And for terminal do:
docker exec -it my-iris iris session IRIS
and to start the control panel:
http://localhost:9092/csp/sys/UtilHome.csp
To stop and destroy container do:
docker stop my-iris
And the FROM clause in dockerfile can look like:
FROM intersystemsdc/iris-community:2021.2.0.617.0-zpm
Or to take the latest image:
FROM intersystemsdc/iris-community Excellent! That's comfort. Available on Docker Hub too. Will we have an arm64 version? I was trying to install the preview version on Ubuntu 20.04.3 LTS ARM64(in a VM on Mac M1).
But irisintall gave the the following error. Installing zlib1g-dev did not solve the problem. Could anyone suggest me what I was missing?
-----
Your system type is 'Ubuntu LTS (ARM64)'.
zlib1g version 1 is required.
** Installation aborted ** Based on the msg alone , would need:
sudo apt install zlib1g
Instead of:
sudo apt install zlib1g-dev Thanks. But looks like zlib1g is already installed..
$ sudo apt install zlib1g
Reading package lists... Done
Building dependency tree
Reading state information... Done
zlib1g is already the newest version (1:1.2.11.dfsg-2ubuntu1.2).
0 upgraded, 0 newly installed, 0 to remove and 11 not upgraded. I know this is not the proper way to do it, but I worked around this issue by deleting the line for zlib1g in the file, package/requirements_check/requirements.lnxubuntu2004arm64.isc.
Looks like the instance is working fine, so I suspect there is something wrong with requirement checking in installation.
Question
Ben Spead · Feb 3, 2022
(I wasn't able to find this in the docs or the Community, so feel free to point me to a reference that I missed)
How can I determine the effective User and Group that will be used when an InterSystems IRIS process is doing file I/O on the file system for UNIX? Bonus points if you can tell me how to do it from within InterSystems IRIS as well as from the host OS.
Thanks! From the OS side in AIX, I can see it in parameters.isc (example from a QA env I'm playing with)
security_settings.iris_user: irisusr
security_settings.iris_group: irisusr
security_settings.manager_user: irisusr
security_settings.manager_group: irisusr
I do not recall how to see it in IRIS itself (or if it's even possible) but I remember wanting to figure out how to change the values after installation (due to someone goofing up an entry on a dev environment) and without a lot of effort, it is pretty difficult. Thank you @Craig.Regester for the response. Looking up that file in the docs (https://docs.intersystems.com/iris20201/csp/docbook/DocBook.UI.Page.cls?KEY=GCI_unixdist) it tells me that "For security reasons, the parameters.isc file is accessible only by the root user." I am pretty sure there is a way to tell what it is currently running as without needing that level of access. But it is good to know about this in the cases where root access is an option Interesting question. I didn't see anything for this in the class reference either. I'll be following this post. ##class(%SYS.ProcessQuery).GetOSUsername() You could try:ps -ax -o uname,cmd | grep "irisdb WD" | grep -v "grep"-ax will get all the running processes including ones that aren't running on a terminal, retrieve the username, and command that started the process. We then use grep to filter out the exact process we need. Thanks @Jean.Millette and @Timothy.Leavitt for the help with this! great way to do it within InterSystems IRIS - thanks Tim! Perfect!! Exactly what I was looking for - thank you @Sarmishta.Velury (and @Jean.Millette and @Timothy.Leavitt ) If you're doing file I/O, why not %File.GetOwnerGroup()? Or is this something you need to know before you open (or create) a file? @Jeffrey.Drumm - it is important to have this run from a process that is already running in the InterSystems IRIS instance (or something spun off from the SuperServer) so that it doesn't pick up your UNIX username if you enter via console. So being able to run an API like Tim's will work nicely as I can run it via the Output window from Studio: Understood ... but I'm curious as to how IRIS is getting my environment:
w ##class(%SYSTEM.Util).GetEnviron("USER")
jdrumm
w ##class(%SYS.ProcessQuery).GetOSUsername()
irisusr
No idea, but I don't think it's tied to the IRIS name. When I am logged into Studio as bspead I see the following:
[quote]
w ##class(%SYSTEM.Util).GetEnviron("USER")rootw ##class(%SYS.ProcessQuery).GetOSUsername()cacheusr
[/quote]
Announcement
Evgeny Shvarov · Jun 1, 2022
Hi developers!
Here is the score of technical bonuses for participants' applications in the InterSystems Grand Prix 2022 programming Contest!
Project
InterSystems FHIR
IntegratedML
Native API
Interoperability
Production EXtension
Embedded Python
AtScale
Tableau, PowerBI, Logi
InterSystems IRIS BI
Docker
ZPM
Online Demo
Unit Testing
First Article on DC
Second Article on DC
Code Quality
Video on YouTube
Total Bonus
Nominal
5
4
3
3
4
5
4
9
3
2
2
2
2
2
1
1
3
55
db-migration-using-SQLgateway
2
2
2
6
CrossECP-IRIS
2
2
2
1
7
M-N-Contests
2
2
2
2
1
1
3
13
cryptocurrency-rate-forecasting
0
FHIR Patient Viewer
5
2
3
10
IRIS import manager
3
2
2
7
test-data
3
5
2
2
2
2
2
1
19
Docker InterSystems Extension
2
3
5
apptools-infochest
2
2
2
2
8
iris-mail
3
5
2
2
2
2
1
17
production-monitor
3
2
2
7
iris-megazord
5
3
2
2
2
2
2
1
3
22
apptools-admin
2
2
2
6
webterminal-vscode
2
2
ESKLP
3
2
2
7
Disease Predictor
4
2
2
2
1
3
14
iris-fhir-client
5
5
2
2
2
2
1
3
22
Water Conditions in Europe
5
4
9
3
2
2
2
1
3
31
FHIR Pseudonymization Proxy
5
3
2
2
12
ObjectScript-Syntax-For-GitLab
2
2
1
5
CloudStudio
2
3
5
FIT REST Operation Framework
3
2
2
7
Bonuses are subject to change upon the update.
Please claim here in the comments below or in the Discord chat. My app Disease Predictor has YouTube video. It is already added at the end of OEX app page description (https://openexchange.intersystems.com/package/Disease-Predictor). So I claim youtube bonus. I've added YouTube video and added it at the description of OEX Application https://openexchange.intersystems.com/package/Water-Conditions-in-EuropeAlso two related articles posted to DC, linked to application, please count.
And the last question is about bonuses for Tableau, PowerBI, Logi.
According to The Rules 3 points count for each of that systems.
I've used all them 3 in Contest App. I've added YouTube video and 2nd Article for iris-fhir-client app (https://openexchange.intersystems.com/package/iris-fhir-client) .So please consider it.
Thanks Added zpm/docker support (though struggling w/ M1 docker a bit I think) Hi @Craig.Regester! This is great!
Please submit the app with the ZPM option on OEx to make it available for everyone!
Announcement
Celeste Canzano · May 12
Hello IRIS community,
InterSystems Certification is currently developing a certification exam for InterSystems IRIS SQL professionals, and if you match the exam candidate description given below, we would like you to beta test the exam! The exam will be available for beta testing starting May 19, 2025.
Please note: Only candidates with the pre-existing InterSystems IRIS SQL Specialist certification are eligible to take the beta. Interested in the beta but don’t have the SQL Specialist certification? Take the SQL Specialist exam!
Eligible candidates will receive an email from the certification team on May 19, 2025 with instructions on scheduling the exam.
Beta testing will be completed July 15, 2025.
What are my responsibilities as a beta tester?
You will schedule and take the exam by July 15th. The exam will be administered in an online proctored environment free of charge (the standard fee of $150 per exam is waived for all beta testers). The InterSystems Certification team will then perform a careful statistical analysis of all beta test data to set a passing score for the exam. The analysis of the beta test results will take 6-8 weeks, and once the passing score is established, you will receive an email notification from InterSystems Certification informing you of the results. If your score on the exam is at or above the passing score, you will have earned the certification!
Note: Beta test scores are completely confidential.
How is this exam different from the InterSystems IRIS SQL Specialist exam?
This new exam - InterSystems IRIS SQL Professional - covers higher-level SQL topics and is recommended for candidates with 4 to 6 years of relevant experience, compared to the 1 to 2 years recommended for the SQL Specialist exam.
Interested in participating? Read the Exam Details below.
Exam Details
Exam title: InterSystems IRIS SQL Professional
Candidate description: A developer or solutions architect who
Designs IRIS SQL applications
Manages IRIS SQL operations
Uses IRIS SQL
Loads and efficiently queries datasets stored in IRIS SQL
Number of questions: 38
Time allotted to take exam: 2 hours
Recommended preparation: Review the content below before taking the exam.
Online Learning:
Using SQL in InterSystems IRIS (learning path, 3h 45m)
Recommended practical experience:
4 to 6 years of experience developing and managing IRIS SQL applications is recommended.
At least 2 years of experience working with ObjectScript and globals in InterSystems IRIS is recommended.
Exam practice questions
A set of practice questions is provided here to familiarize candidates with question formats and approaches.
Exam format
The questions are presented in two formats: multiple choice and multiple response. Access to InterSystems IRIS Documentation will be available during the exam.
DISCLAIMER: Please note this exam has a 2-hour time limit. While InterSystems documentation will be available during the exam, candidates will not have time to search the documentation for every question. Thus, completing the recommended preparation before taking the exam, and searching the documentation only when absolutely necessary during the exam, are both strongly encouraged!
System requirements for beta testing
Working camera & microphone
Dual-core CPU
At least 2 GB available of RAM memory
At least 500 MB of available disk space
Minimum internet speed:
Download - 500kb/s
Upload - 500kb/s
Exam topics and content
The exam contains questions that cover the areas for the stated role as shown in the exam topics chart immediately below.
Topic
Subtopic
Knowledge, skills, and abilities
1. Designs IRIS SQL applications
1.1 Designs a SQL schema
Distinguishes use cases for row vs columnar table layout
Distinguishes use cases for different index types
1.2 Designs advanced schemas
Recalls anatomy of Globals (subscript and value)
Interprets relationship between table structure and Globals
Distinguishes the (Globals) level at which mirroring/journaling operates from the SQL layer
Distinguishes the differences between date/time data types
Interprets the overhead associated with stream data
Identifies use cases for text search
1.3 Writes business logic
Identifies use cases for UDFs, UDAFs, and SPs
1.4 Develops Object/Relational applications
Recalls SQL best practices when defining classes
Uses Object access to interact with individual rows
Identifies SQL limitations with class inheritance
Uses serial and object properties
Identifies use cases for collection properties
Distinguishes class relationships from Foreign Keys
1.5 Deploys SQL applications
Determines what needs to be part of a deployment
2. Uses IRIS SQL
2.1 Manages IRIS query processing
Identify benefits of the universal query cache
List considerations made by the optimizer
Differentiates client and server-side problems
Uses Statement Index to find statement metadata
Distinguishes between the use of parameters and constants in a query
Distinguishes between transaction and isolation levels
2.2 Interprets query plans
Identifies the use of indices in a query plan
Identifies vectorized (columnar) query plans
Uses hints to troubleshoot query planning
Identifies opportunities for indices, based on a query plan
2.3 Uses IRIS SQL in applications
Distinguishes use cases for Dynamic SQL and Embedded SQL
2.4 Uses IRIS-specific SQL capabilities
Uses arrow syntax for implicit joining
Determines use cases for explicit use of collation functions
3. Manages IRIS SQL operations
3.1 Manages SQL operations
Identifies use cases for purging queries and rebuilding indices
Recalls impact of purging queries and rebuilding indices
Identifies use cases for un/freezing query plans, including automation
Identifies use cases for (bitmap) index compaction
Uses the runtime stats in the Statement Index to find statements with optimization opportunities
3.2 Configures InterSystems SQL options
Recalls relevant system configuration options (e.g. lock threshold)
Differentiates scale-out options, ECP, and sharding
3.3 Manages SQL security
Recalls to apply SQL privilege checking when using Embedded SQL
3.4 Uses PTools for advanced performance analysis
Identifies use cases for using PTools
Interested in participating? Eligible candidates will receive an email from the certification team on May 19th with instructions on how to schedule and take the exam. Hello Celeste! This is really interesting. How are the eligible candidates chosen? Is there a way to apply? Thank you. Hi Pietro! Unlike prior certification exam betas, only folks who hold the InterSystems IRIS SQL Specialist certification are eligible. There is no application process, rather, the certification team will be reaching out directly to eligible individuals on May 19th. Anyone who holds an active SQL Specialist certification will receive an email next Monday with instructions on how to access and take the beta exam. The email will be sent to the address associated with your account on Credly, our digital badging platform.
If you do not yet have the SQL Specialist certification, I encourage you to consider taking the InterSystems IRIS SQL Specialist certification exam. Once you pass this exam and obtain the certification, you will receive an email from the certification team regarding the beta.
Please let me know if I can clarify anything! Thank you for the clarifications Celeste! dear @Celeste.Canzano
Can anyone take this beta test? or only those who holds an active SQL Specialist certification is eligible for this?
Regards,
Harshitha Hi Harshitha! Only those who hold an active SQL Specialist certification are eligible for the SQL Professional beta. Please let me know if you have any additional questions.
Question
Kurt Hofman · Dec 15, 2020
Hello,
I'm testing IRIS 2020.4 Preview with preview key.
I've access to the management portal but I can't connect with Studio.
This is my docker-command : docker run --name my-iris --detach --publish 9091:51773 --publish 9092:52773 --volume C:\Docker\iris_external:/external –-volume C:\Docker\iris_durable:/durable –-env ISC_DATA_DIRECTORY=/durable/irissys containers.intersystems.com/intersystems/iris:2020.4.0.524.0 --key /external/iris.key --password-file /external/password.txt
I notice that Caché Direct is disabled by the license.
Can someone help me out ? InterSystems have changed SuperServer port in a few latest builds, back to 1972. So, just replacing 51773 with 1972, should work.
You can use docker inspect
docker inspect containers.intersystems.com/intersystems/iris:2020.4.0.524.0
Will outputs something like this
.....
"ExposedPorts": {
"1972/tcp": {},
"2188/tcp": {},
"52773/tcp": {},
"53773/tcp": {},
"54773/tcp": {}
},
.....
"Labels": {
"com.intersystems.adhoc-info": "",
"com.intersystems.platform-version": "2020.4.0.524.0",
"com.intersystems.ports.default.arbiter": "2188",
"com.intersystems.ports.default.license-server": "4002",
"com.intersystems.ports.default.superserver": "1972",
"com.intersystems.ports.default.webserver": "52773",
"com.intersystems.ports.default.xdbc": "53773",
"com.intersystems.product-name": "IRIS",
"com.intersystems.product-platform": "dockerubuntux64",
"com.intersystems.product-timestamp": "Thu Oct 22 2020 13:02:16 EDT",
"com.intersystems.product-timestamp.iso8601": "2020-10-22T17:02:16Z",
"maintainer": "InterSystems Worldwide Response Center <support@intersystems.com>",
"org.opencontainers.image.created": "2020-10-22T19:32:32Z",
"org.opencontainers.image.documentation": "https://docs.intersystems.com/",
"org.opencontainers.image.title": "intersystems/iris",
"org.opencontainers.image.vendor": "InterSystems",
"org.opencontainers.image.version": "2020.4.0.524.0-0"
}
I've just left, only interesting lines in your case. Where you can find, which ports are declared as exposed in the image, and labels, which declares available ports in the image.
Access directly to the label
$ docker inspect containers.intersystems.com/intersystems/iris:2020.4.0.524.0 \
--format '{{ index .Config.Labels "com.intersystems.ports.default.superserver" }}'
1972 Thanks, I replaced 51773 with 1972 and now it works !
Question
yeung elijah · Jan 28, 2021
Hi,
I'm a java developer,have integration package for springboot?(maven or gradle)
This is also the question I want to submit. check https://openexchange.intersystems.com/package/springboot-iris-crud
Article
Yuri Marx · Oct 22, 2020
I liked the transactional analytic DBMS and Advanced Analytics segmentation concept.
The 1.0 version IRIS plug-in to VSCode is amazing. The partnership between community and InterSystems was very positive to it. However a low code option would do very well for IRIS in the near future.
The Dynamic Gateways/Native API positions IRIS as the most advanced data platform for the main open languages in the market, but it is necessary use the public package managers from these languages, specially maven public repository.
The API Manager is a good option but it is not available to the community IRIS version and can be used only with API created with IRIS. It is a critical point to resolve.
OPC-UA adapter to IoT and Kakfa adapter to realtime events are great, I loved it. In the future, new adapters to the Salesforce, SAP, Office 365 and other most used platforms could be considered.
Cloud support is perfect now, with ICM and IKO to deploy and manage and SAM to monitor.
The FHIR accelerator is great option to FHIR projects, it's really very useful.
IRIS really is getting faster and faster, impressive to be able to make something that is already very fast faster.
The Adaptive Analytics was an impressive launch and very welcome, it has the ability to speed up and simplify the creation of analytical cubes (in a totally visual and intuitive way) and its exposure to excel and other data viewers in a wonderful way. In the future I would like to see InterSystems launching its own viewer, since IRIS Reports is for restricted use and is not available for community versions, making it impossible to popularize in the community.
The IntegratedML was my favorite new IRIS feature. Very easy to use, any DBA can be use it. The AutoML is a fantastic technology and will be used a lot. Now, InterSystems needs to deliver a viewer of predictions and classifications to the end user, it could use the same technology as SAM, the Grafana.
I agree with you in most cases.
The most important announcement for me would be Embedded Python.This will bring to the community the power of python libraries, it's a giant step forward.
Yes, the integration with python is very important.
Announcement
Anastasia Dyubaylo · Oct 12, 2021
Hey Developers,
Are you joining us for the InterSystems Virtual Summit 2021?
⚡️ THE REGISTRATION IS NOW OPEN ⚡️
Innovations in Data - #VSummit21
At the second InterSystems Virtual Summit, learn how to make your organization thrive with healthy data, powerful analytics, and a smart data fabric powered by InterSystems technology. Hear from our experts, world-leading thought leaders, and InterSystems customers from around the globe.
🗓 Tuesday, October 26 - Friday, October 29
👉 Keynotes | Live Experience Labs | Focus Sessions On-demand | Free Registration
Summit Schedule
Day 1 (Tuesday, Oct.26)Keynote presentations by our InterSystems leadership team, thought leaders, and key customers.
Day 2 (Wednesday, Oct. 27)Keynotes about Client Support and "What’s New and Next" presentations by product directors for InterSystems IRIS®, InterSystems IRIS for Health™, HealthShare®, and TrakCare®.
Days 3 and 4 (Thursday, Oct. 28, and Friday, Oct. 29)Build your own schedule. Take this opportunity to view all the Focus Sessions on demand. You can also sign up for our Experience Labs. All on demand focus sessions are pre-recorded and will be available on day 2 starting at 2 PM ET.
REGISTER FOR FREE TODAY. And see you at Virtual Summit 2021!
Question
Nagarjuna Reddy Kurmayyagari · May 5, 2020
I am trying to install IAM in my local and I downloaded IAM-0.34-1-1.tar.gz and extracted. I went to the location where iam_image.tar is available and run below command in the command prompt.
C:\ESB\HC\IAM-0.34-1-1.tar\IAM-0.34-1-1\IAM>docker load -i iam_image.tarunsupported os linux
Getting unsupported os Linux issue. Kindly let me know if anyone had this issue. Thanks!
On windows docker works in two different ways, as windows containers and linux containers. It looks like, you just should switch it to linux from Windows Thanks for reply @Dimtriy, I am new to Docker. I have below info on my machine about docker and looks it is using Windows container. Let me know if anything needs to be changed.
C:\>docker versionClient: Docker Engine - Community Version: 19.03.8 API version: 1.40 Go version: go1.12.17 Git commit: afacb8b Built: Wed Mar 11 01:23:10 2020 OS/Arch: windows/amd64 Experimental: false
Server: Docker Engine - Community Engine: Version: 19.03.8 API version: 1.40 (minimum version 1.24) Go version: go1.12.17 Git commit: afacb8b Built: Wed Mar 11 01:37:20 2020 OS/Arch: windows/amd64 Experimental: false
As I said for server side it show linux for os/arch. You should find the switcher in context menu in tray on docker icon. Thank you, I am able to load the image after I switch to linux container in server-side. After I loaded the image, I am trying to do the next step of configuration.
2) Configure your InterSystems IRIS instance
2a) Enable the /api/IAM web application 2b) Enable the IAM user 2c) Change the password for the IAM user
Do we need to change these settings in iris.cpf file? any inputs where we have to configure. I have IRIS 2019.1.1 installed in my machine.
Question
Neguinho Robson · Jun 23, 2021
Is there any chance to make available a arm64/aarch64 binary version for Caché ODBC Driver?
Just like IRIS ftp://ftp.intersystems.com/pub/iris/odbc//2021/ODBC-2021.1.0.215.0-lnxrharm64.tar.gz
As I am using docker, currently is not possible to build locally a new image using existing Caché ODBC Drivers on Mac M1. Do you still expect some echo?Or is the question meanwhile just out of date? @Robert.Cemper1003
I am waiting for that. Do you have any solution ? Caché will not get support for M1, and so, I think no reasons to wait for an ODBC driver for M1 too No, I have no solution.As all development on Caché (except serious bugfix) is frozen I wouldn't expect this to come.You may migrate your Caché to IRIS. Or use some other way (REST ?) for access.
Announcement
Anastasia Dyubaylo · Feb 12, 2020
Hi Developers,
The new video from Global summit 2019 is already on InterSystems Developers YouTube:
⏯ Intersystems IRIS Kubernetes Operator
This video introduces the InterSystems IRIS Kubernetes operator, which enables InterSystems IRIS containers to function as "first-class citizens" of the Kubernetes ecosystem. We recommend that you be familiar with basic Kubernetes concepts: Introduction to Kubernetes Video
Takeaway: You will understand and appreciate the value proposition of the InterSystems IRIS Kubernetes operator.
Presenters: 🗣 @Luca.Ravazzolo, Product Manager, InterSystems🗣 @Steven.Lubars, InterSystems Software Developer
Additional materials to this video you can find in this InterSystems Online Learning Course.
Check out the Cloud Deployment Resource Guide.
Enjoy watching this video! 👍🏼 HI Guys,
Can you please post the link of prevision session that you mentioned in this video. I am still not sure how we will use Kubernetes with IRIS . It be great if you can put some light on that too ?
Thanks Hi Neerav Adam,
Are you looking for the Introduction to Kubernetes session? Does anyone know how to download this operator? I'm excited to start using it. Hi @Jonathan.Keam, I hope you found the answer back in Jan. If not head over to containers.intersystems.com
HTH