go to post Scott Roth · Apr 15, 2020 I would believe the only way to put a schema filter in would be within your query and not in the connection string.
go to post Scott Roth · Apr 15, 2020 First start off by looking at the following documentation... https://docs.intersystems.com/irisforhealth20201/csp/docbook/DocBook.UI.Page.cls?KEY=PAGE_java_jdbc https://docs.intersystems.com/irisforhealth20201/csp/docbook/Doc.View.cls?KEY=BJAVA_connecting What you use for your connection string all depends on the driver you are using. In the past I have used Microsoft, Oracle, and jTDS JDBC drivers. Currently I am using jTDS because it allows me to use integrated Authentication. so my strings are a little long... jdbc:jtds:sqlserver://(server name):(port)/(database);instance=xx;domain=xxxx;useNTLMv2=true;cacheMetaData=true;prepareSQL=2; is just an example. Scott
go to post Scott Roth · Apr 14, 2020 Try this link... https://docs.intersystems.com/healthconnect20191/csp/docbook/Doc.View.cls?KEY=EGDV_adv#EGDV_adv_ens.director_prod_startstop and look for Using Ens.Director to Start and Stop a Production
go to post Scott Roth · Mar 2, 2020 I found with create a Inbound BS, you can't really use the Delete query as an update statement. Either you place the update statement within your BPL, or truly make the Delete query a Delete query on your inbound service.
go to post Scott Roth · Feb 28, 2020 This maybe a silly question but what if you are not using a docker image? What is docker-compose?
go to post Scott Roth · Jan 29, 2020 Make sure you are also using EnsLib.RecordMap.Operation.BatchFileOperation as your operation and you define the header in it as well.
go to post Scott Roth · Jan 10, 2020 Everything I have read from Microsoft says this error has to do with a linked server. However where I am trying to select from is a view and has no linked server involved.
go to post Scott Roth · Jan 6, 2020 I am struggling with understanding how to display the table within the CSP page. In reading the document it mentions ZEN, but as we have been told not to use ZEN because ZEN is going away. So how can I display the SQL table in a table format that could be updated instead of the form document mentioned above? Most of the examples are only 1 or 2 rows. I am looking at a 25 rows x 6 columns table to display and update. I got the above to work, just trying to make it more friendly. Thanks Scott
go to post Scott Roth · Nov 21, 2019 Here is an interesting outcome from playing around. Before I could not open the osuwmc.TestClin in either studio or the Management portal after an upgrade/compile to 2019.1.1. So I was wondering if I should just look at the file. So I exported it from studio, looked at it on my local desktop, then imported it locally from my desktop. I was able to compile it through studio without issues, and Management Portal was able to see the production as well. Weird.....
go to post Scott Roth · Nov 21, 2019 I have tried UpgradeAll() also without any luck. Is it possible to just Show and Set qualifiers on just one production to tell me whats wrong with it? I can't open the production class in studio either.
go to post Scott Roth · Nov 15, 2019 Have you used JDBC drivers before? I have a couple of connections that I have created through JDBC to connect to Oracle to pull data from an Oracle table to create an HL7 message. Currently we are using the Oracle JDBC driver to connect to the Oracle system.
go to post Scott Roth · Oct 30, 2019 I figured it out on my own. It did not like <assign value='source.GetFieldStreamRaw(.tStream,"ORCgrp(1).OBRgrp(1).OBXgrp(k1).OBX:ObservationValue(1).AlternateText}",tRemainder)' property='tSC' action='set' /> I had to change it to <assign value='source.GetFieldStreamRaw(.tStream,"ORCgrp(1).OBRgrp(1).OBXgrp("_k1_").OBX:5.5",.tRemainder)' property='tSC' action='set' />
go to post Scott Roth · Oct 15, 2019 So far we have ended up with like 4 routing rules just for ADT alone to get it do the Ancillary systems.
go to post Scott Roth · Oct 14, 2019 When we were going through our conversion from egate to Ensemble, it was suggested not to have anymore that 25 rules within a Business Router. Anymore than that caused us severe performance issues when it came to making sure our downstream systems was receiving the messages in time. Scott Roth
go to post Scott Roth · Oct 8, 2019 I am not aware that a CSV could be read in via EnsLib.File.PassthroughService. From what I was taught a CSV would have to be mapped to a RecordMap then you can parse out the CSV using EnsLib.RecordMap.Service.FileService. https://docs.intersystems.com/healthconnect20191/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_recmap Scott
go to post Scott Roth · Oct 3, 2019 From what I read is the basic purge does not take care of the orphaned messages. That's why there is this manual step we have to configure.
go to post Scott Roth · Sep 19, 2019 Not sure if this will answer your question or not, but we had to move to the jTDS JDBC driver in order to pass an AD account through a connection. jdbc:jtds:sqlserver://(server name/port) ;instance=tp;domain=osumc;useNTLMv2=true;cacheMetaData=true;prepareSQL=2;