topic Re: Getting Data from Oracle into SAP in Application Development and Automation Discussions

Getting Data from Oracle into SAP

Former Member — Fri, 24 Nov 2017 08:15:49 GMT

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

Re: Getting Data from Oracle into SAP

JL23 — Mon, 27 Nov 2017 17:57:34 GMT

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?

Re: Getting Data from Oracle into SAP

Former Member — Tue, 28 Nov 2017 07:37:41 GMT

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?

Re: Getting Data from Oracle into SAP

JL23 — Tue, 28 Nov 2017 08:41:32 GMT

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

Re: Getting Data from Oracle into SAP

Former Member — Wed, 29 Nov 2017 07:32:01 GMT

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

Re: Getting Data from Oracle into SAP

Phillip_Morgan — Wed, 29 Nov 2017 11:14:47 GMT

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

Re: Getting Data from Oracle into SAP

SuhaSaha — Wed, 29 Nov 2017 11:34:38 GMT

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

Re: Getting Data from Oracle into SAP

RaymondGiuseppi — Wed, 29 Nov 2017 12:05:21 GMT

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.

Re: Getting Data from Oracle into SAP

retired_member — Wed, 29 Nov 2017 12:27:33 GMT

You can solve this with

secondary database connections