1

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.

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Ankit Srivastava
  • 23
  • 1
  • 1
  • 4

2 Answers2

2

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

oakfish56
  • 120
  • 8
0

In most cases, you should NOT access SAP underlying database directly. I explained extensively in this answer on SO

AecorSoft
  • 414
  • 4
  • 10