Skip to Content
author's profile photo Former Member
Former Member

MySQL

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 05:49 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 05:45 AM

    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

    Connecting to mySQL

    Posting Data from mySQL Database to Oracle Database

    jdbc-driver-jar-files-mysql-db

    Legacy_XI_MySQL

    Thanks

    swarup

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 06:00 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 16, 2008 at 08:02 AM

    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%2bcustomer%2bor%2bvendor%2bmaster%2bdata%2bfrom%2becc%2bsystem%2bto%2ban%2bexternal%2bsystem%2bmysql%2bdatabase%2bthrough%2bsap%2bprocess%2bintegration

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

    Legacy_XI_MySQL

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.