Skip to Content
-3

Getting Data from Oracle into SAP

Hi Experts,

I want to get a table's data from Oracle system to SAP. I have already searched on net

for the same but unable to get the proper solution. I came to know that it can be achieved through native sql. but I am unable to find out that how exactly will it be done. please guide for doing the same.

Regards,

Mahesh Patel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 29, 2017 at 12:05 PM
    • The abap answer could be use native SQL or use ADBC (OO).
    • From a basis point of view, look, or ask basis to, for tools like DB Connect.
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2017 at 05:57 PM

    maybe you should explain what exactly you mean by "get a table's data from Oracle system to SAP"

    are you talking about a data migration? Which object?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2017 at 11:34 AM

    If you're trying to read data from an external DB, then you should be using the ADBC-API (btw, which SAP version are you using?)(Cf. https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abenadbc.htm)

    SAP has provided the demo program ADBC_DEMO, which you can refer to.

    BR Suhas

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2017 at 11:14 AM

    Hi,

    If you have to get data from an Oracle table directly, is it a remote system? You will then need access information to that machine and/or the Oracle DB. Why not get info on the punching machine? It may have a way to interface it to SAP. Check the brand name or possible standard it adheres to.

    Can it write to a file? to a table ?

    For Oracle, if the SAP DB is also Oracle, there is a way to create some sort of view that looks like a table to SAP but is actually a link to the table on the remote Oracle (Symbolic link?)

    Just some ideas...

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2017 at 12:27 PM

    You can solve this with

    secondary database connections

    Add comment
    10|10000 characters needed characters exceeded