Oracle EPM cloud to AWS Latency issue.
We are using EPM integration agent to do writeback from EPM cloud to a data warehouse in AWS. We are seeing significant latency while doing this writeback. The ping test from AWS to Oracle cloud is showing us four hops and Minimum = 38ms, Maximum = 59ms, Average = 43ms. Because of this latency it takes about 8.5 hrs to writeback 7 million rows which is not acceptable to the business process. Both AWS and Oracle cloud servers are in East coast. Is there anything that can be done on the oracle side to reduce this latency? On-prem this would have been completed in about 3 hrs.
0