+ Reply to Thread
Results 1 to 2 of 2

Thread: extracting data issue

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    24

    extracting data issue

    I need to extract data from a SAP ABAP system in a format that can then be loaded into an Oracle database (xlsx,csv,dmp)
    Once the data is extracted I'll upload it into the Oracle database.
    Is there a way to extract the data from SAP?

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    24
    You have a many methods to do this.

    If you are running SAP BW, there are many standard tools to help you do extractions and automate the processes.

    Otherwise, you can write a simple ABAP program (type 1) to read data from tables and put it into a flat file.

    Otherwise, you could write a remote-enabled function module (RFC) and call it using SAP's RFC library.

    You could also wrap your RFC function with a web service and call it via SOAP/HTTP.

    Lastly, if you have access to the database, you might even be able to write a script to extract the data you need.

+ Reply to Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts