Building the integration

With an agent deployed, having addressed the reasons for having an agent, we can explore our scenario. As mentioned in the introduction in this chapter, we are going to demonstrate the detection of additions or changes to Airport data within an on-premises database by a connection agent. The database records that are detected as having been changed by the agent are then sent to the core ICS server running in the Oracle cloud to pass through the integration and be transmitted to the target. This reflects the sort of scenarios you could find when perhaps needing to integrate an on-premises E-Business Suite (EBS) that uses the idea of open tables as its interface. EBS, like many enterprise solutions, will offer an interface by exposing a view of its data that the outside world can interact with.

When we detect the data change on the on-premises database, the record will be retrieved and concatenated into a string that is sent to a Mockable REST endpoint. This second...