Getting database value into a rule policy



For the sake of learning Biztalk, I'm running through a number of test
scenarios.

My working orchestration retrieves an infopath form from a sharepoint form
library and changes a value in the form and then puts the form back in the
sharepoint form library. No problems here.

What I would like to get working is for the value that is changed to come
from a database table. In my testing I have a table with a field called
"age" and the value in row 1 is 111. I want to get that value in a rules
policy and set the xml field (also called age) to 111.

Long story short, I added a database fact in the vocabulary to get the value
from the database, but my policy only works in testing. When the
orchestration calls the policy nothing is changed.

One thing I've noticed is that when I test the policy I have to add a
database instance as well as the xml instance. Is there something else I
need to add when calling the policy from the orchestration besides just
sending the message?

solid
.



Relevant Pages

  • Re: Getting database value into a rule policy
    ... You need to have a variable of type Dataconnection ... instances in the composer or orchestration. ... I don't see where I can send a database ... but my policy only works in testing. ...
    (microsoft.public.biztalk.general)
  • Re: Getting database value into a rule policy
    ... is the multi-part message type. ... I don't see where I can send a database ... but my policy only works in testing. ... >> orchestration calls the policy nothing is changed. ...
    (microsoft.public.biztalk.general)
  • Re: Transactional Adapter and Orchestration
    ... loss of the database connection during orchestration processing is my ... Since I have no way to revert the database field value ... back to the original value because I've lost the database connection, ... Microsoft Online Community Support ...
    (microsoft.public.biztalk.general)
  • Re: confusing relationships
    ... Even if some of the people in your database will never be policyholders, ... Do some of these named spouses also have multiple spouses whom you need ... Is exactly one insured person named on each policy? ... ..i have another table which has all policy types (time periods ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Database Corruption after Exchange SP 2
    ... I repaired my Exchange database successfully and I can perform backups ... A conflict in Group Policy can cause these events to occur. ... Windows XP to configure domain policies, you may find that the policies do ...
    (microsoft.public.windows.server.sbs)

Loading