We have a requeriment that consists of accessing up to 25 different databases (different IPs as well) and so gather the messages and populate them to SAP. So, there are 25 different data sources with 40 different messages in each one of them.
The whole process is intended to be performed by a BPM, but we wanted to avoid using so many number of objects in the scenario.
My questions are:
is there any way to achieve it by using dynamical JDBC requests (sender or receiver)?
Can we determine the jdbc connection parameter dynamically form he payload?
Do you guys know any other workaround?
I have also though of calling the XI from the DBs (stored procedure) but unfortunately, data source processes cannot be modified right now
Any input will be much appreciated.
Thanks a lot in advance and best regards,