Is it possible to query an on-premise internal to my Org SQL database within a MT IPA?
Unfortunately, no. Infor will not allow the use of the SQL node in MT IPA. You would have to get at that data in other ways. You could have a database process to query the data required and stage it in a CSV file that MT can read in your flow. You could use .NET, for instance, to create a API that would allow you to query the SQL. You can call API from MT and pass parameters to it. The API would then return the database results based on your input. It depends on how technical you want to get. The only process I have found that can query on-prem SQL is ION. There could be other options that I am not aware of, so I am hoping others will respond to this.
