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

All
News
Get Started
Evaluate
Manage
Problem Solve

SearchSAP.com Chapter Downloads

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

Shakeup in the Infor leadership tree

Charles Phillips moved from Infor CEO to become chairman of the board of directors. He has been replaced by CFO Kevin Samuelson. ...

Host Analytics FP&A software aids Digital Realty decision-making

Digital Realty digitized financial planning and analysis to enable data-driven decisions. Here's a look at how that has enabled ...

Discover the core ERP system components

Discover core ERP systems components, as well as the benefits and challenges of implementing ERP in your organization.

SearchOracle

How Oracle RPA systems can automate business tasks for users

Robotic process automation software can be integrated into Oracle environments to help strengthen business operations by ...

Oracle Analytics Cloud update unifies BI products, pricing

Oracle Analytics Cloud now offers a consistent UI and all-in-one pricing for Oracle's analytics tools. But an on-premises BI ...

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new...

SearchDataManagement

ArangoDB 3.5 update improves multi-model database platform

ArangoDB 3.5 accelerates its database platform with improved query performance and enhanced data security capabilities, as market...

GDPR, AI intensify privacy and data protection compliance demands

This guide covers the challenges data management teams face on data protection and privacy, particularly with the rise of GDPR ...

SnapLogic boosts its data integration technology with AI

SnapLogic's latest update for its Intelligent Integration Platform aims to make it easier for users to benefit from data ...

SearchAWS

Implement serverless architecture on AWS without Lambda

Serverless on AWS isn't all about Lambda. In fact, many of the services developers use often -- such as S3, Aurora and others -- ...

AWS Lambda alternatives for flexible cloud workloads

Experts share points of comparison for Lambda vs. the competition, and what other options AWS has for elastic computing without ...

Globe and Mail's AWS migration drives digital engagement

Canadian news outlet The Globe and Mail has broadly adopted AWS cloud services in a bid to increase reader engagement and digital...

SearchBusinessAnalytics

Museums and data: A powerful combination

With more and more museums using data to inform their decision-making processes, visitors are reaping the benefits by enjoying a ...

5 augmented analytics examples in the enterprise

Here are the top examples of augmented analytics uses that BI vendors support and enable, including data preparation, NLP-based ...

Phocas BI tool proves its value for manufacturers, wholesalers

With its focus on the manufacturing and wholesale distribution industries, Phocas Software has carved out a niche for itself ...

SearchContentManagement

Box Shield adds tighter controls for content sharing

New Box security features enable file- and folder-level access control, while admins and security staff get machine-learning ...

Evergage launches Data Warehouse, a BI analytics product

Data Warehouse, Evergage's new BI analytics product, is designed to collect and analyze customer data in an effort to provide ...

Upgrades to Nintex Forms simplifies electronic form creation

The new form designer by Nintex brings user-friendly capabilities to Nintex Forms for both electronic form creation and data ...

SearchHRSoftware

CEO commitment to upskilling employees may boost HR tech

Top CEOs are promising to train their employees and make sure they are ready for an automating world. Whether the promise is real...

Employee engagement technology not a panacea for HR woes

Employee engagement comes in many shapes and forms, leaving employers to scratch their heads at the best way to motivate their ...

Hiring vendor says gender-based AI bias is pervasive

Gender bias in AI algorithms for recruiting and hiring is a big problem, according to the head of Job.com. With a new hire, the ...

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.