Discussion Neerav Adam Verma · Jul 29, 2020 IRIS vs Other integration engines Hello All, I have been using IRIS / Ensemble for over a decade and appreciate lot of it's functionalities and features, however besides having a UI of 80's era (which doesn't bother me), what I believe where IRIS is lacking is lack of out of the box connectors (services/operations).If we look at IRIS's competitors for eg Mulesoft, Talend, Boomi they all have hundreds of pre-built connectors for major applications like Salesforce, SAP etc and cloud services like Azure, AWS etc to store and retrieve information and data. #Business Operation #Business Service #InterSystems IRIS 0 2 0 420
Discussion Neerav Adam Verma · Jan 16, 2020 Query Plan Error or Correct Estimation Hi All, We have few queries which are simple selects . For simplicity let's say there is a query that joins two tables and gets few columns and both tables have no indexes. Select Tab1.Field1, Tab2.Field2From Table1 Tab1Join Table2 Tab2On Tab2.FK = Tab1.PKWhen we do query plan for this it shows approx 6 million, however if we make a simple adjustment to the query #Performance #SQL #Caché 0 5 0 240
Discussion Neerav Adam Verma · Dec 19, 2019 Web Technologies To Choose - Opinion Wanted HI, I am planning to build a WebApp that will have tons of data to display in tables, ability to add comments on that table rows and may be some few more small features as we move on. 1. It has to be Secure 2. It has to be fast 3. It has to be Non CSP / Non Zen 4. Will have Cache DB to pull records from but should be flexible to do that from any odbc resource 5. Version 2018 Ensemble My first step would have been to investigate different options for technologies that would make it work and best suited with Ensemble 2018 #Angular2 #CSP #Databases #Node.js #React #ZEN #Caché 0 18 1 435