11-24-2017 8:15 AM
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
11-27-2017 5: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?
11-28-2017 7:37 AM
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?
11-28-2017 8:41 AM
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
11-29-2017 7:32 AM
Yes this is ABAP question. Need to get punching data from Punching machine into SAP by programming.
11-29-2017 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...
11-29-2017 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
11-29-2017 12:05 PM
11-29-2017 12:27 PM