Can BizTalk perform a synchronized request?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Can BizTalk perform a synchronized request?

Viewing 1 reply thread
  • Author
    Posts
    • November 23, 2005 at 4:31 PM #14243
      community-content

        hi guys, sorry i’m extremely new to BizTalk product but my company want me to look at it as a potential platform.

        I just wonder that can BizTalk do a very simple task in the following use case:
        – A user send a request to query data from oracle, instead of making a web service as a business layer, i want to add biztalk in the middle tier and use a oracle adapter to retrieve data. but then i wonder how can the user get a response in real-time if i put a biztalk in the middle layer. is it possible or what kind of process management model i should use?? ❓

        Thanks.

      • November 24, 2005 at 11:04 AM #14244
        community-content

          thanks stephen! it sounds simple.
          so if i understand correctly. in the demo, i will suppose to create a portal using asp .net that consumes the web service from biztalk. and from biztalk side, i will use oracle adapter to retrieve data from oracle db?

          can you point to me a more precise example, is it one of the tutorial that comes with Biztalk 2006 beta 2 ?

          thanks again.

          • November 25, 2005 at 4:03 PM #14245
            community-content

              hi again.
              i found the sample exposewebservice for orchestration process, it seems to be the one i’m looking for. actually the documentation for biztalk beta2 2006 has not been updated yet so it still refers to the 2004 version.

              i’ve a few questions to ask:
              1. in the orchestration process when i need to retrieve date from oracle using oracle adapter, does it require that the query result must be in an xml format as it is for sql adapter? sorry i lack of documentation here….
              2. it sounds like i don’t need to use a pipeline concept, does it correct?
              3. when i run a sample with exposewebservice for orchestration, i assign IIS security as anonymous and i also need to assign aspnet user to sql server in order to make it work, what is the right approach in the real scenario?

              thanks in advance

              • November 24, 2005 at 6:03 AM #14246
                community-content

                  I think in this case you would use an Orchestration to receive the request and send the response back.

                  Then, you could expose this Orchestration as a Web Service. The Web Service would be consumed by the user either through .net, Infopath, or Sharepoint.

                  This would work well since you would keep the calls from the user consistent and just modify the Orchestration as needed to add extra steps, replace Oracle with SQL, or anything else you needed.

                  If you download the BizTalk 2006 Beta 2, it has a sample that I think is close to this. Just make sure you get the Oracle Adapter download, since it’s separate.

                  Best of luck.

                  • November 24, 2005 at 3:02 PM #14247
                    community-content

                      I have not looked at the samples that ship with 2006 yet so I can not really point to in the right direction there. See if the SDK has something on web services. Or, check msdn for the Biztalk and Web Services white paper.

                      You will also need to use the Web Service Publishing Wizard to publish your Orchestration as we web service. Make sure you set your ports as public.

                      Best of luck.

                      • November 25, 2005 at 7:37 PM #14248
                        community-content

                          1. I think it is just like the sql adapter – although the adapter probably turns the Xml input into something else. Did you check the sample included with the Oracle Adapter? I do not know if you can do a dynamic select though. The receive adapter wants something to be defined or to call a stored procedure.

                          2. No, I don’t think you need to use the pipeline concept.

                          3. I think you should just need add the aspnet to the BizTalk Application Users group. That user needs to have rights to write to the message box.

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