Skip to Content
author's profile photo
Former Member

Data migration from SAP to Oracle

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Sep 24, 2007 at 04:23 PM

    hi,

    Chk it out

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

    Regards

    Siva

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:51 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.