You can export data out of OTM using DB.XML method. its cleaner than using CSV and you can also retrieve required child records along with parent.
For example : to retrieve Shipment and associated shipment_stop records , use below query in DB.XML Export option
Query :
select shipment.*,cursor(select * from shipment_stop where shipment_stop.shipment_gid=shipment.shipment_gid) as shipment_stop from shipment where shipment_gid in (’ABC.1001’,’ABC.1002’)
Root: SHIPMENT
In OTM, you can import a XML file to test your transaction templates by manually uploading them in Integration Manager. This process would not essentially simulate the way transactions are sent to OTM through Middleware. You can also use this to load test by sending large number of transmissions to OTM (using Bulk Load from Folder)
You can use below tool to post a transmission to OTM servlet to simulate external system.
Use URL as-
http://yourhost:port/GC3/glog.integration.servlet.WMServlet
Select required XML File. Make sure you set USERNAME and PASSWORD nodes as required..
/* This program is free software. It comes without any warranty, to
* the extent permitted by applicable law. You can redistribute it
* and/or modify it under the terms of the Do What ever you Want
* To Public License, Version 2, as published by Sam Hocevar. See
* http://sam.zoy.org/wtfpl/COPYING for more details. */Download Here <>