Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Question Unanswered: ORACLE & MS SQL Connectivity

    My client require e-commerce website and expected to have more than 100,000 products online. All products currently manage on Oracle Application server which is behind the firewall.

    Initially all products will be uploaded to online ms sql server and then whatever the products get change on oracle should be updated online on ms sql db.

    We need proposed solution under secure and easy method to keep online products DB according to the oracle system.

    All this process should be Automatic and Oracle application server send only updated data to MS SQL SERVER because client has more then 100,000 products on their ORACLE Application Server.
    Attached Thumbnails Attached Thumbnails ecommer-connectivity-with-oracle.jpg  

  2. #2
    Join Date
    Jun 2004
    Liverpool, NY USA
    Use the data on the oracle server directly. Why keep copies of data on the sqlServer machine. Simply setup a DMZ and have a passthrough that will send the selects (and any updates) through to oracle. If you are not familar with a DMZ, user the search term "firewall dmz" on google. However, if you want to use the SqlServer, then have a trigger on the catalog table that will immediatly send any inserts or updates to the sqlserver through a database link.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts