Skip to Content
-3

Getting Data from Oracle into SAP

Nov 24, 2017 at 08:15 AM

80

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Raymond Giuseppi
Nov 29, 2017 at 12:05 PM
0
  • 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.
Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Nov 27, 2017 at 05:57 PM
0

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?

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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?

0

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

0

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

0
Suhas Saha
Nov 29, 2017 at 11:34 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Phillip Morgan Nov 29, 2017 at 11:14 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Horst Keller
Nov 29, 2017 at 12:27 PM
0

You can solve this with

secondary database connections

Share
10 |10000 characters needed characters left characters exceeded