Re: JDE and SQL Server

#1

How is the person receiving the request in the first place ?
It seems that it is this step that should be Database linked.
You could perhaps put it in a holding Queue until processed by whichever
department and then load it to the correct tables when the items are
shipped.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jam P." <jp (AT) somewhere (DOT) com> wrote

Quote:

Hello all,

I have a workflow problem. When customer service
receives a request, they send out an email saying you will
receive your missing parts and you'll receive it by
whenever.

Then she prints out that email with all the contact
info and someone else has to enter it in JDE so that it
can actually get shipped.

Two processes when it should be one, would anyone know
how to merge this step? Obviously a database is needed,
perhaps XML can play a part, but what are your opinions on
this and how would I merge the two?

Also, if I wanted data reporting, marketing analytics
on say what is asked when on customer serview viewpoint,
should this be done against JDE or analysis services?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: JDE and SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: JDE and SQL Server - 10-01-2003 , 12:29 PM