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.
Ex:-
SELECT wl.city||'',''|| wl.state
FROM wsh_locations wl,--Ebus Table
shipment_stop@'|| p_database_link || ' sstp_otm,--OTM Table
wsh_trips wt --Ebus Table
WHERE wt.attribute1 || ''.'' || wt.tp_plan_name = sstp_otm.shipment_gid
+ Another joins..