Keywords: Python, JDBC, SQL, IRIS, Jupyter Notebook, Pandas, Numpy, and Machine Learning 

1. Purpose

This is another 5-minute simple note on invoking the IRIS JDBC driver via Python 3 within i.e. a Jupyter Notebook, to read from and write data  into an IRIS database instance via SQL syntax, for demo purpose. 

Last year I touched on a brief note on Python binding into a Cache database (section 4.7) instance.

I am trying to configure IRIS using python. The first task I wanted to do it change the journal directory. I cannot figure out the right way to work with the Config.Journal class with python. I can get the text to query the current setting.

returnValue = dbnative.classMethodValue("Config.Journal","GetList")
print(returnValue )

But I don't see a straightforward way to parse the $List returned by GetList() I was hoping there was an easier way.

How do I

1. Query configuration parameters?

2. Set configuration parameters?

Using python?

The first full release of our iKnow open-source NLP library is now available on GitHub and PyPI! 

The iKnow engine has been available as an InterSystems embedded technology for almost 10 years and the core engine was published to open source earlier this year. Now, in the slipstream of Virtual Summit 2020, we're glad to announce the availability of v1.0, which adds all-Python access to the core engine, documentation and samples on the language model contents and a Jupyter demo notebook to get you started.

Hello there community, 

I am pleased to say that i have started building a product and I have chosen InterSystems technology to be used in it. 

But I have a confusion with regard to it. 

I actually have to come to a conclusion to whether to use CACHE or IRIS. 

I will be using a lot of data and also integrating it along with Python for DEEP and Machine Learning. 

Also I do not have an idea of how to get the licensed version of either of that. 

I would like to get hold of this and also would like to try out the free version of either Data Bases before moving on to large scale production.

Hey Developers,

New demo show by InterSystems Product Manager @Raj.Singh5479is already on InterSystems Developers YouTube: 

⏯ Develop a Python Flask app with InterSystems IRIS in 10 minutes

In below command a is storing our return value from Python Script, hello is our device, our python script is returning device type against passing a parameter, this parameter is a device :

w $zf(-100,"a='./DC hello'")

Please help us to fetch return value of method in variable "a" returning from Python in cache.

Thanks in advance, experts

I'm testing with an application I'm writing in python. But I noticed that the pythonbind3 library will only work on the same machine where the cache is running. Is there really such a dependency?

I'm trying to run the examples that are in the / dev / python / samples3 folder, but they only work if I set "LD_LIBRARY_PATH" with the path to the cache installation folder.

But... I have this error when LD_LIBRARY_PATH is empty:

[root@cache2018 samples3]# python CPTest2.py -user _SYSTEM -password xxxxxx Traceback (most recent call last): File "CPTest2.py", line 3, in import intersys.pythonbind3 File "/usr/local/lib64/python3.6/site-packages/pythonbind3-1.0-py3.6-linux-x86_64.egg/intersys/pythonbind3.py", line 1, in

i want to restrict certain IPs (ip for now and looking for more such parameters) from running my URL for security purposes...

i wanted to know how to access their ips and compare them with the list of restricted IPs, also if not IPs are there any other unique browser parameters which can be used for access control? and enhance security

This is the third post of a series explaining how to create an end-to-end Machine Learning system.

Training a Machine Learning Model

When you work with machine learning is common to hear this work: training. Do you what training mean in a ML Pipeline? Training could mean all the development process of a machine learning model OR the specific point in all development process that uses training data and results in a machine learning model.

Source

So Machine Learning Models are not equal Common Applications?

In the very last point it looks like a normal application.

This is my introduction to a series of posts explaining how to create an end-to-end Machine Learning system.

Starting with one problem

Our IRIS Development Community has several posts without tags or wrong tagged. As the posts keep growing the organization of each tag and the experience of any community member browsing the subjects tends to decrease.

First solutions in mind

We can think some usual solutions for this scenario, like:

• Take a volunteer to read all posts and fix the mistakes.
• Pay a company to fix all mistakes.
• Send an email to each post writer to review the texts from past.

Hi Developers,

Please welcome the new video, specially recorded by @José Pereira for the InterSystems IRIS AI Programming Contest: 

⏯ Monitoring your ML model with IntegratedML

This is the second post of a series explaining how to create an end-to-end Machine Learning system.

Exploring Data

The InterSystems IRIS already has what we need to explore the data: an SQL Engine! For people who used to explore data in csv or text files this could help to accelerate this step. Basically we explore all the data to understand the intersection (joins) which should help to create a dataset prepared to be used by a machine learning algorithm.

Hi Community,

Please welcome the new video, specially recorded by @Renato.Banzaifor the InterSystems IRIS AI Programming Contest: 

⏯ IRIS ML Suite Demo

Pyodbc supports calling stored procedure  , but if the IRIS Stored Procedure ROWSPEC has a column with datatype specified as %Date or %Time, Pyodbc fails to fetch it and throws this error.

"

pyodbc.Error: (' 2201', '[ 2201] [Cache ODBC][State :  22018 ][Native Code 22005]\r\nERROR #388: Unknown error, code 22005 (22005) (SQLGetData)')

"

on printing the cursor execute description, pyodbc reads the column as <int>.

and if the ROWSPEC datatype specification was removed, it fetches successfully.

i'm using the driver "InterSystems IRIS ODBC35"  2019.2.0.107

Hi Community!

We are pleased to invite all the developers to the upcoming  InterSystems AI Programming Contest Kick-Off Webinar! The topic of this webinar is dedicated to the InterSystems IRIS AI Programming Contest.

On this webinar, we will talk and demo how to use IntegratedML and PythonGateway to build AI solutions using InterSystems IRIS.

Date & Time: Monday, June 29 — 11:00 AM EDT

Speakers:  
🗣 @Thomas Dyar, Product Specialist - Machine Learning, InterSystems 
🗣 @Eduard Lebedyuk, Sales Engineer, InterSystems

Hi Developers,

Please welcome the new video, specially recorded by @Zhong.Lifor the InterSystems IRIS AI Programming Contest: 

⏯ IntegratedML-Template Demo

Hi developers!

We are starting InterSystems AI Programming Contest next week, and according to the rules, you can include some technology IRIS Features into your solutions, which will give you extra points in the voting.

Here are the technology bonuses for InterSystems AI Programming Contest!

1. IntegratedML usage - 2 expert vote points

IntegratedML is a new technology Introduced in InterSystems IRIS which you can use with InterSystems IRIS 2020.2 Advanced Analytics Preview release. IntegratedML:

• Gives users the ability to create, train, and deploy powerful models from simple SQL syntax without requiring data scientists.
• Wraps "best of breed" open source and proprietary "AutoML" frameworks including DataRobot.
• Focuses on easy deployment to IRIS, so you can easily add machine learning to your applications.

Learn more in IntegratedML Resource Guide.

You can use with IntegratedML template.

2. Python Gateway usage - 1 expert vote point

Python Gateway is an addon to InterSystems IRIS which gives you the way to use Python in InterSystems IRIS environment:

• Execute arbitrary Python code.
• Seamlessly transfer data from InterSystems IRIS into Python.
• Build intelligent Interoperability business processes with Python Interoperability Adapter.
• Save, examine, modify and restore Python context from InterSystems IRIS.

Learn more about Python Gateway.

You can use the Python Gateway template, which includes IntegratedML too.

3. Docker container - 1 expert vote point

The application gets a 'Docker container' bonus if it uses InterSystems IRIS  running in a docker container. 

Both templates, IntegratedML template and  Python Gateway template use docker so you can collect this bonus if you build your solution using these templates.

Or you can use any other Docker-based templates, published on Open Exchange.

Feel free to ask any questions about using the listed technologies.

Good luck in the competition!

Hey Developers,

New demo show by InterSystems Sales Engineer @Eduard Lebedyuk is already on InterSystems Developers YouTube:

⏯ PythonGateway-Template Demo

In 2017, Forbes published an article talking about API Economy (see: https://www.forbes.com/sites/louiscolumbus/2017/01/29/2017-is-quickly-becoming-the-year-of-the-api-economy/). This article was the trigger to popularize the use of API and API Management by large companies. The article published a maturity model. My understanding is that Intersystems IRIS allows you to reach the top of the pyramid with your current technologies. See the figure above.
For this it is important to combine % CSP.

Globals as a Graph Data Structure in Python

How to use the IRIS Native API + Python to see globals as a Graph Network Chart.

Iris Globals

Reading the documentation these topics are related to globals:

• A global consists of a set of nodes (in some cases, only one node), identified by subscripts.
• Each node can contain a value.
• ObjectScript includes functions to iterate through the nodes of a global and quickly access values.
• A global is automatically stored in the database. When you assign a value to a node of a global variable, the data is written immediately to the database.

Hi Community!

This week is a voting week for the InterSystems IRIS Native API Programming Contest! We have 8 applications — so you have a set of applications to choose from!

How to vote? This is easy: you will have one vote, and your vote goes either in Experts Nomination or in Community Nomination.

Hi everyone! If it doesn't bother you, could you help me teach my bots to talk?

Open my chatbot here: Help my chatbots to talk!

What? Aren't your chatbots smarts?

Smart isn't the best term for this scenario. They are trained but with little data! Most of chatbot solutions uses Machine Learning to create a way to talk with people and Machine Learning needs one important thing to performs well: DATA. 

How does it work?

A simple way to explain: imagine someone who has a brain but dont have any experience in his life he just born.

Hi Developers!

We are pleased to announce the next competition in creating open-source solutions using InterSystems IRIS Data Platform!

Please welcome the third InterSystems IRIS Online Programming Contest for Developers!

And the topic for this contest is InterSystems IRIS Native API.

The contest will last three weeks: May 18 – June 7, 2020. 

Creating a Chatbot with IRIS and Python

In this article I'm going to show how to integrate the InterSystems IRIS Database with Python to serve a Machine Learning Model of Natural Language Processing (NLP).

Why Python?

With a large adoption and use in the world, Python have a great community and a lot of accelerators | libraries to deploy any kind of application. If you are curious (https://www.python.org/about/apps/).

Iris Globals

As I start to learn about ^globals they became familiar to use as a fast way to ingest data in a out-of-box data model.

Making a Chart using Intersystems IRIS + Python

How to use the IRIS Native API in Python to access globals and plot some charts.

Why Python?

With a large adoption and use in the world, Python have a great community and a lot of accelerators | libraries to deploy any kind of application. If you are curious (https://www.python.org/about/apps/)

Why COVID-19 Data

As the pandemy evolves in the world a lot of information are being spreaded so I decided to create an application to audit those information.

Hi everyone! I was using the InterSystems Native API for Python and following the documentation I tried to use this method (https://irisdocs.intersystems.com/irislatest/csp/docbook/Python-Native/irisnative.iris.html#irisnative.iris.getAPIVersion after a while I realize that this method doesn't exist. Looking at the object I can see the method: irisnative.iris.getClientVersion which doesn't exist in documentation (and probably does the same thing)

I'm using the irisnative-1.0.0-cp34-abi3-macosx_10_13_x86_64.macosx_10_14_x86_64.whl

How can we fix the documentation (or the class method name)?

Hi Developers,

Please welcome the new video specially recorded by InterSystems Product Manager @Bob Kuszewski for the 3rd InterSystems Online Programming Contest on InterSystems IRIS Native API:

⏯ Using the IRIS Native API GitHub Template

What’s the contest about?

In the last year, InterSystems added and expanded Native APIs for Java, .NET, Python, and Node.js. The Native API provides high speed access to globals, the ability to instantiate and use ObjectScript objects, and fine-grained control over transactions.

Hi Community!

We are glad to invite all the developers to the upcoming  InterSystems IRIS Native API Contest Kick-Off Webinar! The topic of this webinar is dedicated to the 3rd IRIS Programming Contest.

Date & Time: Monday, May 18 — 9:00 AM EDT

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

What awaits you? Please check the agenda below:

Hi,

Do you have any experience in inserting a panda dataframe into SQL IRIS Table? The dataframe.to_sql method uses sqlalchemy and it seems no dialect is available for IRIS.

thanks, Blaise

If a picture is worth a thousand words, what's a video worth? Certainly more than typing a post.

Please check out my "Coding talks" on InterSystems Developers YouTube:

1. Analysing InterSystems IRIS System Performance with Yape. Part 1: Installing Yape

Running Yape in a container.

2. Yape Container SQLite iostat InterSystems

Extracting and plotting pButtons data including timeframes and iostat.