There are several ways of classifying cryptographic algorithms: 1) Secret Key Cryptography (SKC) - Uses a single key for both encryption and decryption. It is also called symmetric encryption. Primarily, it was used for privacy and confidentiality; 2) Public Key Cryptography (PKC) - Uses one key for encryption and another one for decryption. It is also called asymmetric encryption. Initially, it was utilised for authentication, non-repudiation, and key exchange; 3) Hash Functions - Uses a mathematical transformation to irreversibly "encrypt" information, providing a digital fingerprint.
This is the fourth part of the series of articles on migrating from the main databases on the market to InterSystems IRIS. In this part, the procedures for migrating from Microsoft SQL Server will be detailed. As described in previous articles, there are currently a few options to do the migration, but the two most popular options include the use of DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway. The first one will be demonstrated in this article, and the second one in an excellent article by Robert Cemper, DB Migration using SQLgateway (https://community.
This is the third part of the series of articles on migrating from the main databases on the market to InterSystems IRIS. In this part, the procedures for migrating from DB2 will be detailed.As described in previous articles, there are currently a few options to do the migration. However, the two most popular options include the usage of DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway. The first one will be demonstrated in this article, and the second one is presented in an excellent article by Robert Cemper, DB Migration using SQLgateway (https://community.
Hi Community,
Imagine enabling your application to read text to your customer? This is now possible with the new IRIS feature, Embedded Python. With this new functionality IRIS can natively run any open source or commercial Python libraries natively. gTTS (https://pypi.org/project/gTTS/) is a free library that transforms text into audio using the Google Translate service.
How to
Just pass the text by parameter and gTTS returns an mp3 file with the text transformed into audio. That is, your application can play the audio of any text! See how to do it:
1. Go to https://openexchange.intersystems.
.png)
If your REST API need return a file to the client download, this is the source code that you could write (P.S.: extracted from the question https://community.intersystems.com/post/download-file-rest and its responses):
Set%response.ContentType="image/jpeg"
Do%response.SetHeader("Content-Disposition","attachment;filename=""test.jpg""")
Set%response.NoCharSetConvert=1
Set%response.Headers("Access-Control-Allow-Origin")="*"
Setstream=##class(%Stream.FileBinary).%New()
Setsc=stream.LinkToFile("/opt/irisbuild/output/test.jpg")
Dostream.OutputToDevice()
SettSC=$$$OK
This article is a follow-up to the previous one on how to migrate from popular databases (like PostgreSQL and MySQL) to IRIS.
We will use the same procedures utilized to migrate from PostgreSQL. However, you will see that it is even easier since the data types in MySQL are very similar to IRIS. That is why we will not need to create transformation rules in the columns.
Get the sample data to the migration process
In GitHub it is possible to download a docker-compose project to build and run 2 databases:
- Source Database: MySQL database Docker instance with a sample database.
From IRIS 2021.2 is possible write Class Methods using the Python Language. I used this new feature to detect persons and objects into images, using ImageAI (https://github.com/OlafenwaMoses/ImageAI). The ImageAI creator defines it as: "An open-source python library built to empower developers to build applications and systems with self-contained Deep Learning and Computer Vision capabilities using simple and few lines of code." In this article you will learn how to apply AI Computer Vision to detect object and persons inside images.
If you need create a upload REST API with IRIS is very simple. Do these procedures:
From Postman client you send a file
.png)
P.S.: It is a multipart form with a file type using "file" in the name. The request type is form/multipart. See the http request:
POST /image-analyzer/postFile HTTP/1.1 Host: localhost:52773 Content-Length: 213 Content-Type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW ----WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="file"; filename="/C:/Users/yurim/OneDrive/Imagens/salesschema.png" Content-Type: image/png (data) ----WebKitFormBoundary7MA4YWxkTrZu0gW
Sometimes it is necessary to transfer or migrate data and data schema from Postgres to IRIS. There are currently a few options for doing this, but the two most popular options are using DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway. The first will be demonstrated in this article and the second is presented in an excellent article by Robert Cemper, DB Migration using SQLgateway (https://community.intersystems.
@Robert Cemper is the most active and widely read member of the community (Best Seller!). So nothing better than learning InterSystems technologies from over 100 articles by him. I curated the articles, selecting the best ones by subject:
Articles about SQL
DB Migration using SQLgateway DB migrations to IRIS using SQLgateways.
Intersystems IRIS supports SMB protocol to connect and read files from remote folders (//foldername)?
Hi community,
Prediction is a critical to the Maternal healthcare. The Health Dataset Application (https://openexchange.intersystems.com/package/Health-Dataset) has 10 real health datasets to predict the most important diseases and health problems, including Maternal Risk.
This article detail the steps to predict Maternal Risk using the InterSystems IRIS IntegratedML. This is a technology of InterSystems to do predictions using SQL Commnands! Great!
Follow these steps:
- Clone/git pull the repo into any local directory
$ git clone https://github.com/yurimarx/predict-maternal-risk.git
The JSON is a data document free of types and validation rules. However, in some scenarios it is important that the JSON document has type and business rules validation, especially in interoperability scenarios. This article demonstrates how you can leverage a market-defined JSONSchema technology that is open for everyone to use and do advanced validations.
About JSON
According to json.org, “JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate.
.png)
The PDF version (when you click article title, the link to the pdf it is showed) allows you click and go to the article. Enjoy!
.png)
Hi Community,
In a hard work of data curation and data quality, the Health Dataset application deploy to you the above datasets.
These datasets can be used in your ML applications/models, AutoML and analytics projects. See more details here:
Installation
- Clone/git pull the repo into any local directory
$ git clone https://github.com/yurimarx/automl-heart.git
The Health Dataset application now has Six real healthcare datasets (and more in this week!) to you!
- Diabetes dataset: data to predict diabetes diagnosis
- Heart Disease dataset: data to predict heart disease
- Kidney Disease dataset: data to predict kidney disease
- Breast Cancer dataset: data to predict breast cancer
- Maternal Risk dataset (NEW): data to predict maternal risk level
- Hospital Mortality dataset (NEW): data to predict hospital mortality
Get it now: https://openexchange.intersystems.com/package/Health-Dataset
According to the WHO, The top global causes of death, in order of total number of lives lost, are associated with three broad topics (source: https://www.who.int/news-room/fact-sheets/detail/the-top-10-causes-of-death):
- Cardiovascular (ischaemic heart disease, stroke),
- Respiratory (chronic obstructive pulmonary disease, lower respiratory infections) and
- Neonatal conditions – which include birth asphyxia and birth trauma, neonatal sepsis and infections, and preterm birth complications.
What is the correct data type for decimal numbers precision 5?
I tried %Numeric with Scale 5, but not worked, see:
Classdc.data.health.BreastCancerExtends%Persistent[SqlRowIdPrivate]
{
ParameterScale=5;
///Mean of distances from center to points on the perimeter
PropertyradiusmeanAs%Numeric;
Is it possible to call java programs inside SQL statements, like the new LOAD Data, or is this just internal?
For me the best moments were:
1 - Global Masters WON the 2021 Influitive BAMMIE Award for Most Passionate Community
2 - Tech Article contests
3 - InterSystems Programming Contests
4 - 10,000+ DC members
5 - Partner directory and business services
6 - 500+ applications on OEX
7 - Open Virtual Summits
8 - Prizes from GM points
9 - Free online learning courses
10 - Discord channels
11 - Innovations from IRIS Data Platform
12 - Multilanguage communities, including portuguese, spanish and chinese community
13 - Advent of Code
I need iterate multiple times the same ResultSet. How can I do a rewind on it?
Currently IRIS only supports up to version 4.5 of .NET. Are there plans to support the latest versions, such as .NET 6 and also NET Core 3?
The InterSystems IRIS IntegratedML feature is used to get predictions and probabilities using the AutoML technique. The AutoML is a Machine Learning technology used to select the better Machine Learning algorithm/model to predict status, numbers and general results based in the past data (data used to train the AutoML model). You don't need a Data Scientist, because the AutoML it will test the most common Machine Learning algorithms and select the better algorithm to you, based in the data features analysed. See more here, in this article.
Creating REST API using InterSystems ObjectScript is very easy, but some recipes can help you into this process:
1) To create your REST API extends %CSP.REST and Go to System Administration > Security > Applications > Web Applications > Click the button Create New Web Application and set the Name, REST Dispatch Class with your package and classname and choose the Allowed Authetication Methods. See this example:
Edit Web Application
.png)
2) Configure your REST API using ZPM configuration. To do this follow this sample (watch the tag <CSPApplication>):
ZPM Code to Create REST API
<?
If a have a string " Happy new year " and I want to trim (remove blank spaces from the begin and the end, not other places into the string), what is the object script function to get "Happy new year"?
I would like to watch a webseminar about debug objectscript techniques into vscode to rest api, productions and embedded python, specially using docker instances and remote servers.
The InterSystems IRIS has a great audit system. It is responsible for auditing system events, but you can use it to audit your applications (great feature).
The audit system is based into event concept. The events can occur with IRIS or in an application. So, we have two type of events to the audit system:
1. System events: events occured into the InterSystems IRIS components (database, interoperability, analytics and core);
2.
How can I do to debug IRIS docker instance into VSCode?