Hi,

The company I work for has one software application that uses an IRIS database, with almost all the others using SQL databases.

On a SQL database, we can create local tables and create views. These are invaluable when it comes to reporting, and everyone here is quite up to speed with using SSMS to create functions, stored procedures, etc.

Hi Developers,

I have created SOAP webservice cls and configured as business service in ensemble. Now I have started the production.

Where can I find the wsdl for this new soap_service?

Thanks,

Prashanth

We've traditionally run a selection of development environments from a single cache instance using different namespaces for DEV TEST PREP etc. This has come with a few drawbacks, mainly that you then cant break down into namespaces per environment and everything is sharing various options.

Is there a massive overhead to running multiple cache instances from the same 'box' instead?

How best to share the memory setup in that situation, we usually pre-define around 80% for the instance, do we just share that evenly between the multi instance scenario?

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, we are a veterinary lab and we use both the LAB and FIN systems of Antrim. Now we are looking to expose the data in a SQL/Object compatible way so we were wondering if same / similar things had been done by other community members already? If so, could you please share your approach / experience / gotchas with us and we are all ears. I can be reached at yang.jiao@antechmail.com . Thank you!

Release 2017.2.

I have created a class that extends Ens.BusinessOperation, and in my class I have defined a custom property. How can I change the property's heading that is displayed on the Management Portal Settings tab?

How to send HL7 messages using HTTP type in the business production??

Over the years, I’ve noticed that certain SQL questions come up repeatedly on the InterSystems Developer Community, especially about using the LIKE predicate in different contexts. Common variations include:

• using special characters in queries
• using variables in queries

and many more derivatives. So, I decided to write an article that focuses on how LIKE works in InterSystems IRIS SQL, especially when used with variables in Embedded SQL, Dynamic SQL, and Class Queries, while touching on pattern escaping and special character searches.

First of all, I'd like to mention that InterSystems IRIS SQL offers most of the capabilities available in other relational DBMS that implement a later version of the SQL standard. But at the same time, it's important to mention that apart from relational access, in IRIS you can also use other models to get the same data, for example, object or document models.

On this note, let's look at the LIKE predicate and how this tool is used in SQL for pattern matching.

Hello,

I have installed the latest version of IRIS (without a web server) to replace my community version with a embeded web server.
I tried to connect Visual Studio Code to my namespace, but I am unable to do so. I keep receiving the message "Not found."
Here is my configuration:

"pc-david": {
"webServer": {
"scheme": "http",
"host": "localhost",
"port": 80
},
"description": "pc-david",
"username": "_SYSTEM"
}

Hello, I am writing to you because I am receiving a strange error on our Integration server after restoring a Production copy.

On other occasions we had restored the Production copy on this server without problems (in fact it was done weekly)

After restoring the copy when entering the Studio this error appears:

How to import Custom Schemas from VSCode? They look like this:

<?xml version="1.0"?>
<Category name="ITK" description="xmlns:hl7='urn:hl7-org:v2xml' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'" std="1">
<MessageType name='ACK' structure='ACK' returntype='ACK' description='xsi:schemaLocation="urn:hl7-org:v2xml ACK.xsd"'/>
</Category>

Instead of wrapped XML export produced by $system.OBJ:

Hi Community,

Please read this when you have the time and keep an open mind. Also, you are welcome to tell me it is a terrible idea.

The main reason for this post

If you look at NPM, it has 1.3 million packages. Now ask yourself, is this an achievement or a nightmare?
How many of those packages are no longer supported?
How many of those packages break compatibility on version changes?
How do you know which one to use?

We are starting the countdown to our 30th Global Summit, at the Diplomat Beach Resort in Hollywood, Florida. Only 136 more days until you can connect with fellow InterSystems product users, engage with product develops and hear all about the trends, challenges and solutions of data management with our technology.

Sign up for notifications today to be the first to register and see who our guest speakers will be!

Hi Developers!

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

• Sustainability Topic
• Sustainability Dataset
• Business Process BPL or Business Rule DTL Usage
• Custom Interoperability Adapter
• Production EXtension(PEX) Python, Java, or .NET usage
• Embedded Python usage
• Docker container usage
• ZPM Package Deployment
• Online Demo
• Code Quality pass
• Article on Developer Community
• The second article on Developer Community
• Video on YouTube

See the details below.