none
Looking at doing SAP integration with .Net / SQL Server

    Question

  • Hi ,

    I would like to do both pull as well as push integration with SAP into a SQL Server Database as well as SharePoint lists.

    What will be the best way to do both Pull as well as Push Integration? (Push is SAP at frequent intervals pushes the master, transaction updates from SAP into an SQL Server Database)

    Can I use the below?

    .NET Framework Data Provider for mySAP Business Suite.

    But it seems to be available only for SQL 2005.

    Is this available for SQL 2012 or SQL 2014?

    Are there standard SAP Providers available?


    Karthick S

    • Moved by Caillen Tuesday, July 14, 2015 3:17 AM
    Sunday, July 12, 2015 6:14 AM

Answers

All replies

  • Where I've seen this done, the mechanism is usually overnight SAP "reports" which produce flat files. Imported to sql server using ssis.

    There are some serious complications in reading out of sap tables reliably. I wouldn't really recommend it.

    Even if whoever administers SAP allows you to do this, you will find all sorts of complications.


    Sunday, July 12, 2015 9:11 AM
  • Hi Andy, the requirement here is that - data frequently changes in SAP - so that needs to be pushed down to a SQL Server database. The reason is that, this SQL DB is used by an ASP.Net application - which is the front-end for all users. Also, this ASP.Net / SQL Application sometimes can also work in offline mode (without connectivity) where the transactions done in the ASP.Net application will have to be validated against the data that is locally present. So the data in SAP needing to come down to .Net Application is very vital. Let me know...

    Karthick S

    Sunday, July 12, 2015 11:20 AM
  • Hi Karthick S,

    Your question doesn't seem to have anything to do with Visual C# language, but I'm not quite sure which forum you should post in. So I'll move your thread to the [where is the forum for...] forum where the moderator may direct you to the right place.

    Thanks for your understanding.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, July 14, 2015 3:15 AM
  • You could ask about the data providers available here.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqldataaccess%2Cssdt&filter=alltypes&sort=lastpostdesc

     https://social.msdn.microsoft.com/Forums/en-US/home?forum=adodotnetdataset

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Tuesday, July 14, 2015 3:23 AM
    Moderator