SAP Network Blog: How to integrate MDM with MySQL server 5.0

How to integrate MDM with MySQL server 5.0

I’ve a requirement to integrate MDM with MySQL (which is an open source). Many people might be aware of working with Excel & XML file types. This blog guide you to integrate MDM with MySQL server 5.0.

Prerequisites

MySQL Server 5.0 Ver 14.12 Distrib 5.0.45, for Win32 (ia32)

Link: http://dev.mysql.com/downloads

ODBC MySQL connector-odbc-3.51.24-win32

Link: http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-3.51&o=-win

MySQL Database Server administration and development tools.Any third-party tools like Toad, navicat and others.

Overview

MySQL is an open source, download MySQL ( http://www.mysql.com/ ) s/w and install in your machine. Along with that, you must download MySQL Connector for the operating system installed on you’re machine, from the site which is mentioned in the prerequisites. By default no operating system will be having this Connector. My OS is win XP so I have downloaded the same.

Installation of ODBC MySQL connector-odbc-3.51.24-win32
Checking the installed Driver & Create DSN using ODBC
Connect to the Import Manager

A. Installation of ODBC MySQL connector-odbc-3.51.24-win32

To install the Connector Download the exe file from http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-3.51&o=-win and run setup.

B. Checking the installed Driver & Creating DSN using ODBC

To check whether the driver was installed successfully or not go to Start->Setting->Control Panel->Administrative tools ->Data Sources (ODBC)

[OR]

Type “odbcad32” in “Run” command. You will get following screen.

Click on “Add” button to create a new Data Source.

Select MySQL ODBC 3.51 Driver & click “Finish”.

Fill up the required details.

Data source name – A data source name (DSN) is a data structure that contains the Information about a specific database that an Open Database Connectivity(ODBC) driver needs in order to connect to it. Any name can be used here.

Description –- About new Data source.

Server -- the server names will vary according to the OS. Here I have installedMySQL in a standalone system(win XP)so the server is “localhost” for the present case.

User – “root” (default user). You can create your own users.

Password -- at the time of installation, we can create root password, use the same if the user is “root”. Else use the newly created user password.

Database -- select the database from the drop down list, by default MySQL will be having3 databases (information_schema, mysql, test), use “test” for the demo.If you don’t have Any other databases created in the server.

Note: I have created a “testmdm”, database in MySQL. So you can’t get it in the dropdown list.Create your own database or work with the default databases.

To check connections click on “Test”, you can see the message, press “OK”, to Continue.

The new “TEST_MDM”, dsn was created successfully. Press OK to continue

C. Connect to the Import Manager

Load the Repository and connect to the Import Manager. Follow the screen shot

for Type ,DSN, User (MySQL user name) , Password (MySQL user password)

Click Finish, to continue.This is how we can connect to the MDM import manager from MySQL.

Data in MDM Import manager

In the source hierarchy you can see the DSN name not the database name.

Data in MySQL

(MySQL Database Server administration and development tool) the database “Testmdm” which was created in MySQL.

D. Conclusion

In order to work with MySQL, down load any of MySQL Database Server administration and development tool.

How to integrate MDM with MySQL server 5.0 Rupesh K Business Card Company: Capgemini Consultancy India Pvt. Ltd. Posted on Aug. 20, 2008 12:48 AM in Master Data Management (MDM)