Hi Friends,
can some body help me in designing the below scenario: MY QUESTION IS HOW WOULD THIS INTERFACE LOOK LIKE?
Objective:
To design an interface for the following scenario. See attached image for visualization.
Scenario:
1. There is an Application X (May be a VB or Java application) and it has its own Oracle DB.
2. There is another centralized SQL SERVER 2005 HUB ( a centralized repository for many OTHER applications ).
3. There are tables pertaining to "Application x" in the HUB which would be mapped to appropriate tables and columns in Application X's Oracle DB.
4. If there is an insert\Update\Delete in the HUB (only in tables specific to Application X) then those records need to be accordingly inserted\updated\deleted in the Application X's Oracle DB.
5. The exact requirement is an Interface should be designed to reside between the Application X(including its Oracle DB) and the HUB.
6. Now, how would the interface look? Please refer to the attached image for visualization.
NOTE:
1. This interface should be executed on an hourly basis to pull data from the HUB to update the Application X's Oracle DB.
2. Just the design, need not be technology specific while designing the interface.
***************************************************