How to specify input location dynamically?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to specify input location dynamically?

Viewing 1 reply thread
  • Author
    Posts
    • November 21, 2005 at 1:29 PM #12378
      community-content

        Hi,

        I am going through SQL adapter samples provided along with Biztalk server 2004. Here in that samples i found that for input to any of biztalk server sample we have to specify the input location.

        But i want to give it without specifying that input location.

        Is there any way to do this?

        Also, I dynamically want to take records that have been recently added to the database, convert them into XML format, Do some action on them and insert into other database(different from first) and vice-versa.

        Do I have to do timely polling for new records?

        Thanks in advance

      • November 22, 2005 at 11:14 AM #12379
        community-content

          I have to call web service through biztalk orchestration without passing parameter to it.
          Is it possible to call web service through orchestration without sending parameters.

          And if my web service consists of different function then how can i called only specific function through orchestration?

          Thanks in advance

          • November 22, 2005 at 11:38 AM #12380
            community-content

              In last reply of input location dynamically you have mentioned [b:69c4b742ed]Queue[/b:69c4b742ed].

              So actually what is meant by queue?

              Is it a [b:69c4b742ed]Message Queue [/b:69c4b742ed]of computer?

              • November 21, 2005 at 4:11 PM #12381
                community-content

                  As far as I know you have to do a timing type polling if you want to use the SQL Adapter. You can, of course, build your own adapter or get the record into Biztalk through some other method – like having triggers write message to a queue.

                  As far as dynamic input, as far as I know that is not possible. Receives into Biztalk through the SQL Adapter have to be known locations since it works on a polling bases.

                  Hope this helps.

                  • November 22, 2005 at 5:43 PM #12382
                    community-content

                      Queues – yep I was talking about MSMQ Queues. You might be able to have a trigger in SQL collect the data and then send it to a MSMQ that biztalk will monitor. We did something like that with an integration project into Great Plains.

                      As far as web services go, in Biztalk 2004 if you want to call them without an Orchestration you need to use the WSE Adapter. Other then that, I have not worked with web service calls too much so you best bet would be to test it out.

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