· Mar 22, 2019

Business Service Generator for SQL Inbound

From time to time we develop an Ensemble Production with simple SQL Inbound data from external databases, we need to develop a few new classes. There are at least:

  • 1 Ens.Request class with the fields captured from the SQL ResultSet
  • 1 Business Service class using SQL Inbound Adaptor, and in the OnProcessInput(), copy the relevant field data from ResultSet to the new Ens.Request, and call either ..SendRequestSync() or ..SendRequestAsync().

Let's say, if these codes can be generated automatically in order to make the entire development more "low code". For example, when the Ensemble Production is clicked "start", it first looks up these SQL query statement in BS, and attempt to generate the Ens.Request class, as well as the OnProcessInput() method code of the BS accordingly?

Just wonder if anyone tried doing something like generating these classes according to the SQL query statement in the BS configuration?

Discussion (2)1
Log in or sign up to continue

Hi Joseph,

I developed something like this for a POC last year. It includes wizards to generate Business Services and Business Operations and related message objects based on a source query or stored procedure.

It's not currently in a state where I can share it, but I'm planning to eventually clean it up and post it on Open Exchange. I'll let you know when I do.