#Contest

Hi all,
I try to build a little project for the dataset contest, you can find it here on github: Openflights dataset
My plan is to use just plain SQL. So I've made a few experiments with the new feature LOAD DATA.

Unfortunately all loads produce errors like:  
 Error: [SQLCODE: <-400>:<Fatal error occurred>]
[Error: <<UNDEFINED>zExecute+83^%sqlcq.OPENFLIGHTS.cls4.1 *%qparsets>]
[Location: <ServerLoop>]

The statements I use looks like this:

Hi developers!

We launched the datasets contest.

And one of the important questions that need to be covered is dataset licensing.

There are two general cases:

a) a dataset you take from another place in public Internet or private network/person.

b) a dataset you create by yourself or own for any other reason.

We decided to follow the principles and considerations that data.world site introduces for datasets' licensing.

Hey Community,

Welcome to the second InterSystems technical article writing competition! Write an article on any topic related to InterSystems technology:

🎄 InterSystems Tech Article Contest: Christmas Edition 🎄

Duration: November 25 – December 25, 2021

Prizes for everyone: Everyone who publishes an article on Dev Community during this period will receive a special prize pack!

Main Prizes: Apple AirPods Max / Oculus Quest 2 (VR Headset) / Amazon Kindle / Apple AirPods Pro / Raspberry Pi

Join our new contest and your content will be seen by over 55K monthly readers! Details below. 

Hi contestants!

We've introduced a set of bonuses for the projects for the Interoperability Contest 2021!

Here are projects that scored it:

Please apply with your comments here in the posts or in Discord.

Security wanted!

Welcome to the next InterSystems online programming competition: 

🏆 InterSystems Security Contest 🏆

Duration: November 15 - December 05, 2021

Prizes: $9,450 in prizes!

Hi Developers!

Here're the technology bonuses for the Security Contest 2021 that will give you extra points in the voting:

• Basic Authentication usage - 2
• Bearer/JWT Authentication usage - 3
• OAuth 2.0 usage - 5
• Authorization components usage - 2
• Auditing usage - 2
• Data Encryption usage - 2
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• Code Quality pass - 1
• Article on Developer Community - 2
• Video on YouTube - 3

See the details below.

Hey Developers, 

We invite you to take part in the European Healthcare Hackathon 2021 which will take place on November 19-21 2021. Participation is free, the deadline for applications to the ON-LINE track is prolonged until 15 NOV.

We will have an InterSystems challenge there: "Innovate with FHIR". Prize fund in InterSystems track:

🥇1st place: 1500 EUR
🥈2nd place: 1000 EUR
🥉3rd place: 500 EUR
And we prepared prizes for ALL participants of our challenge!
Read the details about our challenge under the pic :) Are you in? Let us know in the poll below!

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Interoperability contest!

Date & Time: Friday, October 29, 2021 – 12:00 EDT

What awaits you at this virtual meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

Hey Community,

We want to hear from you! Give us your feedback on the past InterSystems Interoperability programming contest! Please answer some questions to help us improve our contests.

👉 Quick survey: InterSystems Interoperability Contest Survey

Hey Developers,

It's time to announce the winners of the InterSystems Interoperability contest!

Thank you all for participating in our coding competition! And the winners are...

A storm of applause goes to these developers and their applications:

Hey Developers,

This week is a voting week for the InterSystems Interoperability contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote? Details below.

Hi Developers!

Here're the technology bonuses for the InterSystems Interoperability Contest 2021 that will give you extra points in the voting:

• Business Process BPL or Business Rule DTL Usage
• Custom Interoperability Adapter Usage
• Production EXtension(PEX) Java or .NET usage
• Workflow Engine usage
• Docker container usage
• ZPM Package deployment
• Online Demo
• Code Quality pass
• Article on Developer Community
• Video on YouTube

See the details below.

Hi contestants!

We've introduced a set of bonuses for the projects for the Interoperability Contest 2021!

Here are projects that scored it:

I work as an Integration Engineer for United States Department of Veterans Affairs (VA). I work on a Health Connect production which processes many RecordMap files. I do not fully understand RecordMaps and I wanted to develop an application for the Interoperability contest where I could learn more about working with RecordMaps. I browsed InterSystems documentation for inspiration on how to start. I was happy to find CSV Record Wizard. I had created a CSV file for my Analytics contest entry. I wanted to use it to test the CSV Record Wizard. It was not obvious how to use it. The dialogue in

Hey Developers,

Welcome to the next InterSystems online programming competition: 

🏆 InterSystems Interoperability Contest 🏆

Duration: October 04-24, 2021

Our prize pool increased to $9,450!

Hey Developers!

We're pleased to announce the next competition of creating open-source solutions using InterSystems IRIS or IRIS for Health! Please join:

⚡️ InterSystems Interoperability Contest ⚡️

Duration: November 2-22, 2020

Hi Community,

Join the upcoming InterSystems Interoperability Contest Kick-off Webinar dedicated to the Interoperability Contest.

In this webinar, you'll get an overview of the interoperability capabilities of InterSystems IRIS, and we'll show you how to use the PEX. Also, we’ll discuss and answer your questions on how to build interoperability solutions using InterSystems IRIS and IRIS for Health.

Date & Time: Monday, October 4 — 12:00 AM EDT

Speakers:  
🗣 @Stefan Wittmann, InterSystems Product Manager 
🗣 @Bob Kuszewski, InterSystems Product Manager 
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hey Community,

We want to hear from you! Give us your feedback on the past InterSystems Analytics programming contest! Please answer some questions to help us improve our contests.

👉 Quick survey: InterSystems Analytics Programming Contest Survey

Hey Developers,

The InterSystems Analytics programming contest is over. Thank you all for participating in our coding competition!

So it's time to announce the winners! 

A storm of applause goes to these developers and their applications:

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Analytics contest!

Date & Time: Friday, September 17, 2021 – 12:00 EDT

What awaits you at this virtual meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

Hello!

Want to get 5000 points on GlobalMasters?

I'm launching a bug bounty for a bug with which I've been struggling for the last 4 years. Have tried to resolve it many times, but no  dice - can't track it down.

Here's the issue.

To claim this bounty you need to:

1. Create a pull request with the code to fix the issue outlined here.
2. In the pull request OR in the issue OR in the commit message describe what's the reason for this bug and how your change fixes it.

First come first serve. Bounty would be paid only ONCE for a first working solution.

Challenge details are here.

I really love documentaries! Last weekend I was watching a Netflix documentary called This is Pop, because it was Analytics Contest time and I thought: Why not creating a pop song analytics with InterSystems Iris?

The first challenge was the database. I found on Data World project a CSV file with the Billboard hot 100 songs from 2000 to 2018, created by "Michael Tauberg" @typhon, that fits perfectly.

I was talking to @Henrique Dias and he gave me the idea of using Microsoft Power BI for good looking report with charts.

Which genres were most popular between 2000 and 2018?

Hey Developers,

This week is a voting week for the InterSystems Analytics contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote? Details below.

Hi Developers!

We had a set of technology bonuses for the InterSystems IRIS Analytics contest.

And here is how projects collected it:

Hey Developers,

Welcome to the next InterSystems online programming competition: 

🏆 InterSystems IRIS Analytics Contest 🏆

Duration: August 23 - September 12, 2021

Total prize: $8,750

Landing page: https://contest.intersystems.com

Hi Developers!

Here're the technology bonuses for the InterSystems Analytics contest that will give you extra points in the voting.

Adaptive Analytics (AtScale) Cubes usage - 4 points
InterSystems Adaptive Analytics provides the option to create and use AtScale cubes for analytics solutions.

You can use the AtScale server we set up for the contest (URL and credentials can be collected in the Discord Channel) to use cubes or create a new one and connect to your IRIS server via JDBC.

The visualization layer for your Analytics solution with AtScale can be crafted with Tableau, PowerBI, Excel, or Logi.

Documentation, AtScale documentation

Training

Hi Community,

We are pleased to invite all the developers to the upcoming InterSystems Analytics Contest Kick-off Webinar! The topic of this webinar is dedicated to the Analytics contest.

On this webinar, we’ll demo AtScale, InterSystems Reports (Logi), IRIS BI, IRIS NLP and answer the questions on how to develop, build, and deploy Analytics applications using InterSystems IRIS.

Date & Time: Monday, August 23 — 10:00 AM EDT

Speakers:  
🗣 @Carmen Logue, InterSystems Product Manager - Analytics and AI
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hey Developers, 

Are you ready for the new challenge? We're pleased to announce the first InterSystems technical article writing competition:

🏆 InterSystems Tech Article Contest 🏆

Write an article on any topic related to InterSystems technology from July 15 to August 15August 22 – extended!

Prizes for everyone: Everyone who publishes an article on DC during this period will receive a special prize pack!

Main Prize: Apple iPad

Join our new contest and your content will be seen by over 55K monthly readers! Details below. 

Hi developers!

How to build an analytics solution with InterSystems IRIS?

To begin with, let's agree on the points of what is the analytics solution - and this could be a very wide topic. Let's limit the set of solutions to those you can present in the Analytics contest.

There are three kinds of analytics solutions that we will review here: monitoring, interactive analytics, and reporting. 

Monitoring

The typical monitoring solution consists of an online dashboard with KPIs that are being actively updated.

The key use case is of monitoring is to visually observe the KPI of fresh data every moment to react in case of an emergency.

Interactive Analytics

This solution supposes a set of interactive dashboards with filters and drill-downs.

The key use case is to explore the data with filters and drill-downs making business decisions upon graph and table data visualization.

Reporting

Reporting solution provides a set of static (usually) reports in a form of HTML or pdf documents that deliver the data in graph and text form in a predesigned form and could be sent via email.

The typical use case of a reporting system is to obtain reports on a given period that will illustrate the status of the product, process, service, sales, etc that is crucial for the business.

How InterSystems products could be used to build such solutions? Let's discuss this below!

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems AI contest!

Date & Time: Friday, July 30, 2021 – 11:00 AM EDT

What awaits you at this Virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.