Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data migration from SAP to Oracle

Former Member

‎09-24-2007 12:55 PM

0 Kudos

Can any one suggest best possible method for migrating master and transactional data from SAP to Oracle.

Please suggest methods to get data in text file from SAP.

5 REPLIES 5

Former Member

‎09-24-2007 5:23 PM

0 Kudos

hi,

Chk it out

http://www.sap4.com/contentid-146.html

Regards

Siva

Former Member

‎09-27-2007 10:51 AM

0 Kudos

Has anyone downloaded data from SAP using sxda - data transfer tool. If yes please give me the detailed method. I need to download data from SAP using this transaction into any file format which has data togther with their fields names.

Sougata
Active Contributor
In response to Former Member

‎09-27-2007 10:57 AM

0 Kudos

Sutapa,

Can Oracle, the target system, receive and process standard Idocs?

Regards,

Sougata.

Former Member
In response to Former Member

‎09-27-2007 12:48 PM

0 Kudos

Orcale needs text files with data. Not sure if it can process idocs. However idocs can be downloaded into text fields but they do not have fieldnames so not useful.

Sougata
Active Contributor
In response to Former Member

‎09-28-2007 2:47 AM

0 Kudos

Best approach would be to use Electronic Data Interchange (EDI) outbound from SAP inbound to Oracle. There are two widely used standards in EDI messages - ANSI X12 and EDIFACT; I'm pretty sure the Oracle system will be able to accept one of the two standards or both.

In my last message, when I asked if Oracle is able to receive and process IDocs, I actually meant if Oracle will be able to accept and process EDI messages. IDocs are containers of the EDI message i.e. a data container - their formats are SAP proprietary formats which will not make sense to your target system (Oracle). EDI has been around for many years and is the standard way of electronically exchanging business documents between computer systems of business partners, using a standard format over a communication network.

In regards to your question - I'm not really sure if you want to send master/transactional data real-time from SAP to Oracle or want to transfer the historical data i.e. download from SAP tables (thru SE16 - this will download the field labels as well) into text files and then upload it to Oracle by using a custom program which reads/maps the files then posts the transactional data/updates master data tables in Oracle as required by that system. So let me know as much details as possible.

It would be nice to show appreciation by rewarding points.

Cheers,

Sougata.