Article Sylvain Guilbaud · Jan 31 1m read Correctly manage the system time of my IRIS container In a containerized environment, you can manage your container time via the TZ variable or via the /etc/timezone and /etc/localtime directories: #Docker #Localization #System Administration #InterSystems IRIS #InterSystems IRIS for Health 4 0 0 11
Article Sylvain Guilbaud · Jul 8, 2024 2m read Configuring IRIS autostart on Linux For practical reasons, it may be desirable that after a Linux server restart, the IRIS instance is automatically started. Below you will find the steps to follow to automate the startup of IRIS during a reboot of the Linux server, via systemd : 1. Create an iris.service file in /etc/systemd/system/iris.service containing the following information #System Administration #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 8 17 5 582
Article Sylvain Guilbaud · Apr 30, 2024 3m read LowCode simple demo transforming HL7 SIU messages to Kafka, then consuming Kafka messages to store them into IRIS via SQL #HL7 #Interoperability #JDBC #SQL #InterSystems IRIS for Health Open Exchange app 7 3 4 333
Question Sylvain Guilbaud · Apr 25, 2024 How to create a database with its associated resource using merge command ? Hi Community, What is the correct syntax in a merge.cpf file to create a database with its associated resource ? #Databases #Deployment #System Administration #InterSystems IRIS #InterSystems IRIS for Health 0 1 1 83
Question Sylvain Guilbaud · Apr 18, 2024 Pentaho Data Integration with IRIS ? Hi Community, I'm looking for someone who has already made data ingestion into IRIS (or Caché) from Pentaho Data Integration. Thanks in advance. #Databases #Interoperability #Caché #InterSystems IRIS 0 2 0 154
Question Sylvain Guilbaud · Apr 11, 2024 Call for FHIR experts: R5 vs R4 Hi Community, Starting a FHIR repository project with IRIS for Health, what are the pros and cons to use R5 instead of R4 ?What is the effort to migrate from R4 to R5 the FHIR repo ?What are the risks or disadvantages to use R5 ? Thanks #FHIR #HL7 #InterSystems IRIS for Health 1 3 0 331
Question Sylvain Guilbaud · Mar 8, 2024 Call for FHIR experts: resource Person vs. Patient/Practitioner What are the advantages/disadvantages of using the Person resource with a link to the Patient and Practitioner resources, rather than using the Patient and Practitioner resources directly without using the #FHIR #HL7 #Interoperability #HealthShare #InterSystems IRIS for Health 1 2 0 170
Article Sylvain Guilbaud · Feb 1, 2024 5m read Get a result in JSON from an SQL query Hello Community, SQL language remains the most practical way to retrieve information stored in a database. The JSON format is very often used in data exchange. It is therefore common to seek to obtain data in JSON format from SQL queries. Below you will find simple examples that can help you meet this need using ObjectScript and Python code. #Embedded Python #JSON #ObjectScript #Python #SQL #InterSystems IRIS #InterSystems IRIS for Health 7 1 4 350
Article Sylvain Guilbaud · Jan 8, 2024 3m read How to replay certain rows from a SQL source using a SQL adapter (EnsLib.SQL.InboundAdapter) Hello Community, When using an SQL type Business Service, it may happen that we need to replay certain rows from the source table. Let's take as an example the Business Service "from customer SQL" using the generic class EnsLib.SQL.Service.GenericService #Interoperability #SQL #InterSystems IRIS #InterSystems IRIS for Health 4 0 1 339
Question Sylvain Guilbaud · Jan 5, 2024 SFTP connection problem Hello, I have been facing a problem for several months, I have several flows that work in SFTP with the iris class EnsLib.FTP.PassthroughService The problem is that from time to time I get an error message that says: "A connection could not be established because the target computer expressly refused it" I had the case for a server at our house and we solved the problem by extending the call interval parameter to 60 seconds, #FTP #InterSystems IRIS for Health 1 3 0 300
Announcement Sylvain Guilbaud · Jan 5, 2024 [Video] MayVilleHop, the new City Hospital coordination platform Hello Community! Take advantage of watching the new video to discover the innovative solution which strengthens communication between community medicine and hospital practitioners for better patient care in the context of semi-emergency and contributes to the relief of emergency services in the region of Mayenne in France. 📺 MayVilleHop, the new City Hospital coordination platform https://www.youtube.com/embed/MjlaarmRx98[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings] #Video #Other 1 0 0 88
Article Sylvain Guilbaud · Sep 25, 2023 2m read InterSystems IRIS trainings Hi Community, to learn quickly and in total autonomy on IRIS, I offer you some links which can help you in this beautiful bicycle ride rich in discoveries: #Angular #Beginner #Embedded Python #ObjectScript #Python #InterSystems IRIS #InterSystems IRIS BI (DeepSee) #InterSystems IRIS for Health 8 5 4 417
Article Sylvain Guilbaud · Sep 18, 2023 6m read How to run code at compile time with macros. Hello developers, In this article, I'll show you how to run code at compile time with ObjectScript macros. Here's a use case that recently led me to use this feature: As part of a medical application developed for more than 20 years, we have a large number of parameters. Although we have procedures for documenting these settings, it can be helpful to have a quick view of which settings are actually used by the application code. #Code Snippet #ObjectScript #InterSystems IRIS #InterSystems IRIS for Health 5 0 1 343
Discussion Sylvain Guilbaud · Sep 12, 2023 Amazon QuickSight with InterSystems IRIS Data Platform Hello Community, Anyone who has (near or distant, with a preference for the 1st option) knowledge of the use of Amazon QuickSight with IRIS is invited to share his|her experience in this discussion. Thanking you in advance. #Analytics #MDX #InterSystems IRIS #InterSystems IRIS BI (DeepSee) #InterSystems IRIS for Health 1 0 0 162
Announcement Sylvain Guilbaud · Sep 12, 2023 The Pandora Box that will help you find integration errors Hello Community! I want to share with you an interesting solution that will allow you to perform integration testing for your healthcare applications. Let me introduce you to Pandora – a FHIR server testing software designed by Fyrstain, offering cutting-edge solutions for healthcare interoperability testing. #FHIR #Other 3 0 0 244
Discussion Sylvain Guilbaud · Sep 11, 2023 Manage SQL accesses to all or some schemas in a database, instead of managing it a the tables level. Currently, the SQL privileges (SELECT, INSERT, UPDATE, DELETE) are managed at the tables level, which can be very tedious when you have to administer many roles in an organization, and need to keep them sync with a constantly evolving data models.By managing privileges at the schemas level, will allow to give SELECT and other DML privileges to *all* or *several schemas* to a role|user, fixing the need to manually synchronize the new tables|views to the roles. #Security #SQL #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 0 6 0 229
Question Sylvain Guilbaud · Sep 8, 2023 How to do a SQL query on a multilevel global and display each level in the same table ? Hello, I have a global whose structure is multi-level and I am trying through a class and a SQL query to display a table which includes all the values and levels. #Globals #Mapping #SQL #Caché #InterSystems IRIS 1 2 0 453
Discussion Sylvain Guilbaud · Sep 8, 2023 Microsoft Dynamics with IRIS / Ensemble Hi, what is our experience of Microsoft Dynamics integration with IRIS/Ensemble ? If you have any experience with IRIS/Ensemble using interoperability flows with Microsoft Dynamics, please share it is this discussion. Best regards, Sylvain #Interoperability #Ensemble #InterSystems IRIS 0 0 0 247
Question Sylvain Guilbaud · Aug 30, 2023 How to activate all AUDIT system events? When installing IRIS, all the system AUDIT events are not enabled. What is the fastest way to activate all events? System > Security Management > System Audit Events #Monitoring #Security #System Administration #InterSystems IRIS #InterSystems IRIS for Health 3 1 2 220
Question Sylvain Guilbaud · Aug 28, 2023 From DBeaver, how to filter system schemas (ie: starting with "%") ? I'm looking for an efficient way in DBeaver to filter system tables (ex: belonging to a schema starting with "%"). By using a user with the %All role, DBeaver shows us a long list of system schemas, which forces us to go down the list before accessing the user tables. #JDBC #SQL #InterSystems IRIS #InterSystems IRIS for Health 1 8 0 1.2K