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)
ODBC MySQL connector-odbc-3.51.24-win32
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
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)
Click on “Add” button to create a new Data Source.
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.
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)
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.