Connect to JD Edward

[DKotian518]

Hi,

How can I connect to JD Edward from Talend Open Studio for extracting the data?

Thanks

[gjeremy1617088143]

Hi, maybe you could try to use tRest components and acces the data by the JD Edward api ?

https://docs.oracle.com/en/applications/jd-edwards/cross-product/9.2/rest-api/

Send me love and kudos

[Anonymous]

Hi

Go to check whether JD Edward provides Restful webservice or support JDBC access? if so, you can use talend component such tRest to call the API or tJDBCxxxx components to integrate with  JD Edward.

Regards

Shong

[jscantamburlo]

Hi, I ever used tDBxxx components (such as tDBInput) connecting to JDE database. However, it depend on the product and the access you have to the infrastructure: Is it JDE World or One? Is it hosted on-premise or cloud ? Can you specify the product and tool versions ?

Another thing to consider is the nature of data to extract: transactional modules (SOM, AR, AP, GL, ...), master data ( Items, addres book, customers, suppliers,... ), detailed or summarized. Is the target system a data warehouse, a kind of Web application, a ML training data ?

Regards.

Javier.-