topic Re: acces MySQL server in Application Development and Automation Discussions

acces MySQL server

Former Member — Mon, 02 Mar 2009 14:14:05 GMT

hi experts,

our SAP database system run under ORACLE...beside this we have anoher database server - MySQL server.

Is there any possibility to connect to MySQL server from SAP?

Thank you.

Re: acces MySQL server

Former Member — Mon, 16 Mar 2009 20:58:39 GMT

Hi,

Check this:

http://saptechno.blogspot.com/2008/07/how-to-connect-to-external-database.html

Also this:

Using transaction SE11, create a table (ZTABLE) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical.

Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE

Using SVRMGRL>

create dblink REMOTE_DB as connect to remote_user identified by password; (database link created)

drop table ZTABLE; (table dropped)

create synonym ZTABLE for ZTABLE@REMOTE_DB; (synonym created)

Using transaction SE16 , type in ZTABLE_VIEW and hit RETURN

Enter value in key fields and hit execute. (displays rows from the remote table)

Re: acces MySQL server

Former Member — Tue, 17 Mar 2009 16:51:45 GMT

Pls refer below:

http://help.sap.com/saphelp_nw04/helpdata/en/33/0d24e7bde2764da0e4e1d7042bbcfb/content.htm

Regards

Shital