Getting Data from Oracle into SAP

[former_member349564]

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

[JL23]

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?

[former_member349564]

I have to get the punching data from punching machine which is having Oracle system. Now I want the punching data of employees into sap table. How can I achieve it?

[JL23]

What is "punching data" from "punching machine"? has it something to do with this: https://en.wikipedia.org/wiki/Punching_machine

about what module in SAP does this belong?

If this is an ABAP question then kindly tag it with ABAP Development

[former_member349564]

Yes this is ABAP question. Need to get punching data from Punching machine into SAP by programming.

[Phillip_Morgan]

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

[SuhaSaha]

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

[raymond_giuseppi]

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

[horst_keller]

You can solve this with

secondary database connections