Re: Querying a DB and sending Email based on query output
- From: "BA" <biztalk.architect@xxxxxxxxx>
- Date: Tue, 7 Jun 2005 18:43:44 +0200
Yes,
xmltools has one and a few others, search google for biztalk 2004 sybase
adapter.
"SAJJAS" <SAJJAS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8FF07E4F-61F6-4BED-9506-F822B93B5D6A@xxxxxxxxxxxxxxxx
> BA,
>
> Wondering if there is an adapter for Sybase database, because i want to
> perform the same task against another sybase database too.
>
> Please let me know and thanks for all your help.
>
> --
> SAJJAS
>
>
> "BA" wrote:
>
>>
>> Hello,
>>
>> Your going to have to write your query and probably save it as a stored
>> procedure, then the SQL receive port can execute the query and start
>> orhestrations.
>>
>> Next use a "decide" shape in your orchestration, setting a condition on a
>> value > 100, if the condition is true, send the mail in that branch,
>> else,
>> do nothing
>>
>>
>>
>>
>> "SAJJAS" <SAJJAS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:C4E3AF19-4DA3-4AB4-9C8E-138ED7D4714F@xxxxxxxxxxxxxxxx
>> > BA,
>> >
>> > The exact specifics i am looking at is
>> >
>> > a) writing a grouped query against a table
>> > b) the output column value needs to be checked for it its greater than
>> > 100
>> > c) If greater than send email
>> > d) else do nothing and proceed to next record of the query.
>> >
>> > Please let me know
>> >
>> > --
>> > SAJJAS
>> >
>> >
>> > "BA" wrote:
>> >
>> >>
>> >> Hello,
>> >>
>> >> Here are a few things to look at to get you started:
>> >>
>> >> You'll probably want to use the SQL adapter, since you are using SQL
>> >> 2000,
>> >> look in the SDK for examples of the implimentation.
>> >>
>> >> It sounds like you want to poll SQL server, so you'll need to learn
>> >> how
>> >> to
>> >> set up a SQL receive location.
>> >>
>> >> For output, you can use the SMTP protocol. You can configure a send
>> >> port
>> >> with your email address credentials.
>> >>
>> >> The message for the email can be created in a host of ways, the
>> >> mapping
>> >> tool
>> >> may be right for you.
>> >>
>> >> Cheers,
>> >>
>> >> BA
>> >>
>> >>
>> >>
>> >> "SAJJAS" <SAJJAS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:D1974B86-29DA-4230-8B51-7FC431B5DEC8@xxxxxxxxxxxxxxxx
>> >> > Hi,
>> >> >
>> >> > I am new to biztalk 2004 and have the following requirement.
>> >> >
>> >> > a) Query a table in SQL Server 2000
>> >> > b) Based on output send an email.
>> >> >
>> >> > I would like to use biztalk 2004. In this regards would like to get
>> >> > suggestions as to what needs to be used and the procedure to do the
>> >> > same.
>> >> >
>> >> > Appreciate your help.
>> >>
>> >>
>> >>
>>
>>
>>
.
- References:
- Querying a DB and sending Email based on query output
- From: SAJJAS
- Re: Querying a DB and sending Email based on query output
- From: BA
- Re: Querying a DB and sending Email based on query output
- From: SAJJAS
- Re: Querying a DB and sending Email based on query output
- From: BA
- Re: Querying a DB and sending Email based on query output
- From: SAJJAS
- Querying a DB and sending Email based on query output
- Prev by Date: Re: Binary Files,
- Next by Date: Re: re:BizTalk 2004 :: Moving .sln to new computer forces recompile
- Previous by thread: Re: Querying a DB and sending Email based on query output
- Next by thread: Deployment WMI Script
- Index(es):
Relevant Pages
|
|
