Announcement Amir Samary · Jan 29, 2020 Readmission Demo 2.0 is here! And it is open source now! Hi everyone, I am very pleased to announce that the Readmission Demo has been released as open source. Many thanks to the Solution Factory team that worked hard on making this possible. Here are the changes: #Business Process (BPL) #DevOps #Docker #DTL #FHIR #InterSystems Business Solutions and Architectures #Machine Learning (ML) #Open Source #REST API #InterSystems IRIS for Health Open Exchange app 8 0 2 549
Announcement Amir Samary · Sep 23, 2019 InterSystems Evaluation Service Hi everyone, I am pleased to announce that the Evaluation Service is now LIVE! If you are an InterSystems End User or an InterSystems Partner and you want to try the latest version of IRIS with all its enterprise features (mirroring, ECP and sharding), and you want it NOW, this is for you. #InterSystems IRIS #InterSystems IRIS for Health #Partner Directory 12 4 4 1.7K
Question Amir Samary · May 7, 2019 Custom Query that Returns a RANDOM number of columns Hi!I was trying to create a query that can be exposed as a stored procedure (function actually) that would return a resultset with a random number of columns. Unfortunately, it seems that unless I specify the ROWSPEC annotation on the Query method, I won't get any columns exposed. I was hoping to implement QueryNameGetInfo method and specify the names and number of columns I would be returning dynamically. But it seems that GetInfo information is simply ignored.Here is my code: #Databases #JDBC #ObjectScript #ODBC #SQL #Caché #InterSystems IRIS 1 5 0 652
Article Amir Samary · Oct 12, 2017 4m read How to interactively run a Windows or Unix command from inside Caché/Ensemble Hi! It is often necessary to run some external command such as a python program or a shell script from inside Caché/Ensemble. There are three ways of doing this: #API #Callout #Code Snippet #Object Data Model #Tips & Tricks #Caché 9 8 1 2.6K
Question Amir Samary · Jun 28, 2017 Configuring users and roles on many caché instances Hi everyone!We have many severs (DEV, QA and LIVE) besides many other slave servers (about 133) that are running Caché instances. Before writing this utility myself, I would like to know if anyone has done it before. We need to change the SuperUser password and do other credential setups like this on all of these servers and we don't want to do it one by one. #System Administration #Caché 0 4 0 719
Question Amir Samary · May 10, 2017 Managing UTF-8 characters on the database with a REST application Hi everyone, This is: Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2016.2 (Build 736U) Fri Sep 30 2016 12:25:56 EDT The server is on RedHat Linux while the browser is running on Windows (Firefox). I am helping a partner build a complex modern HTML5 web application that talks with Caché using REST calls. They have been using %CSP.REST very successfully. Security works great as well. #Caché #REST API #CSP 1 11 0 9.7K
Question Amir Samary · Sep 21, 2016 Has Anyone Managed to configure CSP Gateway on CentOS 7 with Apache 2.4 and Secure Enhanced Linux Enabled? Hi!I am not system admin. But it used to be very simple to install CSP Gateway on an apache system on Linux with Apache installed. I used to run the CSP Gateway installation program and after it was done, all I had to do was fine tune some configurations on CSP Gateway portal on http://<ip>/csp/bin/Systems/Module.cxw and I was up and running. #Beginner #CSP #Security #System Administration #Caché 0 5 0 1.4K
Question Amir Samary · Sep 17, 2016 Why can't I have CSP Gateway files where I want on a cache_silent install? Hi!I have the following script to install caché silently: #Caché #Change Management #Continuous Integration #System Administration #CSP 1 4 0 612
Question Amir Samary · Aug 12, 2016 Git Continuous Integration - What are the most important differences between CacheGitHubCI and CacheUpdater? Hi! I am about to configure a server with continuous integration for a client. I found that our Russian friends have again come up to the rescue and developed not one, but two continuous integration tools for Git and Caché: #Continuous Integration #Git #GitHub #Caché 1 8 0 873
Question Amir Samary · May 24, 2016 Isn't "Delegated" a supported Authentication Method for %Installer <CSPApplication> tag? Hi! I am trying to create a %Installer script and I noticed from our documentation that %Installer's <CSPAuthentication> will only accept: <CSPApplication> Optional; within <Namespace>. Defines one or more CSP applications; the supported authentication flags are 4 (Kerberos), 32 (Password), and 64 (Unauthenticated). Is "Delegated" authentication supported? What is it's code? Kind regards, Amir Samary #Authentication #Security #Caché 0 2 0 403
Question Amir Samary · May 24, 2016 Database Collations: What are the difference between Spanish1, Spanish2, Spanish4 and Spanish5? Hi everyone! I am trying to choose the best collation for a new application that will be running on a spanish locale (Chile). I can see there are database collations for Spanish1, Spanish2, Spanish4 and Spanish5. What is the difference between them? I can't find anything on our documentation. Should I simply choose the latest (Spanish5)? Kind regards, Amir Samary #Caché 0 1 0 415
Question Amir Samary · May 24, 2016 Storing events with current date/time using UTC ($ZTimeStamp) instead of $Horolog - Best practices discussion Hi everyone! I am helping a partner to develop a new application and one of the things we are facing is that this WEB application will be used on different time zones. My first recommendation is that all timestamps should be drawn from $ZTimeStamp instead of $Horolog. That would allow the system to be draw the correct sequence of events even when they are generated on different timezones. #Caché #Frontend #CSP 1 1 0 757
Question Amir Samary · Apr 8, 2016 EnsLib.EDI.XML.Document with schema returning full tag instead of only the text value on GetValueAt() Hi everyone! I have imported a schema (HL7 v2.5 XML schema) using the "Ensemble > Interoperate > XML" and I have built a Web Service that receives a string with an XML document that follows the schema. I have used EnsLib.EDI.XML.Document as follows to consume the string and produce the XML vDoc: #DTL #HL7 #XML #Ensemble 0 1 0 778
Question Amir Samary · Dec 14, 2015 %DeepSee.ResultSet taking forever to run an MDX that Analyzer executes fast Hi!I am working on a project and I am facing a weird problem. I have created an MDX using Analyzer. This MDX executes very fast. I am trying to automate its execution with %DeepSee.ResultSet and the query never returns: Set tSC = oMDX.%PrepareMDX(tMDX) Quit:$System.Status.IsError(tSC) Set tSC = oMDX.%Execute() Quit:$System.Status.IsError(tSC) What could be causing %Execute() to take so long to run while Analyzer is responding fast? #MDX #InterSystems IRIS BI (DeepSee) 0 2 0 343