At the moment I'm thinking about implementing XML Messaging.
Here is the scenario.
Assume an existing application written in PowerBuilder using mySQL, name it P,
and another existing one written in Oracle Form using Oracle9i, name it F.
P provide a customer data, such as id, name, address, etc.
F provide an exchange rate data, GBP<->USD, USD<->EUR, GBP<->EUR, etc
I would like everytime P's user create or modify any customer data :
1. the data need to be sent using XML to F
2. F sends an acknowledgement back to P.
3. F will do its business process.
Same thing with F, everytime F's user create or modify any exchange rate data
1. the data need to be sent using XML to P
2. P sends an acknowledgement back to F.
3. P will do its business process.
For this case study, a loosely coupled architecture is the best approach.
What I can see, for now, is to create an adapter.
Using a properties file, that adapter will pull out any P/F data
( a new or a modified one ),generate an appropriate XML file,
the send into a JMS Server. So it will do #1, #2, and #3.
For that, the data model within P and F need to be changed.
A new column need to be added in both customer data and exchange rate data.
Possible values for that column are, for example :
1. 'N' new data
2. 'M' modified data
3. 'X' XML file generated
4. 'D' done
With this approach, the existing P or F remains unchanged, only the data model.
Another possibility is to modify the existing application P or F push out any
new or modified data, then generate the appropriate XML file. That's it.
Neither PowerBuilder or Oracle Form don't know how to send it into JMS Server.
Any comments on this case study ?
This case study is pretty good to experiment with XML messaging. I have one question Are you going to develop
adapters. If yes then it should be XML adapter.
Since you are integrating two different application, you
have to develop different XML adapter.
So my question is Cant it be generic enough to take care both different application.
Thanks for your reply
>I have one question Are you going to develop adapters.
That is my intention.
>If yes then it should be XML adapter.
Do you know any whitepapers,articles,etc ?
>So my question is Cant it be generic enough to take care >both different application.
The purpose is to build a generic one using a properties file to differentiate.
Any comments ?
AFAIK, developing an generic custom adpater helps you to solve your problem..
Also make sure that your architecture is based on HUB and spoke model so that it will support loosely coupled interactions, easy extensibility and resusability..
Some of the Application Server Vendor based Integration tools follows this approach...Oracle9iAS intergration platform uses this architecture..
Hub and spoke IS the model that I'm looking for, as well as
XML adapter. But for me, they are both obscure as will P/F push the data out or the adapter will pull them out ?
Oracle9i InterConnect, and other vendors, such as Sun, IBM, BEA, they are all using hub and spoke model.
My case study is very simple for a very simple existing application. I've read somewhere, that either P or F need to push the data out as an XML file into a directory, then the adapter plays as an observer. This means changing the existing application, which I want to avoid.
That left me to other option, which is change the data model, and everything is controled by the adapter.
Any comments ?