title: The ways of Database Integration in SOA/ESB?
body: <p><em>Situation: Some Bank has an old legacy ABS (Automatic bank system).</em> </p>
  
  <p>Bank wants to:</p>
  
  <ol>
  <li>notify old legacy CRM system about client's account changes (Publish operation).</li>
  <li>check PIN codes of client cards (Request/Response operation) - in synchronious mode.</li>
  </ol>
  
  <p>ABS is implemented in very old private technologies with StoredProcedures calls. So, I can connect to this system via database only.</p>
  
  <p>Which ways of Java/.Net (ESB) application integration with old/legacy database system do you know?</p>
  
  <p><strong>Write/Publish operation</strong></p>
  
  <p>Any vendor's databse server:</p>
  
  <ol>
  <li>Scan tables for new entries - too low speed.</li>
  <li>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.</li>
  <li>Oracle serevr : PL/SQL TRIGGERS + Oracle AQ. And listener for JMS.</li>
  </ol>
  
  <p><strong>Reading operation</strong></p>
  
  <ol>
  <li><p>Just write result into tables of ABS - dangerous.</p></li>
  <li><p>...</p></li>
  </ol>
  
  <p>How to notify legacy database system about responses in synchronious mode??? How to implement Write/Read in synchronious mode???</p>
  
  <p><strong>Again, which ways of Java/.Net (ESB) application integration with old/legacy database system do you know?</strong></p>