I'm new to BPM. I have a scenario that I need to fetch a single record from an external oracle database table , in the middle of a BPM process. Is it possible to connect & query a oracle table from BPM (may be automated activity?) ? Please help.
yes, as Jun Wu already said, you can write an EJB. The other option, if you've the full PO installation would be to implement an iFlow with a JDBC adapter at the end.
From my own personal experience consulting for the High Tech industry, full PO installation would be to implement an iFlow with a JDBC adapter at the end, wIth that it makes it easy and faster to fetch single record from an external oracle database table and making record indexing easier particularly if the query is fetching from large database or datawarehouse.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.