Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Interface between Mysql to SAP

Former Member

‎2010 Sep 24 12:23 PM

0 Likes
517

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

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

Reply
1 REPLY 1
Read only

Former Member

‎2010 Sep 24 12:32 PM

0 Likes
400

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