Article Andreas Schneider · Apr 23 3m read Testing Metadata Inconsistencies in InterSystems IRIS Using the DATATYPE_SAMPLE Database (Part II) - Silent Corruption The first part of this article provides all the background information. It also includes links to the DATATYPE_SAMPLE database, which you can use to follow along with the examples. In that section, we explored an error type ("Access Failure") that is easy to detect, as it immediately triggers a clear error message when attempting to read the data via the database driver. #InterSystems IRIS Open Exchange app 0 0 0 31
Article Andreas Schneider · Apr 22 4m read Testing Metadata Inconsistencies in InterSystems IRIS Using the DATATYPE_SAMPLE Database When using standard SQL or the object layer in InterSystems IRIS, metadata consistency is usually maintained through built-in validation and type enforcement. However, legacy systems that bypass these layers—directly accessing globals—can introduce subtle and serious inconsistencies. #Globals #JDBC #Mapping #ODBC #SQL #Caché #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 1 0 0 33
Article Andreas Schneider · Jan 12 1m read Testing FOREIGN SERVER and FOREIGN TABLE feature Hi! I've extended my demo repository, andreas5588/demo-dbs-iris, to make it easy to test the FOREIGN SERVER and FOREIGN TABLE features in IRIS. To achieve this, I created a namespace called FEDERATION. The idea is as follows: #Docker #JDBC #Namespace #SQL #Testing #InterSystems IRIS Open Exchange app 2 3 0 136
Article Andreas Schneider · Jan 16, 2022 1m read Using a docker container group with IRIS, the Openflights Dataset and Apache Zeppelin 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. #InterSystems IRIS Open Exchange app 2 0 0 274
Article Andreas Schneider · Jan 9, 2022 1m read Tips and tricks of the brand new LOAD DATA command - Part II 7) You need the right driver If you want to execute the LOAD DATA sql command you have to choose the driver from 2021.2! If you select the wrong driver and use the LOAD DATA sql command you get something like #InterSystems IRIS Open Exchange app 3 2 0 439
Article Andreas Schneider · Jan 2, 2022 3m read Tips and tricks of the brand new LOAD DATA command The last days I've work with the great new feature: LOAD DATA With this post I would like to share my first experiences with you. The following points do not contain any order or other evaluation. These are only things that I noticed when using the LOAD DATA command. It should also be noted that these points are based on the IRIS Version 2021.2.0.617 which is a preview release. So it may be that my observations do not apply to newer IRIS versions. #Best Practices #Contest #CSV #JDBC #SQL #Tips & Tricks #InterSystems IRIS Open Exchange app 6 5 2 1.1K
Article Andreas Schneider · Mar 28, 2021 4m read Registering the .Net Data Provider for InterSystems Caché and InterSystems IRIS as DbProviderFactories This small tutorial described how to „register“ the ADO.NET Database Provider (Driver) for InterSystems IRIS and InterSystems Caché on a Windows machine. Before we start: Why need the ADO.NET Database Provider to be registered? #Deployment #Development Environment #Caché #InterSystems IRIS 1 0 0 1.2K
Article Andreas Schneider · Feb 22, 2017 2m read Using InterSystems Caché and Apache Zeppelin I' have done some tests with Caché and Apache Zeppelin. I want to share my experince to use both systems together. I'll try to describe all steps that are required to config Zeppelin to connect to Caché. #Artificial Intelligence (AI) #Analytics #Best Practices #Tools #UI Development #Caché 9 6 0 1.4K