How to setup an Integration between Oracle WMS and the Integration Platform Follow

Avatar
Jasper Wen

BarTender Content Team


Question

What steps do I follow in order to integrate Oracle WMS (XML based) with the Integration Platform?

Answer

Integration Setup

The following outlines how the Oracle WMS integration should be setup for the Integration platform.

  1. Oracle WMS XML data is sent to the Integration Platform via (file integration, TCP/IP socket integration, web service integration etc.)
  2. Oracle WMS XML data is transformed into BTXML using the "Oracle WMS Print Request to BTXML" integration action.
  3. The BTXML is executed using the "Print BTXML script" integration action.

Image_1465.png

See attached OracleXML.btin file.

BarTender document setup

  1. Text delimited data is used to print. The text file database connection setup is defined in the BTXML directly. You do not not setup a database connection in the BarTender document.
  2. The "variable name" parameters in the Oracle XML data get mapped as database fields and data passed into the BarTender document to print.

Image_1464.png

See attached Material.btw and Material.xml file.

These Oracle WMS samples are installed with BarTender and located in: C:\Users\<user name>\Documents\BarTender\BarTender Documents\Oracle.

More Information (Optional)

Note, in order BarTender/Commander legacy versions, the XML2TXT.exe and a Commander operating system command was used to convert the Oracle WMS XML data to BarTender command script data instead. The BarTender command script was then executed by Commander/BarTender to print.

Do you have feedback or questions on this article? We encourage you to post them on our Community Forums