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

Related Q&A from Naeem Hashmi

Best practices for update rules

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

Implementing SAP BW before or after R/3 4.7

How does SAP distribute information with repeated server calls?

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

Top 5 inventory management techniques

Great inventory management techniques are critical as supply chain complexity grows. Here's a look at the top techniques to help ...

SAP competitors see openings with S/4HANA qualms

SAP customers may consider other ERP vendors as the clock speeds up for the 2025 support end for ECC, but some observers believe ...

How to reduce the bullwhip effect: Supply chain partners, data key

Understanding the causes of the bullwhip effect is critical to preventing it. Here's a look at why it happens and ways to close ...

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

MariaDB X4 brings smart transactions to open source database

Open source database vendor MariaDB updates its flagship platform with new features to enable the convergence of transactional ...

How data lineage tools boost data governance policies

Organizations can bolster data governance efforts by tracking the lineage of data in their systems. Get advice on how to do so ...

Proactive practices for data quality improvement

Instead of waiting for data quality to become an issue, consider a proactive approach. Here are some ways to improve data quality...

SearchAWS

AWS security faces challenges after a decade of dominance

After a decade of dominating the public cloud market and influencing cloud security, AWS is faced with new challenges stemming ...

AWS AI tools focus on developers

AWS sells many AI products, tools and services aimed at developers, including several for AI newcomers, such as DeepRacer, ...

Perform an AWS security assessment with these tips and tools

Cloud security is an ongoing process that demands regular checks for potential vulnerabilities. Use tools such as Amazon ...

SearchBusinessAnalytics

Storytelling using data makes information easy to digest

In a Q&A, Nate Nichols and Anna Schena Walsh of AI-based analytics vendor Narrative Science talk about how data storytelling can ...

Data-driven storytelling makes data accessible

In a Q&A, Nate Nichols and Anna Schena Walsh of data storytelling vendor Narrative Science discuss their book on storytelling and...

Startup Uplevel targets software engineering efficiency

Startup vendor Uplevel emerged from stealth on Wednesday touting a platform aimed at improving the efficiency of software ...

SearchContentManagement

Ex-SAP exec steers Episerver CMS toward digital experience market

Alex Atzberger discusses leaving the helm of SAP's CX platform to become Episerver CEO. Now, Episerver looks to reinvent itself ...

4 digital transformation terms to know

As technology evolves, businesses have no choice but to follow. Digital transformations are inevitable in order to keep customers...

How to differentiate between CX and DX platforms

CX and DX platforms have similarities in how they manage content to produce interactive experiences, but they aren't the same. ...

SearchHRSoftware

Top 7 HR trends for 2020 and beyond: The change decade

Because HR requires a balance between the needs of the organization with the needs of employees, it's always been a balancing act...

For insider threat programs, HR should provide checks and balances

Insider threat programs may backfire if employees feel they are intrusive and violate privacy, Forrester Research warns. Making ...

Better HR security could help thwart Iranian cyberattack

HR departments have a broad role to help protect their firms from Iranian cyberattacks. The security efforts include helping with...

SAP users feel the pressures of digital change

Top five tips for SAP BW

Integration between SAP Data Services, Business Warehouse on the rise

SAP Sapphire 2009 Orlando: SearchSAP.com Special Report

Please create a username to comment.