Q
Problem solve Get help with specific problems with your technologies, process and projects.

Integrating SAP and JD Edwards

Naeem Hashmi
Information Frameworks
Follow:
In my company we have 2 ERP systems running. One is SAP R/3 and the other is JD Edwards. My question is: Does SAP BW support an integration of JDE file structures into the EDW? If so, can you explain the mechanics and what customers are currently doing it? We are considering SAP BW as a possible solution to bring the two ERP information formats together.
SAP BW 3.1C does not offer any content for JDE OneWorld data objects. You can use BW to manage JDE data. You have a few options: If you have a 3rd party ETL tool, like Informatica or Ascential, then you can directly schedule jobs in BW to extract data from JDE and load in BW (alongside with what comes from SAP R/3). Here you need to map the transfer structure in BW with incoming data (from JDE or SAP R/3). Your second option: Currently, you may have a data extraction program in JDE that generate flat files for your present DW. If so, simply take the same file and load it directly in BW (PSA and ODS). Then everything should be under BW control. The third option: If you have database tables or views in a JDE Oracle or MS SQL database, use the DB Connect-option in BW to directly connect such tables/views and you will be all set. I know companies like Kodak and Scott loads a lot of non-SAP data in BW along with SAP R/3. Take a look at their presentations at ASUG BITI event (www.asug.com) held October 26-29, 2003, and see how they have implanted such integrated SAP and non-SAP data in BW.
This was last published in November 2003

Dig Deeper on SAP trends, strategy and ERP market share

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

Start the conversation

Send me notifications when other members comment.

Register

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close