DB XML Web Service

DB XML Export and Import can also be performed by calling a SOAP Web Service running on the Application server. The WSDL for the service will be found under:

https://<server:port>/GC3Services/CommandService/call?WSDL

The server and port are specific to the host and port configured for the WebLogic server running Transportation and Global Trade Management Cloud (aka the Transportation and Global Trade Management Cloud application server).

The service is secured via Web Service Security in common with all other Transportation and Global Trade Management Cloud Web Services and so by default requires the WSS Username Token Profile over HTTPS for authentication.

The SOAP messages (defined in the WSDL) are essentially identical to the messages used for the DB XML Servlet but will be ‘wrapped’ in the corresponding command/operation name, that is:

<xmlExport>
   <sql2xml>
     <…elements as described previously>
   </sql2xml>
</xmlExport>

and

<xmlImport>
   <xml2sql>
     <…elements as described previously>
   </xml2sql>
</xmlImport>