Merge data from a sql DB into a Named Datasource 追蹤

Carsten Davidsen

How to merge data from a sql DB into a Named Datasource, using a variable provided in My Web Service Integration.

Im using BT 2016 Enterprise Automation.

My label has 3 text objects whit a Named Datasource Text1, Text2, Text3.

My Database has 4 colums, Lookup, Text1, Text2, Text3.

In my web service integration I pass a variable <NamedSubString Name="Lookup"><Value>#Material_Number#</Value></NamedSubString>

I want to use the #Material_Number# value as lookup in the Database and merge the data from the columns Text1 Text2 Tex3 to my BT document and print it.