Question Andreas Schneider · Sep 15 Have you tried the THROUGH command in IRIS 2024.2? How does it work? Has anyone successfully tested the new THROUGH command in IRIS 2024.2 with a FOREIGN SERVER?https://docs.intersystems.com/iris20242/csp/docbook/Doc.View.cls?KEY=RSQ... I have connected from a Docker instance to a VM. I was able to successfully set up the JDBC connection through the UI. #JDBC #SQL #InterSystems IRIS 0 3 0 149
Question Andreas Schneider · Jun 1 Where are the ODBC Driver for IRIS 2024.1 for Community Edition Users? Hi all! #ODBC #SQL #InterSystems IRIS 0 4 0 168
Question Andreas Schneider · Dec 25, 2022 External Language Server failed to Start -> LOAD DATA FROM FILE no longer works Hi! 've installed a fresh IRIS on Windows 10: "InterSystems IRIS Version 2022.2.0.368 xDBC Protocol Version 65" I've tried to create an older demo database that I've build some days ago... it didn't work anymore :-( If I execute this SQL: #InterSystems IRIS 1 1 1 397
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 240
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 406
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 1K
Question Andreas Schneider · Dec 30, 2021 LOAD DATA with [SQLCODE: <-400>:<Fatal error occurred>]... any idea? Hi all,I try to build a little project for the dataset contest, you can find it here on github: Openflights datasetMy plan is to use just plain SQL. So I've made a few experiments with the new feature LOAD DATA. #Contest #SQL #InterSystems IRIS 1 10 0 657
Announcement Andreas Schneider · Sep 8, 2021 "New" Tool SQL DATA LENS for Intersystems IRIS Dear ladies and gentlemen, in the last month I've improved my Tool Caché Monitor... but first: the name The name Caché Monitor was chosen to reflect the close integration of the tool with the Caché database. The established name Intersystems Caché will likely be completely replaced by InterSystems IRIS Data Platform in the foreseeable future I think. So a rebranding step became necessary. In order to be less closely tied to a product name in the future, a new name has been chosen to be more neutral: SQL Data Lens #Caché #InterSystems IRIS Open Exchange app 4 4 1 561
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.1K
Announcement Andreas Schneider · May 14, 2019 Prerelease of Caché Monitor with native IRIS support Hi! I'm Andreas, the developer of Caché Monitor.Caché Monitor is a database tool with special feature for InterSystems Caché. Since today also with support for InterSystems IRIS!A public pre release is available for download: https://www.cachemonitor.de/cache-monitor-beta-releases/ #InterSystems IRIS 3 0 1 364
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
Announcement Andreas Schneider · Feb 17, 2016 Caché Monitor - A database tool primarily for InterSystems Caché allows sql queries across namespaces Caché Monitor is a database\sql tool primarily for InterSystems Caché but can also connect to MS SQL Server, MS Access and more databases. Within Caché Monitors Server Navigator you see all available Namespaces on your Caché Servers. No need to know the name of the Namespace, no need to configure many many JDBC Connections by hand. Just click on the namespace and see all objects like tables, views, classes and more... #Databases #Development Environment #SQL #Tools #Caché 3 2 0 2.4K