Question Oliver Wilms · Apr 29, 2022 PoolSize System Default Setting Hello, I tried to define Pool Size in System Default Settings, but it is not being used. I see I am not the first to try this without success: Define PoolSize as system default value | InterSystems Developer Community Any suggestions? #Business Operation #InterSystems IRIS 0 4 0 433
Article Oliver Wilms · Apr 8, 2022 1m read Why another money app for Globals Contest? I wanted to join the InterSystems Globals contest. I have worked with InterSystems globals more than twenty years and I consider myself an expert. I developed another money app for globals contest because I needed it. What I had created previously was not really that useful for me. #Open Exchange Open Exchange app 0 0 0 188
Article Oliver Wilms · Jan 16, 2022 2m read Add Pivot Definition for dataset-finance in Online Demo I participate in InterSystems Datasets Contest. I created dataset-finance and analyze-dataset-finance apps along with Online Demo. The username is _SYSTEM and password is SYS. I created an online demo with a pretty dashboard here: #Tips & Tricks #InterSystems IRIS BI (DeepSee) 1 0 0 200
Question Oliver Wilms · 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? #Data Import and Export #SQL #InterSystems IRIS 0 10 0 566
Article Oliver Wilms · Jan 8, 2022 2m read dataset-finance: trying to map columns to properties I have a csv file with 13 columns. The header row is: #SQL #InterSystems IRIS 0 1 0 248
Article Oliver Wilms · Jan 8, 2022 2m read dataset-finance and my first experience with SQL LOAD DATA I read under Topics and Rules of InterSystems Datasets Contest: #SQL #InterSystems IRIS 0 2 0 258
Article Oliver Wilms · Dec 24, 2021 4m read InterSystems SQL Outbound Adapter - How fast can it go? One of my colleagues had developed an interface in Health Connect (HealthShare 2019.1) to add large amounts of data to an external SQL Server database. The data comes from many text files with delimited rows and data for one table per file. There is a business process to read a file line by line and send an Insert Request to an operation. #Performance #SQL #Health Connect #HealthShare 4 0 0 334
Question Oliver Wilms · Oct 21, 2021 Ensemble Data Lookup Tables - SQL query Hello, I wonder if we can run SQL queries to find data in Lookup tables? #SQL #Ensemble 0 1 0 559
Article Oliver Wilms · Oct 17, 2021 3m read Interoperability, RecordMap CSV Wizard, and Money 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. #Business Process (BPL) #Containerization #Contest #CSV #Interoperability #InterSystems Package Manager (IPM) #REST API #Health Connect #InterSystems IRIS #Open Exchange Open Exchange app 0 0 0 426
Question Oliver Wilms · Oct 4, 2021 CSV Record Wizard has a bug? I tried out CSV Record Wizard with my dat file from Analytics contest: https://raw.githubusercontent.com/oliverwilms/iris-analytics/master/data... #CSV #Ensemble 0 1 0 251
Article Oliver Wilms · Sep 11, 2021 5m read iris-analytics-for-money I regret getting a late start in the InterSystems Analytics contest. I had tried a couple of times before to use Analytics, but I had not gotten too far. I have been recording financial transactions in Excel workbook ever since I had to retire Microsoft Money. Since my iris-for-money was not fully functional, I created a worksheet per account I was tracking. I had developed a CSP page in iris-for-money to import transactions by reading a CSV file. #Cubes #Dashboards #InterSystems IRIS #InterSystems IRIS BI (DeepSee) Open Exchange app 8 1 0 290
Question Oliver Wilms · Aug 22, 2021 Web Gateway Error "Invalid Request : Cannot identify application path" I want to try SAM in AWS. I followed these steps: docker pull store/intersystems/sam:1.0.0.115 #CSP #System Alerting and Monitoring (SAM) #Web Gateway #InterSystems IRIS 0 7 0 865
Article Oliver Wilms · Aug 22, 2021 2m read My opinion: IRIS Mirror not as reliable as expected in AWS Elastic Container Service I have described my efforts to optimize IRIS Mirror deployment in AWS ElasticContainer Service (ECS) in my prior article. IRIS Mirror in the cloud (AWS) | InterSystems Developer Community | AWS #AWS #Cloud #Containerization #Failover #High Availability #Mirroring #InterSystems IRIS #InterSystems IRIS for Health 8 0 0 394
Article Oliver Wilms · Aug 4, 2021 3m read IRIS Mirror in the cloud (AWS) I have been working on redesigning a Health Connect production which runs on a mirrored instance of Healthshare 2019. We were told to take advantage of containers. We got to work on IRIS 2020.1 and split the database part from the Interoperability part. We had the IRIS mirror running on EC2 instances and used containers to run IRIS interoperability application. Eventually we decided to run the data tier in containers as well. #AWS #Cloud #Containerization #Failover #High Availability #Mirroring #Health Connect #InterSystems IRIS 12 14 2 852
Article Oliver Wilms · Jul 27, 2021 2m read IRIS Interoperability Message Bank I heard about Message Bank when we started redesigning a Health Connect production to run in containers in the cloud. Since there will be multiple IRIS containers, we were directed to utilize Message Bank as one place to view messages and logs from all containers. #AWS #Enterprise Message Bank #Interoperability #Ensemble #Health Connect #HealthShare #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 6 1 0 463
Question Oliver Wilms · Dec 7, 2020 Record Maps - is message required to be in a file? Hello, I like to know if we need to have the message in a file to process a Record Map? I am working with Interoperability Production that processes files /messages using Record Maps. My team was asked to redesign the solution for deployment in AWS. We use containers. We had problems with having multiple containers processing files from the same directory. We are considering Amazon Simple Queue Service instead of having files on a shared file system. #AWS #Business Service #Interoperability #Mapping #InterSystems IRIS 0 1 0 270
Article Oliver Wilms · Nov 22, 2020 2m read What else can Feeder do? Report about what happened during a test - check Message Bank to see what happened on the instances that received test messages from Feeder #Contest #InterSystems IRIS Open Exchange app 3 0 0 209
Article Oliver Wilms · Nov 16, 2020 2m read File Access Control for Inbound Adapter running in multiple IRIS instances My team is working on redesigning an Interoperability solution that currently runs on a HealthShare server that is part of a mirror. Most of the messages are delimited records processed using Complex Record Mapping. We were told to utilize cloud services available in AWS, use containers, autoscaling… #Business Service #Interoperability #Health Connect #HealthShare #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 1 0 0 301
Question Oliver Wilms · Nov 5, 2020 ECP Data Server - Allow Incoming Connections - Add ClientIP with code Hello, I am working with Elastic Container Service in AWS running IRIS for Health containers 2020.1. We have an ECP Data Server. I like to be able to add a new host IP on the data server when a new client starts up. What table are the Allowed ClientIPs stored in? Thanks, Oliver #ECP #InterSystems IRIS for Health 0 1 0 299
Article Oliver Wilms · Oct 5, 2020 2m read File Passthrough Feeder IRIS Interoperability Productions formerly known as Ensemble are fun to work with. Yes, I really think my work is fun. I have seen File Passthrough Services and File Passthrough Operations come in handy. At one point we placed test messages in files, then we utilized a File Passthrough Service with Inbound File Adapter to send the contents of the file as a Stream to a File Passthrough Operation with Outbound TCP Adapter. #Contest #CSP #Interoperability #REST API #Testing #Ensemble Open Exchange app 4 1 0 412