Kbase P12668: How can data be retrieved from an Oracle database via SonicM
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/27/2003 |
|
Status: Unverified
GOAL:
How can data be retrieved from an Oracle database via SonicMQ and then placed into a Progress 8.x database using a Progress 9.x client?
FIX:
In order to accomplish this goal the following things need to be done:
1) Write a program which connects to the Oracle database, retrieves the required data and sends that data to SonicMQ.
2) Ensure that the Progress 8.x database has been started using the '-S' startup parameter so that it will accept a client/server connection.
3) Write a program in Progress 9.x using the Sonic Adapter which connects to the Progress 8.x database using the Client/Server mode, listens for and retrieves messages from SonicMQ that were written by the program in step #1 above then parses the messages and updates the appropriate tables in the Progress 8.x database.