How use existing mysql db as MDM database.

Anonymous — Thu, 28 Jul 2016 02:45:43 GMT

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.

Re: How use existing mysql db as MDM database.

Anonymous — Thu, 28 Jul 2016 15:50:39 GMT

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

Re: How use existing mysql db as MDM database.

Anonymous — Fri, 29 Jul 2016 07:50:56 GMT

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.

Re: How use existing mysql db as MDM database.

Anonymous — Fri, 29 Jul 2016 09:43:18 GMT

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

Re: How use existing mysql db as MDM database.

Anonymous — Fri, 29 Jul 2016 09:48:16 GMT

in case this can give some hints

https://jira.talendforge.org/browse/TMDM-4927
https://help.talend.com/search/all?query=MDM+SQL+Storage&content-lang=en

topic Re: How use existing mysql db as MDM database. in Talend Data Catalog

How use existing mysql db as MDM database.

Re: How use existing mysql db as MDM database.

Re: How use existing mysql db as MDM database.

Re: How use existing mysql db as MDM database.

Re: How use existing mysql db as MDM database.