InterSystems Developer Community is a community of 18,622 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi! For the Opendataset contest I've build a docker container app stack that use InterSystems IRIS & Openflights Dataset in a container and second container with Apache Zeppelin. You can found details here: https://github.com/andreas5588/openflights_demo

With that you can query the Opendflights Dataset from Apache Zepplin with zero configuration. The containers are on hub.docker so you can use it very easily.

Open Exchange app
2 0
0 231

Hi everyone,

I want to talk about our project and use the dataset theme for this contest.

Our intention never was to be a data curator, especially because sometimes my precious data means a lot for me, but not for the rest of the world.

My Precious

We want to go a step further and empower the user to find the perfect dataset for their needs.

Our project is a bridge between the data science community and the developer's community using InterSystems IRIS to achieve this mission.

Open Exchange app
4 0
0 370
Article
· Jan 15, 2022 1m read
Your own webserver logfile analyser

Previously I had published The Article about the dataset from a real webserver, which can demonstrate how can activity and load of the Apache webserver depends on day of week, search engines indexing and some network noise.

Now I want to describe one useful function for most of webmasters and system administrators who are interested in obtaining of exactly information about visitors, hardware usage, and also about errors that gaing to their clients.

Here it is

Open Exchange app
5 0
0 262

With the release of InterSystems IRIS 2021.2 Preview and all-new LOAD DATA functionality dataset can by added with Objectscript Package Manager (ZPM)

Medical Datasets contains following 12 datasets. For dataset tables and data details please visit ONLINE DEMO by using SuperUser | SYS

ID Dataset Name Tables Licence
1 Synthetic Medical Data 11 Public Domain
2 Health Care Analytics - 1 8 Public Domain
3 Global Suicide Data 7 Public Domain
4 COVID-19 Polls1 7 CC-BY
5 Cancer Rates by U.S. State 2 Public Domain
6 Opioid Overdose Deaths 2 Public Domain
7 Heart Disease Prediction 1 Public Domain
8 Yellowpages medical services dataset 1 Public Domain
9 Hospital ratings 1 Public Domain
10 Heart Failure Prediction 1 (CC BY 4.0)
11 Diabetes Dataset 1 Public Domain
12 Chronic Kidney Disease 1 Public Domain

Open Exchange app
2 0
0 191

We have now released a new learning path to get you started with FHIR: Building Basic FHIR Integrations with InterSystems IRIS for Health. In this path, you'll learn the basics of FHIR, how to set up FHIR endpoints in InterSystems IRIS for Health, consume data into the FHIR repository and transform FHIR data, manage FHIR APIs with InterSystems API Manager, and query for FHIR resources using a client application.

2 0
0 284
Article
· Jan 14, 2022 1m read
Real Webserver Logs Dataset

I'm happy to share with the community a web server log dataset from our longtime customer, an operating company.

Their webserver operates on Apache webserver and contains data which can be useful to analyse a load and search engines activity.

After installing the project, you will get the data for a few months that can show a typical load and activity of clients, robots and also you can see how it depends on day of week, holidays and time of a day.

The Cube is also included in package.

Open Exchange app
2 0
0 353

II try to explore the new SQL LOAD DATA feature in SQL comparing it to SQL INSERT

I'm stuck at this point: INSERT INTO <table> (columns...) VALUES (.....)
allows having not just simple column references but also ALL Standard SQL FUNCTIONS (at least)
example:

INSERT INTO Test (ShortName,DOB) VALUES (SUBSTRING(Name,1,4),TO_DATE(displayDate,'MM-DD_YYY'))

This works perfectly.
BUT the same VALUE clause applied to LOAD DATA fails in various ways:

1 3
0 200
Hey Community,
Please check out the 2021 Annual Dev Community Article Digest with the most popular and commented articles. Thank you all for your contributions to the InterSystems Community in 2021!
General Stats
✓ 1,687 posts published in 2021:
– 234 articles
– 436 announcements
– 980 questions
– 37 discussions
✓ 2,451 members joined the Developer Community in 2021
✓ 8,930 posts published all time
✓ 10,287 members joined all time
6 7
0 351
Article
· Jan 13, 2022 2m read
Predict Maternal Health Risks

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:

Open Exchange app
4 0
1 272

Hi Developers,

It's time to announce the Winners for December 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in December 2021:

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabi

🥈 @Sergey Mikhailenko, Chief Specialist, AO Mosvodokanal, Russia

🥉 @YURI MARX GOMES, Software Architect, YM Services, Brazil

Learn more about the competition and our awesome winners below.

5 7
0 214
Announcement
· Jan 12, 2022
New Kubernetes Exercise!

Hi All! For those of you who attended experience labs at the 2021 Virtual Summit, you may recall that one of the lab sessions was around Kubernetes. We've now converted that lab to be fully on-demand. You can launch a small cluster of VMs and follow the exercise to manage your Kubernetes cluster, deploy InterSystems IRIS containers to it, and watch its self-healing nature when destroying a pod.

It's a great introduction to Kubernetes if you are interested! See here: Achieving High Availability with InterSystems IRIS and Kubernetes

3 0
1 225
Question
· Jan 12, 2022
Convert X12 to SDA/FHIR

Hi

We are embarking on a project that we are injesting raw EDI files 837's to start with into HS.

We have and inbound X12 adaptor to take in the raw *.edi file and we have an business process that is mostly pass thru. we have been unable to find any DTL to map X12 to SDA/FHIR ( similar to the ones that exist for HL7 , CDA,CCD). If anybody has done anything on this front,would appreciate any tips.

Santosh

0 0
0 450

Hey Developers,

You're very welcome to check the most-watched videos for 2021 on InterSystems Developers YouTube Channel:

Top 10 videos by views
№ Video Views
1 Active Directory Integration with LDAP 9 051
2 SMART on FHIR: The Basics 4 781
3 InterSystems Developer Ecosystem Services: Developer Community and Open Exchange 3 874
4 InterSystems API Manager: Gummy Bear Factories 3 866
5 Developing with FHIR - REST APIs 2 673
6 #VSummit21: "Who wrote this code? It makes no sense!” – the importance of software maintainability 2 383
7 Building Modern Web Applications 2034
8 Configuring a Web Server for IIS for Better Performance and Security 1992
9 ObjectScript with Visual Studio Code 1971
10 Building Health IT Apps with Artificial Intelligence 1963

3 0
0 230
Question
· Jan 8, 2022
SQL LOAD DATA date values

I have csv date file with date values like this "4/10/2021" for April 10, 2021. I defined a table with this property: Property TranDate As %Library.Date.

I capture error

[SQLCODE: <-104>:<Field validation failed in INSERT, or value failed to convert in DisplayToLogical or OdbcToLogical>] [Location: <ServerLoop>] [%msg: <Field 'dc_data_finance.transact.TranDate' (value '4/10/2021') failed validation Field ...

I do not really want to change TranDate to %String. How can I import "4/10/2021" into %Date property?

0 10
0 439