MySQL

[Former Member]

Hi Frends,

My Client has MySQL as Database,How can i connect MYSQL to SAP ,as I heard oracle is only defalut database to SAP.

Correct inputs are rewarded

Regards

[Former Member · Accepted solution]

HI,

To use sql database , we have to use jdbc adapter.For this please install jdbc drivers on your PI server and get connection details from.

For sql the default port no. is 3306 and default user name is root.password you can create it

[aashish_sinha]

Hi,

Please check out this wiki will help you with step by step procedure.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2bprocess%2bfor%2bsending%2bc...

Also you can check this thread for how to set the driver of MySQL in PI.

You are supposed to use JDBC Adapter. It is not necessary that oracle database come with PI by default. we have got SQL Server by default. So i think it depends upon what you have and what you want.

Hope this will help you.

Regards

Aashish Sinha

PS : reward points if helpful

[Former Member]

Hi,

By using SAP we can connect to the any of the database by specifying their drivers details.

To connect MySQL server

1)download the jdbc driver and jar files.

2) place the jar files in java folder C:\j2sdk1.4.2_14\lib

For MySQL in communication channel specify

Jdbc Driver : com.mysql.jdbc.Driver

connection : jdbc.mysql://<XI server name>:<port>/<database name>

username : database username

pwd : DB user password.

[Former Member]

Hi,

If you have to use the MySQL as part of 3 Tier Application architecture then, its preferrable to go for Oracle or DB2 which are preferred one with SAP.

If you have to interlink with My SQL to SAP to access the data in limited amount you can interact with the help of SAP XI/PI.

With the use of JDBC adapter you can communicate to MySQL.

Refer simialr discussions

Connecting to mySQL

Thanks

swarup

[Former Member]

Hi Swarup,

I am unable to open the link under the links tht are mention below

Please help me ASAP

[Former Member]

HI,

The links I had given have the information of guide to install JDBC drivers:

Try below links

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Thanks

Swarup

[Former Member]

Hi Sawrup,

Lol.............

I am unable to open fst link

2nd link for FICO Module

[GabrielSagaya]

please fallow the steps to connect mySQL server

1)download the jdbc driver from url http://download.softagency.net/MySQL/Downloads/Connector-J/

(mysql-connector-java-3.1.14-bin.jar if you are using mysql 4.0)

2)copy the mysql-connector-java-3.1.14-bin.jar file into

C:\ServletExec AS\se-xMII\webapps\default\Lighthammer\WEB-INF\lib folder

3) place the same jar into java folder C:\j2sdk1.4.2_14\lib

4) Access the xMII server url in the browser

http://localhost/Lighthammer/Menu.jsp

5)Select the DataServices>DataServers> uncheck the check box (show only Enabled servers)

This is the summary of the data server configuration

Name Value

Connector IDBC

ConnectorType SQL

Enabled True(select the check box)

DatePrefix '

DateSuffix '

Description Default IDBC Server

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.mysql.jdbc.Driver

PoolMax 100

PoolSize 1

ServerPackage com.lighthammer.Illuminator.connectors.IDBC

ServerURL jdbc:mysql://<hostname>/<databasename>

Timeout 15

UseCount 256

UserName root

ValidationQuery select now()

WaitTime 30

JDBC driver: com.microsoft.jdbc.sqlserver.sqlserverdriver

connection: jdbc:microsoft:sqlserver://ip:port;databasename=

here ip and port are sqlserver ip and port.

Now, as you are posting data from mySQL to Oracle via XI, you will have a SENDER JDBC adapter pointing to mySQL and a RECEIVER jdbc adapter pointing to Oracle.

When you are using your JDBC as a sender, then your JDBC will poll over your database and select the rows that satisfy your Select Query. Also, there is another field in your sender JDBC adapter that is very important and that is the Update satatement. Once your JDBC adapter executes your select query and selects rows from the database, you might not need those rows to be selected again. In this csse, you can use the Update statement to update the database.

In the case of the receiver JDBC adapter, you can insert/ update/ delete data and execute stored prooedure into your databse.

For more info, look at these links,

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm