Integrating SAP and JD Edwards

Naeem Hashmi, Information Frameworks

Published: 18 Nov 2003

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

Dig Deeper on SAP trends, strategy and ERP market share

SAP users feel the pressures of digital change An ASUG survey shows SAP users understand the challenge of digital change; new SAP accounting application features help organizations to comply with new standards.

Top five tips for SAP BW Looking for ways to get more out of SAP Business Warehouse (BW)? Expert Ethan Jewett lays out five key strategies all SAP BW teams should follow.

Integration between SAP Data Services, Business Warehouse on the rise SAP Data Services plus SAP Business Warehouse and other ERP apps make a powerful combination but be aware of potential pitfalls, says Ethan Jewett.

SAP Sapphire 2009 Orlando: SearchSAP.com Special Report This SAP Sapphire 2009 special feature compiles content from SAP's annual user conference in one convenient location.

On The Spot: Gary Nolan on SAP BI/BW This month Gary Nolan answered all of your SAP BI/BW questions. Submit your SAP Security questions for next month at the bottom of this page.

Standardizing on SAP, Monsanto's roadmap Monsanto made SAP the system of record for its Global operations through an ERP roadmap, and got measurable ROI in the process.

Related Q&A from Naeem Hashmi

Implementing SAP BW before or after R/3 4.7

How does SAP distribute information with repeated server calls?

Best practices for update rules

Where could I find something like "best practices for update rules"? Continue Reading

Have a question for an expert?

Please add a title for your question

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

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

RPA in manufacturing increases efficiency, reduces costs

In this Q&A, Shibaji Das of UiPath discusses why manufacturers should implement RPA to improve efficiency, help with ERP system ...

A look inside the new Redwood Oracle UI design

The two designers who head Oracle's Redwood user experience and branding effort explain the philosophy behind the new look and ...

Process mining software pulls back curtains on how processes work

Here's what two vendors, Celonis and Signavio, offer in the emerging field of process mining software, which enables ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Amazon Managed Apache Cassandra Service stokes competition

Vendors in the open source Cassandra NoSQL database market voice their concerns about AWS' entry into the field, as the cloud ...

Aerospike 4.8 advances database persistent memory support

Aerospike 4.8 adds full support for Intel's Optane persistent memory, enabling the NoSQL database to run both the index and data ...

Data warehouse technologies evolve as vendors look skyward

The need for high-speed analytics and low latency are pushing data warehousing vendors to create and reinvent their platforms and...

SearchAWS

Prepare for an AWS outage with these preventative steps

Set up the proper data protection and recovery measures before a cloud outage hits. Follow these backup and disaster recovery ...

AWS seeks niche in the cloud UC market

AWS could play a bigger role in the cloud UC market in 2020 and beyond by targeting developers and existing AWS customers.

National Australia Bank cashes in on AWS training and certification

Structured training got nearly 1,000 National Australia Bank employees certified on AWS, while AWS-honed tactics such as ...

SearchBusinessAnalytics

Government IT pros: Hiring data scientists isn't an exact science

There's no such thing as a data science unicorn, U.S. government experts caution. You'll need more than programmers and technical...

Tableau 2020.1 unveiled for beta testing

Featuring improvements to Explain Data, an AI product that aims to explain the reasons behind data points, the update is made up ...

Data scientist vs. data analyst: What's the difference?

Data scientists and data analysts have a lot of crossover in their roles, but they're certainly not the same. Here's a look at ...

SearchContentManagement

DNA as a content storage device is closer than you think

Storing content in DNA may one day be possible, but today, it's neither practical nor cost-effective. Here's where this ...

Acquia acquisition of AgilOne CDP signals CX platform expansion

Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...

Personalization engines help engage and retain customers

Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...

SearchHRSoftware

US Army HR expects migration to Azure cloud will cut IT costs

The U.S. Army civilian HR operations is hoping for lower operational costs and improved services with a shift to the Microsoft ...

H-1B lottery change may drive increase in visa applicants

The U.S. is launching an H-1B electronic registration system in March. It should make the process of applying for a visa easier, ...

Fight the skills gap with a great upskilling and reskilling strategy

Just say 'no' to a skills gap and high turnover with upskilling and reskilling. Here's a look at the ins and outs of these ...

Dig Deeper on SAP trends, strategy and ERP market share

Related Q&A from Naeem Hashmi

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.