We are sometimes asked for examples of how to do 3rd party SQL database selects/updates/inserts/stored procedures from an Ensemble SQL Business Operation.
In the attached file there are 4 sample Ensemble Operations that demonstrate four different types of transactions with an external SQL DB:
1: The "CheckExists" shows how to use an Operation to do a select statement to see if a given patient MRN exists in a DB
2: The ExecSP Operation shows how to execute a stored procedure from a BO
3: the Update Operation does an Update
4: the Insert Operation does an Insert
Given the samples, one can combine updates/inserts/SPs/selects into a single operation as needed.