Search

Let's assume that we have already connected a data source to Adaptive Analytics, created a project and added tables there. Now we will prepare Adaptive Analytics for work. First, we need to select data from tables, to make it available for the future report. To do this, we need to create dimensions from the columns of the tables. Dimensions are usually created to break down our data into categories, such as what city the user lives in, or what month a purchase was made in. However nothing prevents us from creating dimensions from numerical data so that we could apply functions to them in Intersystems Reports Designer. The tool for creating dimensions is located on the right side of the interface as shown in the image below. To create a new dimension, right-click on the hamburger button located to the right of the "Filter" line and select a "Create Dimension" line as indicated in the picture. The following window will appear: After having created a dimension, you can make it hierarchical. To do that, double-click the left mouse button on the dimension in the left table and get into the hierarchy editor. By clicking on the three dots next to the hierarchy, we can create a new dimension within the hierarchy. In the menu, the dimensions can be moved up / down the hierarchy. Thanks to hierarchies, we can make different levels of data details. For example, we can specify how many people have visited the site from the country, region, city.You can use dimensions to create relationships between tables. To do that, you need to drag the desired field of the table using the left mouse button and drop it in the desired highlighted dimension.. The link creation window will appear. Click Save, and our connection will be ready. In addition to the actual data from the table, in Adaptive Analytics we can create measures based on various operations applied to a specific column. Measures are always a numerical display of data - number of users, amount of purchases, average time spent watching a video, etc. To create a measure, we apply the same principle as for dimensions but using the "Measures" tab. By clicking on the hamburger button and selecting "Add measure", we call the following window: ‘Measure name’ is the name that will be displayed in the Adaptive Analytics interface. ‘Query name’ is the name that will be displayed in the Intersystems Reports Designer. It is generated automatically based on the column name, but you can also set it yourself. ‘Description’ is the description visible in Adaptive Analytics. 'Sources' define from which table and which column to take data for the measure.‘Aggregation Handling’ shows which function we apply to the data. The list of functions can be found below. By default the "Sum" is selected as a value: ‘Data Handling and Formatting’ determines what will happen to the measure if it is used in conjunction with a dimension for which the measure is not defined. You should leave it by default. ‘Visibility in Published Data Sources’ specifies whether this measure will be available in Intersystems Reports Designer. You can split measures by dimensions. For example, we have a measure that shows the average check, which we have calculated employing the data of a column with daily data for one year. If we distribute the measure over a dimension containing months, we will get the average check for each month. To find out what is in your data connected to Adaptive Analytics, you can use the Cube Data Preview tool. You can get into it by clicking on the tab in the upper left corner of the workspace. By specifying a dimension on one axis and a measure on the other, we get the measure value for each dimension value. In this case, below you can see the number of records in the table for each date. Having created all the measures, dimensions and relationships that we needed, now we must publish our project. To do that, go to the main page of the project on the tab in the upper left corner and click the "Publish" button, then click the "Next" button on all windows which will appear. Now we can start paying attention to the left window, where we have 2 sections: "Draft", where we can edit our project, and "Publish", which displays the published versions of the project. By clicking on the "Published project", select the cube, and go to its "Connect" tab. Here we can see all the necessary data to connect Intersystems Reports Designer to our project. We have learned everything we need to work with Adaptive Analytics. Now we can move on to working in InterSystems Reports Designer. I need to mention that Intersystems Reports Designer version 17.1 requires JDK version 16 to work, and it will not run on later versions. First, you need to install drivers for the JDBC connection to Adaptive Analytics. Here are the links to the required JAR files. The JDBC driver itself must be compatible with the one used on the server. We use versions that are old enough so that we do not get an error caused by the older version of the Hive on the server compared to ours. For convenience, we have collected all the necessary libraries in one archive, which you can download from the link: https://github.com/teccod/Logi-JDBC-drivers These files must be placed in the lib folder, located along the path LogiReport\Designer\lib. Launch Intersystems Reports Designer and close the "Start" page. Now you can find yourself in the workspace of Intersystems Reports Designer. By default, it opens the last catalog with which the user was working or the pre-installed catalog that was installed with Intersystems Reports Designer. Go to the "File" section and click "New Catalog"; fill in the name of the catalog, the name of the data source and the location where the file should be saved. Intersystems Reports Designer creates an empty data source for us. Right-click on it and select "New JDBC connection". In the "Driver" line we write our driver - org.apache.hive.jdbc.HiveDriver. We take the URL from the JDBC field of the "Connect" tab in Adaptive Analytics and fill in the username and password. The connection is established, but no cubes from the project have been loaded into it yet. Right-click on "Tables", then "Add tables" and select the desired cubes; add them with the "Add button", then press "Done" to complete the process. If the tables are not displayed when you select a data scheme different from the one that opens by default, use the "Refresh" button. After adding everything that we needed, we have the dimensions and measures available in the project, and we can almost start creating a report. In order to use the available data, we must make a request. In this request, we can impose the necessary restrictions on the data (do not show canceled orders, do not display data for the current month, etc.) and take only the part of the data that we need. To create a query on the "Home" or "File" tab, select "New" and choose "Query". We pick the data source, fill in the query name, open our source, "Tables" and add the necessary tables to the query using the arrow. We get into the query editor window: There, by setting the necessary checkboxes or by checking the box next to the * field, select the necessary ones or all fields of the table. In the "Menu" item, we see several functions, the most interesting one of which is data filtering. Here we can add conditions that will be written in SQL in the "WHERE" section of the "SELECT" statement (or simply, conditions that cut off data for the specified expression). In our case, we could write that the date is less than a certain value, is in a range of values, etc.In the "Query Editor", we can also add calculated columns to enrich our data. The functions that you can use when creating them depend on what functions the data source provides. Adaptive Analytics does not provide any functions, so we are limited to the built-in Logi functions (which are the simplest mathematical and logical operators). If there are several tables in the query, then you can set up links between them by dragging the link with the left mouse button from one field to another. In the SQL query code, these relationships will be displayed as WHERE table_name1.field_name = table_name2.field_name. When you have finished editing the request, click the "ok" button. If necessary, you can create several more queries with different filters or fields in them. Now you are ready to create the report. We will talk about the process of its creation in the next article.

Hi Community, Our 1st InterSystems Portuguese Tech Article Contest ended. We received several interesting content in: 6 amazing articles 🔥 A great thanks to all that participated on our competition ! And now it's time to announce the winners .... Meet the winners of the 1st InterSystems Portuguese Tech Article Contest and their amazing articles: ⭐️ Expert Awards – winners selected by InterSystems experts: 🥇 1st place: Utilizando HealthShare para normalização de resultados de SARS-CoV-2/COVID-19 written by @Renan.Santos 🥈 2nd place: Introdução à análise de dados com IRIS e Pandas written by @henry 🥉 3rd place: HealthShare: criando o ecossistema de atendimento orientado a dados written by @Yuri Marx ⭐️ Community Award – winner selected by Community members, article with the most likes: 🎉 Winner: Utilizando HealthShare para normalização de resultados de SARS-CoV-2/COVID-19 written by @Renan.Santos ⭐️ And let's meet our new member who joined our competition: @Julio.Esquerdo : 1 article 🤩 Wow! For their great contribution, we'd like to reward these authors with a 🎁 InterSystems Thermic Bottle 🎁! ⭐️ Let's congratulate all our heroes at the contest: @Renan.Santos @henry @Yuri Marx @Julio.Esquerdo THANK YOU ALL! You have made an incredible contribution to our Dev Community! P.S. The prizes are in production now. We will contact all the participants when they are ready to ship - stay in touch! So, Awesome our 1st InterSystems Portuguese Tech Article Contest, isn't it ? Thanks to all the participants for the efforts you pay in our 1st InterSystems Portuguese Tech Article Contest! And what's next.....? Stay tuned !!!!  Congratulations!! Congratulations to all of you! I hope it's always helping the community! Congrats for all participants and thanks for this fantastic contest Congratulations to all of you! CONGRATULATIONS ALL!!!! 🎉

Hi Community, It's voting time! Cast your votes for the best applications in our IRIS for Health Programming Contest focused on building FHIR solutions for Women's Health: 🔥 VOTE FOR THE BEST APPS 🔥 How to vote? Details below. Experts nomination: InterSystems experienced jury will choose the best apps to nominate the prizes in the Experts Nomination. Please welcome our experts: ⭐️ @akoblov, Support Specialist⭐️ @Alex.Woodhead, Technical Specialist⭐️ @Guillaume.Rongier7183, Sales Engineer⭐️ @Alberto.Fuentes, Sales Engineer⭐️ @Dmitry.Zasypkin, Senior Sales Engineer⭐️ @Daniel.Kutac, Senior Sales Engineer⭐️ @Eduard.Lebedyuk, Senior Cloud Engineer⭐️ @Steve.Pisani, Senior Solution Architect⭐️ @Patrick.Jamieson3621, Product Manager⭐️ @Nicholai.Mitchko, Manager, Solution Partner Sales Engineering⭐️ @Timothy.Leavitt, Development Manager⭐️ @Benjamin.DeBoe, Product Manager⭐️ @Robert.Kuszewski, Product Manager⭐️ @Stefan.Wittmann, Product Manager⭐️ @Raj.Singh5479, Product Manager⭐️ @Jeffrey.Fried, Director of Product Management⭐️ @Aya.Heshmat, Product Specialist⭐️ @Evgeny.Shvarov, Developer Ecosystem Manager⭐️ @Dean.Andrews2971, Head of Developer Relations Community nomination: For each user, a higher score is selected from two categories below: 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 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 Blind vote! The number of votes for each app will be hidden from everyone. Once a day we will publish the leaderboard in the comments to this post. The order of projects on the contest page will be as follows: the earlier an application was submitted to the competition, the higher it will be on the list. P.S. Don't forget to subscribe to this post (click on the bell icon) to be notified of new comments. 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! Support the application you like! Note: 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! Hello everyone, Check out the V2 of my application for the InterSystems FHIR contest !! This time, we will see how to go from CSV to FHIR to SQL to JUPYTER all in one go and using only Python !!! Check this out here : https://community.intersystems.com/post/incredible-csv-fhir-sql-jupyter-fhir-contest-v2 thanks for your contributions, Lucas! :) Hey, Developers! Since the start of the contest, here are the top 5 apps! Expert Nomination, Top 5 Pregnancy Symptoms Tracker by @José.Pereira fhir-healthy-pregnancy by @Edmara.Francisco FemTech Reminder by @KATSIARYNA.Shaustruk FHIR Questionnaires by @Yuri.Gomes Contest-FHIR by @Lucas.Enard2487 ➡️ Voting is here. Community Nomination, Top 5 Pregnancy Symptoms Tracker by @José.Pereira FHIR Questionnaires by @Yuri.Gomes fhir-healthy-pregnancy by @Edmara.Francisco FemTech Reminder by @KATSIARYNA.Shaustruk Contest-FHIR by @Lucas.Enard2487 ➡️ Voting is here. Support the application you like! Devs! Here are the results after two days of voting! Expert Nomination, Top 5 Pregnancy Symptoms Tracker by @José Roberto Pereira fhir-healthy-pregnancy by @Edmara Francisco FemTech Reminder by @Katsiaryna Shaustruk Beat Savior by @Jan.Skála Contest-FHIR by @Lucas Enard ➡️ Voting is here. Community Nomination, Top 5 Pregnancy Symptoms Tracker by @José Roberto Pereira fhir-healthy-pregnancy by @Edmara Francisco FemTech Reminder by @Katsiaryna Shaustruk Contest-FHIR by @Lucas Enard Beat Savior by @Jan.Skála ➡️ Voting is here. Hi Developers! At the moment we can see the next results of the voting: Expert Nomination, Top 5 FemTech Reminder by @Katsiaryna Shaustruk Pregnancy Symptoms Tracker by @José Roberto Pereira fhir-healthy-pregnancy by @Edmara Francisco iris-fhir-app by @Oliver.Wilms NeuraHeart by @Grzegorz.Koperwas ➡️ Voting is here. Community Nomination, Top 5 Pregnancy Symptoms Tracker by @José Roberto Pereira FemTech Reminder by @Katsiaryna Shaustruk fhir-healthy-pregnancy by @Edmara Francisco FHIR Questionnaires by @Yuri.Gomes iris-fhir-app by @Oliver.Wilms ➡️ Voting is here. Support participants with your votes! Developers! Last call!Only a few hours left to the end of voting! Cast your votes for applications you like!

InterSystems announces its sixth preview, as part of the developer preview program for the 2023.2 release. This release will include InterSystems IRIS and InterSystems IRIS for Health. Highlights Many updates and enhancements have been added in 2023.2 and there are also brand-new capabilities, such as Time-Aware Modeling, and enhancements of Foreign Tables (but still as an experimental feature). Note that some of these features or improvements may not be available in this current developer preview. Another important topic is the removal of the Private Web Server (PWS) from the installers. This feature has been announced since last year and will be removed from InterSystems installers, but they are still in this first preview. See this note in the documentation. --> If you are interested to try the installers without the PWS, please enroll in its EAP using this form, selecting the option "NoPWS". Additional information related to this EAP can be found here. Future preview releases are expected to be updated biweekly and we will add features as they are ready. Please share your feedback through the Developer Community so we can build a better product together. Initial documentation can be found at these links below. They will be updated over the next few weeks until launch is officially announced (General Availability - GA): InterSystems IRIS InterSystems IRIS for Health Availability and Package Information As usual, Continuous Delivery (CD) releases come with classic installation packages for all supported platforms, as well as container images in Docker container format. For a complete list, refer to the Supported Platforms document. Installation packages and preview keys are available from the WRC's preview download site or through the evaluation services website (use the flag "Show Preview Software" to get access to the 2023.2). Container images for both Enterprise and Community Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the new InterSystems Container Registry web interface. For additional information about docker commands, please see this post: Announcing the InterSystems Container Registry web user interface. The build number for this developer preview is 2023.2.0.214.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.

Hibernate is the most popular framework to do ORM (Object Relational Mapping) projects. With Hibernate a software can use the main DBMS in the market, including the capability to change the database vendor any time, without source code impact. This is possible because the Hibernate supports dialects. Each database product has a different dialect that can be assigned into a configuration file. So, if a software is using Oracle and is looking to evolve to InterSystems IRIS, just change the configuration file with connection and dialect information. If your software needs to be prepared to use database indicated by your client, the Hibernate is the solution to you. Is there any InterSystems IRIS dialect for the new Hibernate 6? Currently is not any official dialect to use IRIS with the new Hibernate 6. To resolve this issue, Dmitry Maslennikov proposed an idea in the excellent Ideas Portal (https://ideas.intersystems.com/ideas/DPI-I-372) and I implemented it.If you do this tutorial, you will see the idea and this new dialect of IRIS in action and working. What you need to do this tutorial To do this tutorial you need:1. An IRIS instance running (if you don’t have one, you can get it on https://openexchange.intersystems.com/package/ObjectScript).2. Spring Tools installed (download it on https://spring.io/tools). Choose Eclipse version for this tutorial.3. Java JDK version 17 (download it on https://jdk.java.net/archive/). Choose Java 17 for this tutorial.4. All source code for this tutorial: https://github.com/yurimarx/iris-java-tools/tree/main/springboot-sample. Tutorial steps 1. Open the Spring Tool Suite (STS) and choose a valid workspace path (any folder) and click Launch: 2. Click the Create new Spring Starter Project link: 3. This wizard will create a new Spring project. Fill the fields with these values:• Service URL: https://start.spring.io• Type: Maven (it is a package manager like the NPM, ZPM or IPM)• Packaging: Jar (type of executable for the compiled project)• Java Version: 17 or 20 (for this tutorial I selected version 17)• Language: Java• Group: com.tutorial (domain of the project for Maven)• Artifact: iris-tutorial (name of the project for Maven)• Version: 0.0.1-SNAPSHOT (version of the project for Maven)• Description: IRIS Tutorial• Package: com.tutorial.iris (root package for the project) 4. Click Next.5. Choose the following dependencies for your project: 6. Click Finish to create your project.7. Open your pom.xml file and include 2 new dependencies (for IRIS dialect and for IRIS JDBC driver) and 1 repository (necessary because the InterSystems IRIS JDBC driver is not published into a public maven repository). <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>3.1.1</version> <relativePath /> <!-- lookup parent from repository --> </parent> <groupId>com.tutorial</groupId> <artifactId>tutorial-dialect</artifactId> <version>0.0.1-SNAPSHOT</version> <name>tutorial-dialect</name> <description>Tutorial for IRIS Hibernate 6 Dialect</description> <properties> <java.version>17</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-rest</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-hateoas</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-rest-hal-explorer</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <scope>runtime</scope> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-configuration-processor</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>io.github.yurimarx</groupId> <artifactId>hibernateirisdialect</artifactId> <version>1.1.0</version> </dependency> <dependency> <groupId>com.intersystems</groupId> <artifactId>intersystems-jdbc</artifactId> <version>3.7.1</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> <repositories> <repository> <id>InterSystems IRIS DC Git Repository</id> <url> https://github.com/intersystems-community/iris-driver-distribution/blob/main/JDBC/JDK18</url> <snapshots> <enabled>true</enabled> <updatePolicy>always</updatePolicy> </snapshots> </repository> </repositories> </project> 8. Go to the application.properties file (src > main > java > resources folder) and set connection and dialect properties with these values: spring.datasource.username=_SYSTEM spring.datasource.url=jdbc:IRIS://localhost:1972/USER spring.datasource.password=SYS spring.jpa.properties.hibernate.default_schema=Example spring.jpa.hibernate.ddl-auto=update spring.datasource.driver-class-name=com.intersystems.jdbc.IRISDriver spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults = false spring.jpa.database-platform=io.github.yurimarx.hibernateirisdialect.InterSystemsIRISDialect spring.jpa.show-sql=true spring.jpa.properties.hibernate.format_sql=true 9. Create a new persistent class (click right button on project > New > Class): 10. Fill the following fields to create the class:• Package: com.tutorial.iris.model• Name: Product 11. Click Finish to create the class.12. Develop the Product persistent class (class with values persisted in a SQL table) with this source code: package com.tutorial.dialect.model; import java.util.Date; import com.fasterxml.jackson.annotation.JsonFormat; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.GeneratedValue; import jakarta.persistence.GenerationType; import jakarta.persistence.Id; import jakarta.persistence.Table; import jakarta.persistence.Temporal; import jakarta.persistence.TemporalType; @Entity @Table(name = "Product") public class Product { @Id @GeneratedValue (strategy = GenerationType.IDENTITY) private Long id; private String name; private String description; private Double height; private Double width; private Double weight; @Column(name="releasedate") @Temporal(TemporalType.DATE) @JsonFormat(pattern = "yyyy-MM-dd") private Date releaseDate; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } public Double getHeight() { return height; } public void setHeight(Double height) { this.height = height; } public Double getWidth() { return width; } public void setWidth(Double width) { this.width = width; } public Double getWeight() { return weight; } public void setWeight(Double weight) { this.weight = weight; } public Date getReleaseDate() { return releaseDate; } public void setReleaseDate(Date releaseDate) { this.releaseDate = releaseDate; } } 13. Create an Interface repository for CRUD operations to the Product class (click right the project > New > Interface): 14. Fill the values for the interface and click Finish:• Package: com.tutorial.iris.repository• Name: ProductRepository 15. Click Finish to create the interface.16. Develop the ProductRepository (a CRUD repository implements save, delete, find, find one and update functions) Interface (src > main > java > com > tutorial > dialect > repository folder ) with this source code: package com.tutorial.dialect.repository; import org.springframework.data.repository.CrudRepository; import org.springframework.stereotype.Repository; import com.tutorial.dialect.model.Product; @Repository public interface ProductRepository extends CrudRepository<Product, Long> { } 17. Now, using the HAL browser from Springboot, is possible test CRUD functions in a web screen.18. Be sure to run an IRIS instance on localhost, port 1972 with user _SYSTEM and password SYS (or change the application.properties for other connections values).19. Run the application (click right the project > Run As > Spring boot app).20. On the console you can see the log indicating the application start: 21. Go to your browser and type http://localhost:8080. See the HAL browser: 22. Click plus button for products endpoint to create a new product: 23. Fill the following values to create a new product and click Go button to confirm: 24. A new product was persisted: Check the new row on IRIS (table product on USER namespace) Test other operations, check in the database and enjoy! I would like thanks @Dmitry.Maslennikov for your advanced support and for help me to improve this new Dialect Great initiative, @Yuri.Gomes ! Could you please publish the repo on OEX too? I published on OEX: https://openexchange.intersystems.com/package/IRIS-Hibernate-Dialect thank you, @Yuri.Gomes ! Thank you @Yuri.Gomes for this great job! Thanks guys Hi @Yuri.Gomes, Your video is available on InterSystems Developers YouTube channel: ⏯️ Using the new InterSystems IRIS Hibernate 6 Dialect for a Springboot Project Please enjoy! Great! Thanks

InterSystems announces its seventh preview, as part of the developer preview program for the 2023.2 release. This release will include InterSystems IRIS and InterSystems IRIS for Health. Discontinuation of the Private Web Server (PWS) A major topic in this release is the discontinuation of the Private Web Server (PWS) from the installers. This feature has been announced since last year and it's removed from InterSystems installers, starting with this developer preview. See this note in the documentation. Additional information related to this topic can be found here. --> If you are facing any issues and would like to get in touch with Product Management, or would like to provide your feedback, please email: NoPWS@InterSystems.com. Highlights Many updates and enhancements have been added in 2023.2 and there are also brand-new capabilities, such as Time-Aware Modeling, and enhancements of Foreign Tables (but still as an experimental feature). Initial documentation can be found at these links below. They will be updated over the next few weeks until launch is officially announced (General Availability - GA): InterSystems IRIS InterSystems IRIS for Health Availability and Package Information As usual, Continuous Delivery (CD) releases come with classic installation packages for all supported platforms, as well as container images in Docker container format. For a complete list, refer to the Supported Platforms document. Installation packages and preview keys are available from the WRC's preview download site or through the evaluation services website (use the flag "Show Preview Software" to get access to the 2023.2). Container images for both Enterprise and Community Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the new InterSystems Container Registry web interface. For additional information about docker commands, please see this post: Announcing the InterSystems Container Registry web user interface. The build number for this developer preview is 2023.2.0.221.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. I confirmed that the Community Edition containers (at least, the one I checked) still include a PWS 👍 I have a problem installing this version. Microsoft Defender 365 has detected a security threath in studio.cab : 'Bearfoos' malware. Maybe a false positive ? Developer preview license keys are expired I'd scan file with VirusTotal, or alternatives @John.Murray - Yes, Community Editions still have the PWS. The discontinuation affects kits for production environments, without the "Community" names. @John Murray - Yes, Community Editions still have the PWS. The discontinuation affects kits for production environments, without the "Community" names. @Dmitry.Maslennikov - thank you for bringing this to our attention. We're working on refreshing the keys now New keys are posted. Sorry for any inconvenience. Thank you! Just a week for a preview license? @Dmitry.Maslennikov - as GA is eminent the guys were set to expire post-GA, but Product Management decided that this really wasn't necessary so next time it will have a longer expiration even if GA is right around the corner. Thanks for raising the question!

Hey Developers, Watch this video to learn how UC Davis Health uses InterSystems API Manager to satisfy business-partner demand for access to both custom and FHIR APIs: ⏯ How UC Davis Health Uses InterSystems API Manager @ Global Summit 2023 🗣 Presenter: @Carl.Campbell4240, Senior Integration Engineer, UC Davis Health Subscribe to our YouTube channel InterSystems Developers to stay tuned!

Hi folks! Just want to introduce you a new util to import CSV into IRIS - csvgenpy! Install USER>zpm "install csvgenpy" Use: do ##class(shvarov.csvgenpy.csv).Generate("file or url","table","schema") Example: USER>do ##class(shvarov.csvgenpy.csv).Generate("https://raw.githubusercontent.com/datasciencedojo/datasets/master/titanic.csv","titanic","data") This will create table and class data.titanic in IRIS and will load the data. you can proof it with: USER>:sql [SQL]USER>>select * from data.titanic [SQL]USER>>select * from data.titanic 1. select * from data.titanic passengerid survived pclass name sex age sibsp parch ticket fare cabin embarked 1 0 3 Braund, Mr. Owen Harris male 22 1 0 A/5 21171 7.25 S 2 1 1 Cumings, Mrs. John Bradley (Florence Briggs Thayer) female 38 1 0 PC 17599 71.283299999999996998 C85 C 3 1 3 Heikkinen, Miss. Laina female 26 0 0 STON/O2. 3101282 7.9249999999999998223 S ... So that's it! Basically it does the same thing as csvgen does, but uses python library sqlalchemy which works because of embedded python and sqlalchemy-iris by @Dmitry.Maslennikov P.S. csvgenpy can import some "complicated" for csvgen csv as this one. Basically it can import any kind of csv. Feedback and Pull requests are very welcome!

InterSystems announces its third preview, as part of the developer preview program for the 2023.2 release. This release will include InterSystems IRIS and InterSystems IRIS for Health. Highlights Many updates and enhancements have been added in 2023.2 and there are also brand-new capabilities, such as Time-Aware Modeling, enhancements of Foreign Tables, and the ability to use Ready-Only Federated Tables. Note that some of these features or improvements may not be available in this current developer preview. Another important topic is the removal of the Private Web Server (PWS) from the installers. This feature has been announced since last year and will be removed from InterSystems installers, but they are still in this first preview. See this note in the documentation. --> If you are interested to try the installers without the PWS, please enroll in its EAP using this form, selecting the option "NoPWS". Additional information related to this EAP can be found here. Future preview releases are expected to be updated biweekly and we will add features as they are ready. Please share your feedback through the Developer Community so we can build a better product together. Initial documentation can be found at these links below. They will be updated over the next few weeks until launch is officially announced (General Availability - GA): InterSystems IRIS InterSystems IRIS for Health Availability and Package Information As usual, Continuous Delivery (CD) releases come with classic installation packages for all supported platforms, as well as container images in Docker container format. For a complete list, refer to the Supported Platforms document. Installation packages and preview keys are available from the WRC's preview download site or through the evaluation services website (use the flag "Show Preview Software" to get access to the 2023.2). Container images for both Enterprise and Community Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the new InterSystems Container Registry web interface. For additional information about docker commands, please see this post: Announcing the InterSystems Container Registry web user interface. The build number for this developer preview is 2023.2.0.202.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.

InterSystems announces its second preview, as part of the developer preview program for the 2023.2 release. This release will include InterSystems IRIS and InterSystems IRIS for Health. Highlights Many updates and enhancements have been added in 2023.2 and there are also brand-new capabilities, such as Time-Aware Modeling, enhancements of Foreign Tables, and the ability to use Ready-Only Federated Tables. Note that some of these features or improvements may not be available in this current developer preview. Another important topic is the removal of the Private Web Server (PWS) from the installers. This feature has been announced since last year and will be removed from InterSystems installers, but they are still in this first preview. See this note in the documentation. --> If you are interested to try the installers without the PWS, please enroll in its EAP using this form, selecting the option "NoPWS". Additional information related to this EAP can be found here. Future preview releases are expected to be updated biweekly and we will add features as they are ready. Please share your feedback through the Developer Community so we can build a better product together. Initial documentation can be found at these links below. They will be updated over the next few weeks until launch is officially announced (General Availability - GA): InterSystems IRIS InterSystems IRIS for Health Availability and Package Information As usual, Continuous Delivery (CD) releases come with classic installation packages for all supported platforms, as well as container images in Docker container format. For a complete list, refer to the Supported Platforms document. Installation packages and preview keys are available from the WRC's preview download site or through the evaluation services website (use the flag "Show Preview Software" to get access to the 2023.2). Container images for both Enterprise and Community Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the new InterSystems Container Registry web interface. For additional information about docker commands, please see this post: Announcing the InterSystems Container Registry web user interface. The build number for this developer preview is 2023.2.0.201.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. What happened to ARM64 images again? Hi Dmitry. There was an issue with these images and we decided to not publish them. We're going to publish in the next drop, during next week.

Hi Community, We're pleased to invite you to the upcoming webinar in Hebrew: 👉 Introducing VS Code, and Moving from Studio in Hebrew 👈 🗓️ Date & time: July 25th, 3:00 PM IDT 🗣️ Speaker: @Tani.Frankel, Sales Engineer Manager In this session, we will review using VS Code for InterSystems-based development. It is aimed at beginners of VS Code, but will also cover some areas that might be beneficial for users who are already using VS Code. We will also cover some topics relevant to people moving from InterSystems Studio to VS Code. The session is relevant for users of Caché / Ensemble / InterSystems IRIS Data Platform / InterSystems IRIS for Health / HealthShare Health Connect. ➡️ Register today and enjoy! >> ⚠️ Webinar password: ewE7mXWXr52 (39376999 from phones and video systems) Hey Community, The recording of this webinar is already available on DC YouTube: ⏯️ Introducing VS Code, and Moving from InterSystems Studio Enjoy!

Be in touch with InterSystems and receive alerts, advisories and product news quickly. The process is really simple: Click in this link: https://www.intersystems.com/support/product-alerts-advisories/ Fill in the form with your contact information and You're all set! As you can see, it takes less than a minute to keep informed about the news!

Here're the technology bonuses for the InterSystems IRIS Cloud SQL and IntegratedML Contest 2023 that will give you extra points in the voting: IntegratedML usage Online Demo Article on Developer Community The second article on Developer Community Video on YouTube First Time Contribution Community Idea Implementation IRIS Cloud SQL Survey See the details below. IntegratedML usage - 5 points Use IntegratedML SQL extension of IRIS Cloud SQL and collect 5 extra bonus points. Online Demo of your project - 2 pointsCollect 3 more bonus points if you provision your project to the cloud as an online demo. You can do it on your own or you can use this template - here is an Example. Here is the video on how to use it. Article on Developer Community - 2 points Post an article on Developer Community that describes the features of your project. Collect 2 points for each article. Translations to different languages work too. The Second article on Developer Community - 1 point You can collect one more bonus point for the second article or the translation regarding the application. The 3rd and more will not bring more points but the attention will all be yours. Video on YouTube - 3 points Make the Youtube video that demonstrates your product in action and collect 3 bonus points per each. Examples. First Time Contribution - 3 points Collect 3 bonus points if you participate in InterSystems Open Exchange contests for the first time! Community Idea Implementation - 3 points You can get 3 extra bonus points if the dev tool implements one of the ideas listed as Community Opportunity on the InterSystems Idea portal. IRIS Cloud SQL Survey - 2 points Please complete a survey with your feedback on your experience with InterSystems IRIS Cloud SQL and collect 2 bonus points! You should receive the survey on our email as a participant. If not please raise the question here on in discord. The list of bonuses is subject to change. Stay tuned! Good luck with the competition! Hello, I have written two articles and I will write one more. I also deployed online demo for audit-consolidator. Thank you We added IRIS Cloud SQL survey bonus! Don't forget to collect one!

Hi Community, It's voting time! Cast your votes for the best applications in our InterSystems IRIS Cloud SQL and IntegratedML Contest: 🔥 VOTE FOR THE BEST APPS 🔥 How to vote? Details below. Experts nomination: InterSystems experienced jury will choose the best apps to nominate the prizes in the Experts Nomination. Please welcome our experts: ⭐️ @akoblov, Support Specialist⭐️ @Guillaume.Rongier7183, Sales Engineer⭐️ @Eduard.Lebedyuk, Senior Cloud Engineer⭐️ @Steve.Pisani, Senior Solution Architect⭐️ @Timothy.Leavitt, Development Manager⭐️ @Evgeny.Shvarov, Developer Ecosystem Manager⭐️ @Dean.Andrews2971, Head of Developer Relations⭐️ @Alex.Woodhead, Senior Systems Developer⭐️ @Andreas.Dieckow , Principal Product Manager⭐️ @Aya.Heshmat, Product Specialist⭐️ @Benjamin.DeBoe, Product Manager⭐️ @Robert.Kuszewski, Product Manager⭐️ @Carmen.Logue , Product Manager⭐️ @Jeffrey.Fried, Director of Product Management⭐️ @Luca.Ravazzolo, Product Manager⭐️ @Raj.Singh5479, Product Manager⭐️ @Patrick.Jamieson3621, Product Manager⭐️ @Stefan.Wittmann, Product Manager⭐️ @Steven.LeBlanc, Product Specialist⭐️ @tomd, Product Specialist Community nomination: For each user, a higher score is selected from two categories below: 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 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 Blind vote! The number of votes for each app will be hidden from everyone. Once a day we will publish the leaderboard in the comments to this post. The order of projects on the contest page will be as follows: the earlier an application was submitted to the competition, the higher it will be on the list. P.S. Don't forget to subscribe to this post (click on the bell icon) to be notified of new comments. 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! Support the application you like! Note: 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! Since the beginning of the voting we have the results: Expert Nomination, Top 5 superset-iris by @Dmitry.Maslennikov Sheep’s Galaxy by @Maria.Gladkova iris-mlm-explainer by @Muhammad.Waseem IntegratedML-IRIS-Cloud-Height-prediction by @珊珊.喻 Customer churn predictor by @Oleh.Dontsov ➡️ Voting is here. Community Nomination, Top 5 superset-iris by @Dmitry.Maslennikov Sheep’s Galaxy by @Maria.Gladkova iris-mlm-explainer by @Muhammad.Waseem IntegratedML-IRIS-Cloud-Height-prediction by @珊珊.喻 Customer churn predictor by @Oleh.Dontsov ➡️ Voting is here. So, the voting continues. Please support the application you like! Devs! Here are the top 5 for now: Expert Nomination, Top 5 superset-iris by @Dmitry Maslennikov Sheep’s Galaxy by @Maria Gladkova Customer churn predictor by @Oleh Dontsov audit-consolidator by @Oliver.Wilms iris-mlm-explainer by @Muhammad Waseem ➡️ Voting is here. Community Nomination, Top 5 superset-iris by @Dmitry Maslennikov IntegratedML-IRIS-Cloud-Height-prediction by @Shanshan Yu Sheep’s Galaxy by @Maria Gladkova iris-mlm-explainer by @Muhammad Waseem AI text detection by @Oleh Dontsov ➡️ Voting is here. Experts, we are waiting for your votes! 🔥 Support our participants with your votes! Hi Developers! At the moment we can see the next results of the voting: Expert Nomination, Top 5 Sheep’s Galaxy by @Maria Gladkova superset-iris by @Dmitry Maslennikov AI text detection by @Oleh Dontsov iris-mlm-explainer by @Muhammad Waseem Customer churn predictor by @Oleh Dontsov ➡️ Voting is here. Community Nomination, Top 5 Sheep’s Galaxy by @Maria Gladkova superset-iris by @Dmitry Maslennikov IntegratedML-IRIS-Cloud-Height-prediction by @Shanshan Yu AI text detection by @Oleh Dontsov iris-mlm-explainer by @Muhammad Waseem ➡️ Voting is here. Hi, Dev's! And here're the results at the moment: Expert Nomination, Top 5 Sheep’s Galaxy by @Maria Gladkova AI text detection by @Oleh Dontsov superset-iris by @Dmitry Maslennikov Customer churn predictor by @Oleh Dontsov iris-mlm-explainer by @Muhammad Waseem ➡️ Voting is here. Community Nomination, Top 5 Sheep’s Galaxy by @Maria Gladkova superset-iris by @Dmitry Maslennikov IntegratedML-IRIS-Cloud-Height-prediction by @Shanshan Yu AI text detection by @Oleh Dontsov Customer churn predictor by @Oleh Dontsov ➡️ Voting is here. Developers, only two days left to the end of the voting!Cast your votes for the application you like! Last day of voting! ⌛ Please check out the Contest Board.Our contestants need your votes! 📢

Hi Developers, Often we create and edit InterSystems IRIS Interoperability solutions via a set of UI tools that is provided with IRIS. But it is sometimes difficult to setup the development environment to handle changes we make in the UI to source control. This video illustrates how git-source-control helps with source control Interoperability components while changing it in the UI. ⏯ Git Source Control for InterSystems IRIS Interoperability with Docker and VSCode Add these two lines in your iris.script during docker build: zpm "install git-source-control" do ##class(%Studio.SourceControl.Interface).SourceControlClassSet("SourceControl.Git.Extension") And Interoperability UI components will start working with git. Example application.