Article Henry Pereira · Jan 16 14m read Create and Read MS Word documents with ePython In this article, I will show you how one can easily create and read Microsoft Word documents using InterSystems IRIS with the leverage power of embedded Python. Setup First things first, let’s install the Python module called python-docx. There are a lot of modules to write MS Word files in Python. However, this one is the easiest one to use. Just execute the following command on the terminal: #Embedded Python #InterSystems IRIS 13 5 5 355
Question Henry Pereira · Oct 15, 2022 Metaprogramming in ObjectScript With $Property is possible to dynamically get and set values on property of an instanced class and with $ClassMethod is possible to invoke methods from a class. I would like to know: Is there an elegant way to do Write and Set dynamically on variables without using Xecute? #ObjectScript #Caché #InterSystems IRIS 0 6 0 180
Article Henry Pereira · Apr 6, 2022 7m read So, Where's my money? All of us know that money is important. We constantly need to monitor all expenses to avoid looking back to the bank statement and thinking: “So, where’s my money?” #AI #Embedded Python #InterSystems IRIS 3 0 0 673
Article Henry Pereira · Dec 1, 2021 5m read Data anonymization, introducing iris-Disguise First of all, what is data anonymization? According to Wikipedia: #InterSystems IRIS Open Exchange app 22 11 2 805
Article Henry Pereira · Sep 10, 2021 3m read Pop Songs Analytics I really love documentaries! Last weekend I was watching a Netflix documentary called This is Pop, because it was Analytics Contest time and I thought: Why not creating a pop song analytics with InterSystems Iris? #Analytics #Contest #InterSystems IRIS Open Exchange app 4 7 0 294
Article Henry Pereira · Aug 2, 2021 8m read Let's fight against the machines! Easy, easy, I'm not promoting a war against the machines in the best sci-fi way to avoid world domination of Ultron or Skynet. Not yet, not yet 🤔 I invite you to challenge the machines through the creation of a very simple game using ObjectScript with embedded Python. #AI #Best Practices #Embedded Python #Python #InterSystems IRIS 41 8 5 805
Question Henry Pereira · Mar 12, 2021 Hierarchical Queries Hi community, I need to write an SQL query with hierarchical order, I have a table with a column referencing itself, similar as the sample bellow: #Caché 0 4 0 176
Question Henry Pereira · May 20, 2020 How to select a random row from a table? Hi community, I need to write an SQL query to fetch a random record from a table, that table has millions of data. In postgresql, for example, there is a RANDOM() function to do something like that: SELECT column FROM table ORDER BY RANDOM() LIMIT 1 Is it possible to do something like that in Caché? Thanks in advance #Caché #InterSystems IRIS 0 8 0 469
Announcement Henry Pereira · Mar 27, 2020 Give it a try on SQLBuilder tool SQLBuilder is a flexible and powerful SQL query string builder for InterSystems IRIS, With SQLBuilder you have nice and clean object oriented methods, instead of having to use concatenation and substituition to generate dynamic queries. A Dynamic SQL without SQLBuilder A Dynamic SQL with SQLBuilder #Contest #Docker #ObjectScript #InterSystems IRIS #InterSystems IRIS for Health #Open Exchange Open Exchange app 11 14 5 422
Article Henry Pereira · Sep 16, 2019 6m read Power BI Connector for InterSystems IRIS. Part I In an ever-changing world, companies must innovate to stay competitive. This ensures that they’ll make decisions with agility and safety, aiming for future results with greater accuracy.Business Intelligence (BI) tools help companies make intelligent decisions instead of relying on trial and error. These intelligent decisions can make the difference between success and failure in the marketplace.Microsoft Power BI is one of the industry’s leading business intelligence tools. With just a few clicks, Power BI makes it easy for managers and analysts to explore a company’s data. This is important because when data is easy to access and visualize, it’s much more like it’ll be used to make business decisions. #Analytics #Best Practices #InterSystems IRIS 9 9 2 2,072