Question Sylvain Guilbaud · Apr 25 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 67
Question Sylvain Guilbaud · Apr 18 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 127
Question Sylvain Guilbaud · Apr 11 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 225
Question Sylvain Guilbaud · Mar 8 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 134
Question Sylvain Guilbaud · Jan 5 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 245
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 399
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 207
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 971
Question Sylvain Guilbaud · Aug 23, 2023 Does LOAD DATA provide in a future version an option to indicate a date/datetime format other than 'yyyy-mm-dd hh:mm:ss'? Is it planned that LOAD DATA takes into account several DATE/DATETIME formats with, for example, a parameter indicating the format used in the source data? example : LOAD DATA .../... USING { "from": { "file": { "dateformat": "DD/MM/YYYY" } } } #Data Import and Export #JDBC #SQL #Tools #InterSystems IRIS #InterSystems IRIS for Health 2 3 0 202
Question Sylvain Guilbaud · Feb 25, 2022 How to configure SAM to monitor containers or local instances ? Monitoring IRIS through SAM (sam:1.0.0.115) While I've used to make it work in the past, I'm not able any more to fix the already faced issue : "State: Unreachable" Despite all the ip-addresses attempts (or hostname = host.docker.internal) and while "/api/monitor/metrics" is running well... Could someone provide good practices to make it work cleanly ? #System Alerting and Monitoring (SAM) #InterSystems IRIS 1 13 0 421
Question Sylvain Guilbaud · Feb 17, 2016 How can we customize the Excel content exported from the Analyzer/Dashboard ? A customer needs to add lines in the Excel sheet before the MDX resultset content.Is there a more elegant/convenient way than modifying %DeepSee.UI.MDXExcel methods ?Thanks in advance.Sylvain #InterSystems IRIS BI (DeepSee) #MDX 1 4 0 450
Question Sylvain Guilbaud · Dec 2, 2015 DeepSee DataConnector references (external databases sources) I’m interested in our DeepSee references who define cubes with external databases. #InterSystems IRIS BI (DeepSee) 1 2 0 244