Triggers in biztalk

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Triggers in biztalk

Viewing 1 reply thread
  • Author
    Posts
    • November 19, 2005 at 5:09 AM #12373
      community-content

        we want to integrate two databases using biztalk server.

        Whenever a entry is make into one database particular field in another database should be update. So any triggers are provided in biztalk to do this.

        If yes then tell me how to use that trigger or give any other approach to do this.

        Thanks in avanced

      • November 19, 2005 at 5:39 AM #12374
        community-content

          You might want to be careful here, there are many ways to integrate two databases and Biztalk might not be the best way.

          Biztalk can not directly react to triggers.

          You could have your trigger gather up the required data and send it to Biztalk via a queue. Or write the data to a SQL table and use the SQL adapter to extract out the data.

          Hope this helps.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.