I am performing a simple XML to XML translation..
Within the input XML message. I need to access SQL server and retrieve a value. For example, maybe validate a sku by checking it's within the ERP database or retrieve a sku attribute.
I've completed the XML to XML XSLT map. I've also created a custom database table in ION from the SQL Server.
How can I retrieve a database value based on the input file data and output the value to the resulting XML?
For example, I may need to retrieve the size of the SKU ID send in the input file
<INPUT><SKU><ID>TSHIRT5</ID></SKU></INPUT>
Output would then include the size which is retrieved from the SQL Database
<OUTPUT><SKU><ID>TSHIRT5</ID><SIZE>XL</SIZE></SKU></OUTPUT>
