Where to find the .NET Data Provider for mySAP™ Business Suit?
What are the prerequisites of extracting data from SAP?
Do I need to install anything on SAP too for extracting data from SAP through SSIS?
How to connect to SAP in SSIS?
Thank you so much in Advance.
If you can gain access to the database on the backend, that would be easier for SSIS to extract from. That's what we do where I work. You can use the SAP .NET connector and write a Windows Service or Console App to extract data through RFC function module calls.
I have posted an example of a simple RFC call here:
http://scn.sap.com/thread/1876430.
More detailed tutorial can be found here:
http://scn.sap.com/community/interoperability-microsoft-net/blog/2013/02/14/connecting-to-sap-with-nco-3