Extracting data from JDE

[Guest_imported]

Hello,
We need to extract data from an JD Edwards(7.3) system with SOP,MRP modules installed.The data needs to be in flat files or CSV or any other format.Does JDE provide any open API's for this purpose or are there any third party tools that can do this ? Any pointers to achieve the above would be great.Any documentation for the same can be kindly mailed to prakash_murali@hotmail.com.
Thanks for your time!
-Prakash

 

[AppMgr]

Parkash,

There are some quick and dirty things you can try. I am also working under the assumption that you are on an AS/400.

1. Create a world writer of the data you want and output it to a file. Use IMB's Client/Access File Transfer utility to transfer the created file to your PC. There are options for what kind of format to use ASCII, CSV, etc..

2. You can also pull down spool files using IBM Client Access Navigator.

Good luck.

 

[Guest_imported]

There is a way to do it nicer.
There are ODBC API or you can use OLE DB to download data to PC to use in your application.
ODBC driver is installed together with Client Access.
For OLE DB you need to have Client Access Express.
Performance is better when you code directly to ODBC API but you can also use dome other thechniques like sql paththrough or rdo in VB as well.

 

[7chris]

If you are using OneWorld then there are two things that you can do.

1. Write custom UBE to extract the data. Print it to CSV file or output it to a custom table.

2. There are APIs. There are documents in KG under publications and product support knowledge sections.

using OW Xe

 

[Tavio]

Have you looked at all the outbound Z file processes? This is the first thing you should do. If these are not enough you should look to use the DB Out option in the UBE and create an external Fixed Length or Delimited file.

 

[Dasgupta]

Other than outbound Z process in JDE, you can also use your own batch FTP programs for ftp data from as400 to other systems.the process will have to steps:
1. prepare flat files in as400 end
2. ftp those flat files to the target system.

For step1:
you can use : CPYTOIMPF AS400 COMMAND use comma delimiter and (&quot as string delimiter while populating flat files in as400 then send it via ftp.
For step2:
use FTP subcommands like:
put lib/file1 c:\download\dwnfile1.csv
put lib/file1 c:\download\dwnfile1.xls
put lib/file1 c:\download\dwnfile1.txt

to get csv or excel or text files at the other end as you r coice

regards,
dasgupta


dasgupta