SAP To/From MS SQL Alternatives to IBM Cast Iron

To move revenue data between SAP and MS sql I have been using IBM's Cast Iron product. It's
fairly expensive just for the maintenance. I wondered what other folks use for this process and
if they know how it compares price-wise to Cast Iron. In the end setting up the orchestrations
can be fairly involved. So perhaps I just need to stay with what I have. But wanted to ping the
experts. Thanks!
LVL 1
amigan_99Network EngineerAsked:
Who is Participating?
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You can use the .Net Data Provider for changing data, but with BAPI/RFC calls as shown in the MSDN doc referenced above. Those calls can be issued by SSIS, but not as "UPDATE ..." or "INSERT ...".
0
 
mlmccCommented:
Have you considered using SSIS?  It should come with MS SQL Server.

mlmcc
0
 
amigan_99Network EngineerAuthor Commented:
It looks like that could be a good tool for importing from SAP into MS SQL. It's doesn't say anything here about the other direction - MS SQL to SAP - which I believe involves simulating SAP client interaction. ?

https://msdn.microsoft.com/en-us/library/cc185548%28v=bts.10%29.aspx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mlmccCommented:
SO you need to move data both ways.  I read it as only from SAP to MS SQL.

I don't know of any tools like that.

mlmcc
0
 
amigan_99Network EngineerAuthor Commented:
It's definitely possible - we use Cast Iron from IBM to do it. It's just monstrously expensive for ongoing maintenance. It may be you just have to pay the piper. But thank you in any event.

Stackoverflow: /questions/2658910/how-to-import-data-to-sap
0
 
amigan_99Network EngineerAuthor Commented:
Thanks much!

Noting the thread I found for others who follow as well.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.