topic extracting data from different system in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-different-system/m-p/5661053#M1287582 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P></P><P> 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.</P><P></P><P>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.</P><P></P><P>If so can we have the process and also the details required.</P></BODY></HTML> Tue, 02 Jun 2009 05:47:54 GMT Former Member 2009-06-02T05:47:54Z extracting data from different system https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-different-system/m-p/5661053#M1287582 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P></P><P> 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.</P><P></P><P>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.</P><P></P><P>If so can we have the process and also the details required.</P></BODY></HTML> Tue, 02 Jun 2009 05:47:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-different-system/m-p/5661053#M1287582 Former Member 2009-06-02T05:47:54Z Re: extracting data from different system https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-different-system/m-p/5661054#M1287583 <HTML><HEAD></HEAD><BODY><P>Hi Madan,</P><P></P><P>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. </P><P></P><P>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.</P></BODY></HTML> Tue, 02 Jun 2009 06:06:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-different-system/m-p/5661054#M1287583 Former Member 2009-06-02T06:06:58Z