Re: JD EDWARDS to 11i Conversion
- From: Luis Freitas <lfreitas34@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Mon, 26 Jan 2009 10:38:06 -0800 (PST)
Sridhar,
If you are brave enough, you could use Oracle Enterprise Service Bus
to read the data from JD Edwards and load it into Oracle. There are
other tools that can do this, for example, Webmethods. But keep in mind that
these tools are intended for integration, and not for a conversion job.
A more conservative way would be to manually create load
processes for each type of business object, e.g. invoices, suppliers,
account balances, purchase orders, etc, dumping the data from JD
Edwards into text files, xml files or tables, and loading the data into
the Oracle open interfaces. This would probably be a several months
project, unless the customer is really small.
If you dont want to use the text files, you could access the JD
Edwards database indirectly using a Oracle Transparent Gateway
(Expensive) or a ODBC driver and the Oracle Gateway for ODBC.
Regards,
Luis
--- On Mon, 1/26/09, Reddy, Sridhar <SReddy@xxxxxxxxx> wrote:
From: Reddy, Sridhar <SReddy@xxxxxxxxx>
Subject: JD EDWARDS to 11i Conversion
To: ora-apps-dba@xxxxxxxxxxxxx
Date: Monday, January 26, 2009, 1:29 PM
Hi Guys,
I got this unique request to explore into the conversion
process from JD Edwards financial system (AP, AR, GL) into 11.5.10.2. Do
you guys know of any tools from oracle or third party to convert the
data? What are the options that might be available to do this?
Thanks for you help.
Sridhar Reddy
DBA
The Newark
group
Cranford,
NJ
908-276-4060 x205
Other related posts: