We have an Oracle application which holds some account data. We need that data to come over our QAD (Progress) DB, that data is then used to create GL transactions which in turn are summarized and sent back to Oracle. This has been working using nightly batch jobs processes that extract and transfer ascii files back and forth between Oracle and Progress. Although this seems to work, I am sure there must be a more efficient way of accomplishing the same thing. I am looking for suggestions as to what has worked for you out there.
Progress Dataserver to Connect to Oracle? ODBC from Oracle to Progress?
Is it possible to use WebServices between these two? Something else?
Any idea/suggestion is very welcome...
That kind of interaction sounds like a natural for Sonic or DataExtend.
All the solutions you mentioned are possible:
1) connect DB Oracle over Progress Data Server for Oracle
2) JDBC from Progress to Oracle via OS-Command
3) JDBC from Oracle to Progress SQ92
4) JMS over SonicMQ/ESB
5) file transfer
6) WebServices exposed/invoked
In my opinion, the most simple/evolutive solution is to expose in Progress some WebServices (!! v.10+),
to expose some WebServices in Oracle Application and to build a communication level betwin both
applications.