you can define a message class for your JSON message. then set up your transform to transform the data from the HL7 message to the JSON message. then in your business process use the built in SQL commands to store the JSON string in SQL Server. 

Thanks for the help Vic, Ben and Evgeny,

You have provide some good information and I am going to try both the Project in Studio deployment and also try the Ens.Deployment,Utils to see which one works best for our needs.

Phil has no followers yet.
Phil has not followed anybody yet.
Global Masters badges: