Сен 27th, 2008База данных
С изображениями как соединить приложения и старую систему на основе RDBMS.
Oracle сервер
1. PL/SQL TRIGGERS + Oracle AQ.
Любая RDBMS
1. Просмотр таблиц.
================
Situation: Some Bank has an old legacy ABS (Automatic bank system).
Bank wants to:
- notify old legacy CRM system about client’s account changes (Publish operation).
- check PIN codes of client cards (Request/Response operation) - in synchronious mode.
ABS is implemented in very old private technologies with StoredProcedures calls. So, I can connect to this system via database only.
Which ways of Java/.Net (ESB) application integration with old/legacy database system do you know?
Write/Publish operation
Any vendor’s databse server:
- Scan tables for new entries - too low speed.
- Trigger (if they’re supported) which handles SQL updates and inserts and writes event information to some table. And application listener should be checking this table for events.
- Oracle serevr : PL/SQL TRIGGERS + Oracle AQ. And listener for JMS.
Reading operation
-
Just write result into tables of ABS - dangerous.
-
…
How to notify legacy database system about responses in synchronious mode??? How to implement Write/Read in synchronious mode???
Again, which ways of Java/.Net (ESB) application integration with old/legacy database system do you know?
Ресурсы:
1. Этот вопрос я поднимал на StackOverFlaw.com.