Interface between Mysql to SAP

Former Member — Fri, 24 Sep 2010 11:23:13 GMT

Hi all,

I have to develop an interface between SAP to Mysql. Please suggest your ideas.

Requirement: There is a machine called Acelli with Mysql database. We have a custom transaction in SAP, where user will select a line in table cotrol and click on a button. Here the selected data should be transfered to Acelli machine. Once the data reached to Acelli the process will run and at a particular stage Acelli will send data to SAP again. Based on the recieved data SAP have to run a transaction and result should send back to Acelli. Like this the data will be flowed from SAP to Mysql and Mysql to SAP. Please share your ideas..

(Note: Only at the first level user interaction is possible, then after the process must be automated).

Regards,

Prakash .S

Moderator message: "spec dumping", please work yourself first on your requirement.

locked by: Thomas Zloch on Sep 24, 2010 1:41 PM

Re: Interface between Mysql to SAP

Former Member — Fri, 24 Sep 2010 11:32:26 GMT

Hi Prakash,

1. To transfer data from SAP to Acelli after User input in table control

Build the logic under event of button in table control to extract the necessary data and place it in a flat file on application server then trigger a event. The event will inturn trigger Acelli to pick the file from application server & do further processing

Then Acelli will call an SAP RFC(you need to create a RFC in sap with import parameters same as the data format required from Acelli). SAP will run the transaction & will again update in file in application server + trigger event. Acelli will pick up the file.

Conclusion :-

Following objects have to be developed in SAP :-

1. 2 Interface programs

2. 1 RFC

Thanks,

Best regards,

Prashant

topic Interface between Mysql to SAP in Application Development and Automation Discussions

Interface between Mysql to SAP

Re: Interface between Mysql to SAP