Re: Querying a DB and sending Email based on query output



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.
> >>
> >>
> >>
>
>
>
.