is this post any help?

https://community.intersystems.com/post/connecting-mysql-odbc

Also worth noting that you can create your own custom function - https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_adv#EGDV_adv_custom_utilfunctions

Alternatively, a more visual way is to use the business metrics and a DeepSee dashboard - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_bmetric

Using this format ( "2008-09-15 10:00:00" ) solved my issues with calling a stored procedure using ..Adapter.ExecuteProcedure

I've just tried something very similar but the pdf files are transferred in via ftp (set to binary) and out by ftp.

I seem to have the base64 output in the OBX segment with \X0D\\X0A\ within it.  If I decode the base64 and copy into a pdf file I get a corrupt message but if I strip out the \X0D\\X0A\ manually and then decode and create a pdf file then it seems fine.

I have added a ..ReplaceStr(target.{OBX(1):5(1).3},"\X0D\\X0A\") for the moment.

Any ideas?  I am using the Ens.StreamContaininer to get the Stream Container ID and then using the code within the DTL to populate my OBX segment.

Thanks