One Star zet
One Star

How use existing mysql db as MDM database.

Hi all. I'm new to Talend. 
I'm in trouble with MDM database. I want to ask follows.
Does Talend Open Studio MDM(ver 6.2.1) support MySql Db as MDM database?
now I'm using Talend Open Studio MDM.
what I want to do  is to use H2 db for system data,and MySql db (existing) for master data.
Can I do this with Talend Open Studio MDM? should I pay for subscription? 
best regards.
4 REPLIES
Employee

Re: How use existing mysql db as MDM database.

check the datasources.xml in the conf folder. you should just uncomment the needed datasource
One Star zet
One Star

Re: How use existing mysql db as MDM database.

hi asebastianelli.
thank you for your quick reply.
I tried what you told me. but now I have another error. 

I did following steps.(XXX is my db name)

1.edit datasource(by following your advice)
<?xml version="1.0" encoding="UTF-8"?>
<!-- Copyright (C) 2006-2013 Talend Inc. - www.talend.com -->
<datasources>
<!-- H2 DATASOURCE -->
<datasource name="H2-Default">
       <master>
    <type>RDBMS</type>
           <rdbms-configuration>
               <dialect>MySQL</dialect>
               <connection-driver-class>com.mysql.jdbc.Driver</connection-driver-class>
               <connection-url>jdbc:mysql://localhost:3306/${container}</connection-url>
               <connection-username>root</connection-username>
               <connection-password>toor</connection-password>
               <connection-pool-minsize>5</connection-pool-minsize>
               <connection-pool-maxsize>50</connection-pool-maxsize>
               <fulltext-index-directory>/tmp/data/indexes/${container}</fulltext-index-directory>
               <schema-generation>update</schema-generation>
               <properties>
                   <property name="hibernate.show_sql">false</property>
               </properties>
               <init>
                   <database-name>${container}</database-name>
                   <connection-url>jdbc:mysql://localhost:3306/${container}</connection-url>
                   <connection-username>root</connection-username>
                   <connection-password>toor</connection-password>
               </init>
           </rdbms-configuration>
   </master>
       <system>
           <type>RDBMS</type>
           <rdbms-configuration>
               <dialect>H2</dialect>
               <connection-driver-class>org.h2.Driver</connection-driver-class>
               <connection-url>jdbc:h2://C:\Program Files\TOS_MDM_Server/data/H2-Default/TMDM_DB_SYSTEM;DB_CLOSE_ON_EXIT=FALSE</connection-url>
               <connection-username>sa</connection-username>
               <connection-password>sa</connection-password>
               <schema-generation>update</schema-generation>
               <properties>
                   <property name="hibernate.show_sql">false</property>
               </properties>
           </rdbms-configuration>
       </system>
   </datasource>
</datasources>

2.create Data Model named "XXX".
3.create Data Container named "XXX".
4.open Data Container by double click. but error happen like this.
2016-07-27 20:15:05,250 ERROR  The Data Cluster XXX does not exist.
2016-07-27 20:15:05,257 INFO   Application {}TMDMService#{}getDataCluster has thrown exception, unwinding now: java.rmi.RemoteException: The Data Cluster XXX does not exist.; nested exception is:
com.amalto.core.util.XtentisException: The Data Cluster XXX does not exist.

if you have any idea about this.
please help me.
best regards.
Employee

Re: How use existing mysql db as MDM database.

why did you modify the H2, there is a block for mysql. please comment h2 and uncomment mysql
then go to mdm.conf and change  RDBMS Settings accordingly
Employee

Re: How use existing mysql db as MDM database.