Wednesday, March 7, 2012

Importing data from JD Edwards into SQL Server

Can anyone help me'! What is the best way to import data from JDE (One
World) into SQL Server? If it's possible to use DTS then should I use the
OLEDB connection object?
Many thanks,
SteveHi Steve.
For what it's worth, I've just completed a project where DTS was used
heavily for integration between SQL Server & JDE (AS400) over IBM's Client
Access ODBC drivers and this has worked very well.
Regards,
Greg Linwood
SQL Server MVP
"Steve McDonald" <ajones1@.nsw.bigpond.net.au> wrote in message
news:5uPQa.4957$wU5.4278@.news-server.bigpond.net.au...
> Can anyone help me'! What is the best way to import data from JDE (One
> World) into SQL Server? If it's possible to use DTS then should I use the
> OLEDB connection object?
> Many thanks,
> Steve
>

No comments:

Post a Comment