Using A Named Data Source To Aid In Oracle Query Follow
I am attempting to use BarTender (via Commander) to print custom shipping labels from our WMS system. The most direct means would be to export a few pieces of common data that could be used in a database query inside BarTender to get the actual label data.
Example, I would export a carton_number that would be used in a script to create a simple BTXML file. Inside the BTXML file a Named Data Source would be set, and that would be used inside BarTender to query the shipment's corresponding customer PO, Carton Qty, etc from the Oracle database.
We are trying to keep the exported data to a bare minimum to allow the WMS side to be the same for all customers and only the custom labels designed in BarTender would differ, depending on the data required.
I have seen comments in the forum from support stating that using a Named Data Source in a SQL Query is not supported, and in another question support provides an example on how to do this that me nor the original requester could get to work. If this is indeed not supported, it would seem to be an oversight/limitation of the software.
How is it recommended I proceed? Exporting additional data from the WMS system to cover all possibilities is NOT an option. Nor is anything requiring user intervention. This is a high speed automated process.
Please sign in to leave a comment.