You're missing one step. The SDA your DTL is producing is in the form of an XML vDOC (EnsLib.EDI.XML.Document) which is using the SDA schema. The SDA3.InboundProcess needs to receive an HS.Message.ECRUpdateRequest with the raw XML for the SDA stored in its contentstream property. To fix this, you can create a second DTL which takes the EnsLib.EDI.XML.Document as input and outputs an ECRUpdateRequest. In the DTL you'll just need to call the VDoc's method to generate the XML stream and then set ECRUpdateRequest.ContentStream to that stream.

This is absolutely possible. First, you'll want to use a SQL Business Operation rather than a Business Service. Your function will send a simple request message to the Business Operation containing any parameters you want to pass to the SP (if you only have one parameter you can use Ens.StringContainer). The Operation will execute the SP on SQL Server and return a response message to your function.

You didn't mention where you plan to call this function from (a DTL? a Business Process?). If it's a Business Process then you don't need a custom function, you can just use a "call" action to send the request to the Operation.

If you need to do this from a DTL, then in order to send a message to the Operation you'll need to call a method of the business process or router. You can get a reference to the process/router this way:

set bp=%Ensemble("%Process")

And then you can send your request message like this:

set tSC=bp.SendRequestSync("My.SQLServer.Business.Operation",req,.resp)

SoapUI and Postman use HTTP to send requests. HL7 over TCP (MLLP) is not an HTTP-based protocol.

You can use a business operation as you mentioned, or there are some commonly used third-party tools for testing HL7 interfaces, such as Interface Explorer.

There's also a convenience function for this:

set origTime=$h
set newTime=$$HorologAddSecs^EnsUtil(origTime,60)

The first parameter is the time in $horolog format, the second parameter is the number of seconds to add. It returns the new time in $horolog format.

Hi Yuri, have a look at this online training course.

There are several utilities available for converting XLSX to CSV. You could run the conversion using $ZF(-100) and then read the CSV using a RecordMap.
Here's one example:
https://csvkit.readthedocs.io/en/1.0.2/scripts/in2csv.html

Can you provide some more details about what you're trying to do and what the process that you're trying to change looks like?

Here's an overview of productions and message flows. In most cases, you would add business logic using a Business Process. Here's a nice online course about developing Business Processes.

There are some open source tools available that convert HTML to PDF:

https://wkhtmltopdf.org/

Have a look at Creating REST Services in Caché.

Have a look at this module on Health Connect's XDS.b components:
https://docs.intersystems.com/healthconnect20191/csp/docbook/DocBook.UI…