extracting data from different system

[Former Member]

Hi Guru's,

we would like to extract data from non SAP system through ABAP program. The flat file or interface file is in a folder of different server which is Windows based and SAP being in SOLARIS.

We tried to extract from FTP commands, but the users doesn't need FTP to be used. Is there any way of using Ports to open and extract data through ABAP program.

If so can we have the process and also the details required.

[Former Member]

Hi Madan,

I think you can use ETL tools which can extract data from SAP and NON-SAP systems. There are many available in the market, like Pantaho etc. You have to set it in between your SAP and Servers.

These tools will extarct data from other systems and collect in your system in formated manner. Then you can query on that data as per your need.