Question Evgeny Shvarov · Mar 8, 2019 How to enable IRIS Text Analytics programmatically? Hi Community!How can I enable IRIS Text Analytics (formerly known as iKnow) in a given Namespace programmatically? #Deployment #Namespace #iKnow #InterSystems IRIS 0 4 0 684
Question Evgeny Shvarov · Mar 1, 2019 How to Setup InterSystems IRIS Container to Use OS-Level Authentication Programmatically Hi Community! When you run IRIS container out-of-the-box and connect to it via terminal e.g. with: docker-compose exec iris bash You see something like: root@7b19f545187b:/opt/app# irissession IRIS Node: 7b19f545187b, Instance: IRIS Username: *** Password: *** USER> And you enter login and password every time. How to programmatically setup docker-compose file to have IRIS container with OS authentication enabled? And have the following while entering the terminal: root@7b19f545187b:/opt/app# irissession IRIS Node: 7b19f545187b, Instance: IRIS USER> #Containerization #Terminal #InterSystems IRIS 0 3 0 418
Question Evgeny Shvarov · Feb 13, 2019 How to return JSON Array in SQL request for a List Property? Hi Community!Suppose I have a property in a ObjectScript class: Property values As list Of %String What an SQL query can help to return the values of the property as JSON array via SQL access (JDBC)? #JSON #SQL #Caché #InterSystems IRIS 0 12 1 978
Question Evgeny Shvarov · Feb 12, 2019 How many namespaces and databases could be in one InterSystems IRIS installation? Hi Community!What's the limit for Namespaces and Databases for one InterSystems IRIS installation?Yes, I checked with documentation but cannot find it at once. #Databases #Namespace #Caché #InterSystems IRIS 0 1 0 267
Question Evgeny Shvarov · Nov 27, 2018 How do You Convert 8-bit Database to Unicode? Hi Community!Suppose you have a working system on 8-bit Caché database and need to transfer the solution to Unicode database.How do you manage that? #Databases #Deployment #System Administration #Tools #Caché 2 17 0 1.3K
Question Evgeny Shvarov · Nov 15, 2018 Async mirror server as server for analytics in the cloud Hi All!I asked previously about the DR server in the cloud but actually, I'm curious about the backup server to use as analytics server more than for recovery in DR case.There is a recommended practice to use an async mirror as a server for BI (InterSystems Analytics, DeepSee)The question is if I have PRIMARY in the cloud (AWS, Google, Azure, etc) "how far" should async mirror member be placed? Same cloud, same private cloud or it doesn't matter at all for analytics purposes? #Analytics #Backup #Mirroring #System Administration #InterSystems IRIS 0 3 0 320
Question Evgeny Shvarov · Nov 13, 2018 Disaster recovery server in a cloud Hi Community!Consider I have InterSystems IRIS server in a cloud and want to introduce a DR server for it.Are there any requirements for DR server for InterSystems IRIS if it is in a cloud?Should it be the same subnet? One private cloud?Can DR server be placed on another cloud, say Primary on Google Cloud and DR on Azure? Are there any caveats/concerns? #Cloud #Backup #InterSystems IRIS 0 3 0 339
Question Evgeny Shvarov · Sep 4, 2018 Do we need a new type of posts - Discussion? Hi, Community!Today we have Announcements, Articles, and Questions. But sometimes we want to raise a discussion on the topic which is not a question, but also this post is not an article.What do you think? #DC Feedback 0 1 0 251
Question Evgeny Shvarov · Jun 5, 2018 $CASE For Long Stories Hi, Community!$CASE is a fine syntax sugar for "Ifs" with one-line/one-word expressions, like in docs: SET daynum=$ZDATE($HOROLOG,10) WRITE $CASE(daynum, 1:"Monday",2:"Tuesday",3:"Wednesday", 4:"Thursday",5:"Friday", 6:"Saturday",0:"Sunday",:"entry error") But if my expression for a current case is a multi-line business logic? Can I use "{}" somehow or better go with "IF" instead? #Code Snippet #ObjectScript #Caché 0 13 1 511
Question Evgeny Shvarov · Apr 13, 2018 Datatypes For Handling Date and Time in Persistent Classes Hi, Community!When I introduce a field to a persistent class to manage date/time what datatype should I prefer? %Date or %TimeStamp? And why? #Object Data Model #Caché 0 12 1 884
Question Evgeny Shvarov · Mar 31, 2018 How to Call a Custom Listing in MDX? Hi, DeepSee experts! I need to call a listing programmatically other than the default. I can do that with %LISTING keyword. E.g. in Samples: #InterSystems IRIS BI (DeepSee) #Listings #MDX 0 9 0 399
Question Evgeny Shvarov · Mar 15, 2018 Deployment Strategies: Do You Compile ObjectScript on a Production Site? Hi, Community!Please share your experience on code deployment on production site. Do you compile ObjectScript on Production? Is it OK? Or you only compile on Test site and copy cache.dat to a Production? #Continuous Integration #Compiler #Deployment #Caché 0 22 0 1.1K
Question Evgeny Shvarov · Mar 7, 2018 How to Export DeepSee Pivots And Dashboards Into Files With Every Save Hi, Community!I'm using Git with DeepSee and when I need to do a commit to the git repo I'm exporting ALL the pivots and dashboards from the namespace. But I can forget to do that) And it can take time for a large system.What is the way to manage automatical export of DeepSee artefacts which we are editing in UI (Cubes, Pivots, Dashboards, Pivot Variables, Term lists, Shared Measures) into files every time when I push Save button? #Change Management #Git #Deployment #InterSystems IRIS BI (DeepSee) 0 5 0 396
Question Evgeny Shvarov · Nov 30, 2017 Index Globals: Take Away or Rebuild? Hi, Community!Consider you move data from one server to another or make a deployment with persistent data. What do you do with index globals?Is it always better to rebuild them or there are some cases when it worth to take them too? #Deployment #Globals #Indexing #Object Data Model #Caché 0 7 1 657
Question Evgeny Shvarov · Nov 30, 2017 How to Map Class Package to a Namespace Programmatically Hi folks!Is there a one line command to map class package A to Namespace ASPACE? #Code Snippet #Namespace #ObjectScript #Mapping #Caché 1 7 1 1K
Question Evgeny Shvarov · Nov 13, 2017 Trigger or Callback? Hi, folks!Consider I need to perform some logic which should fire because values of object properties has been changed.Is there ANY reason for using class callbacks %OnBeforeSave or %OnAfterSave instead of Trigger? #Database Transaction Processing #Object Data Model #ObjectScript #Caché 0 5 1 920
Question Evgeny Shvarov · Nov 6, 2017 How to find duplicates for a large text field in Caché Objects? Hi, folks!Suppose you have a Caché class with %String property which contains relatively large text (from 10 to 2000 symbols).The class: Class Test.Duplicates Extends %Persistent { Property Text As %String (MAXLEN = 2000); } And you have thousands of entries. What are the best options to find entries which are duplicates on this property? #Indexing #Object Data Model #ObjectScript #Caché 0 26 1 1.3K
Question Evgeny Shvarov · Oct 30, 2017 Authentication options for Caché REST Application Hi, Community!Suppose If you develop a client js application which works with Caché server via REST API (CSP Gateway).What are the options for Authentication and working with Caché session then? #REST API #Authentication #CSP #Caché 1 9 0 1.5K
Question Evgeny Shvarov · Oct 22, 2017 How to Cancel The Execution of a Long Query in DeepSee Hi, folks!Suppose you called an MDX which takes a really long period of time.Is there any way to cancel its execution programmatically? #API #InterSystems IRIS BI (DeepSee) #MDX 0 2 0 368
Question Evgeny Shvarov · Oct 15, 2017 How to Upgrade Caché on Linux? Hi, Community!Say you have a standalone Caché server on Linux (E.g. Ubuntu) (no mirroring) and you have sudo access via ssh.What is the easiest, safest and simplest way to upgrade Caché to the new release? How do you do this? #DevOps #System Administration #Caché 0 4 0 542