Without Using Database Links how to call OTM tables Data in eBus packages
Summary:
As of now we are using the Database link in all our eBus packages to get the shipment related data from Oracle Transport Management system
which is in ON-PREM application . Mostely we are selecting columns from OTM tables and joining with eBus tables.
Now we are going to use OTM cloud and hence we are not going to use database links anymore and trying the best possible ways to get the data from OTM.
Could you please suggest if any Rest API/SOAP APIs available or Is there a way where we can call directly from OTM database.
Content (please ensure you mask any confidential information):