|
Home > Archive > BizTalk Server Orchestration > February 2005 > query database in orchestration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
query database in orchestration
|
|
|
| I'm a newbie in BTS 04.
I want to ask about Orchestration. Could I make some query from database for
conditional in Orchestration ?
So when a schema is received, the orchestration check a value of the field
of that schema and compare it with the value in a table of database. If the
value is available, the orchestration will accept that request.
Thank you for your attention
| |
| Sasidhar Parvatham 2005-02-25, 5:49 pm |
| Yes it can be done. There are different ways to do it... One is...
1. Write a class which accepts a field and checks database for that value.
2. Reference that class in your Biztalk Orchestration and use it in your
orchestration
"Atjeh" <Atjeh@discussions.microsoft.com> wrote in message
news:18C6EFB3-62B0-4063-859B-B17A4570D265@microsoft.com...
> I'm a newbie in BTS 04.
> I want to ask about Orchestration. Could I make some query from database
for
> conditional in Orchestration ?
> So when a schema is received, the orchestration check a value of the field
> of that schema and compare it with the value in a table of database. If
the
> value is available, the orchestration will accept that request.
>
> Thank you for your attention
>
>
| |
| Neal Walters 2005-02-25, 5:49 pm |
| 1. Call the Stored Procedure (see details below)
2. Life is easier if your promote or distinguish the elements to compare in
both the SQL Response Schema and the Incoming Schema. Or you can use the
XPATH keyword in an expression shape instead.
3. Use a simple decision shape to compare two values.
4. You could terminate or throw exception or just do nothing when values
don't match
To call a Stored Procedure:
1. Build your SP with "for xml elements, xmldata"
2. Run SQL adapter (ignore the dummy orchestration it builds)
(remove ", xmldata" from SP after running adapter)
3. Create send/receive shapes in orchestration
4. Associated Request/Response schemas from SQL Adapter (to send/receive
shapes)
5. Create a physical Two Way Send Port - Request/Response with transport
type SQL
(match the target schema namespace and root element with the ones you
specified when you ran the adapter in step 2 above).
6. Create an two-way orchestration port that you will bind to your physcial
Two Way Send Port.
7. After the receive shape, you can then add your decide shape and compare
the two values.
Neal Walters
http://Biztalk-Training.com - SQL Videos now available
"Atjeh" wrote:
> I'm a newbie in BTS 04.
> I want to ask about Orchestration. Could I make some query from database for
> conditional in Orchestration ?
> So when a schema is received, the orchestration check a value of the field
> of that schema and compare it with the value in a table of database. If the
> value is available, the orchestration will accept that request.
>
> Thank you for your attention
>
>
|
|
|
|
|