acces MySQL server

[Former Member]

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.

[Former Member]

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)

[Former Member]

Pls refer below:

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

Regards

Shital