Problem:

a company shipping department is requested to send delivery notes data to external transportation company every time a shipment is performed.

Solution:

thinBasic script can be used to:
  • execute a on the fly connection to data warehouse DB
  • extract relevant data by delivery or by customer or whatever
  • create output file in different formats: xml, txt, xls, ...
  • attach file to an email
  • send email to transporter