You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-07-28 02:45:43

zet
Member
2 posts

zet said:

How use existing mysql db as MDM database.

Tags: [database, mysql]

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.

Offline

#2 2016-07-28 15:50:39

asebastianelli
Member
132 posts

asebastianelli said:

Re: How use existing mysql db as MDM database.

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

Offline

#3 2016-07-29 07:50:56

zet
Member
2 posts

zet said:

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 [com.amalto.core.server.DefaultDataCluster] The Data Cluster XXX does not exist.
2016-07-27 20:15:05,257 INFO  [org.apache.cxf.phase.PhaseInterceptorChain] 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.

Offline

#4 2016-07-29 09:43:18

asebastianelli
Member
132 posts

asebastianelli said:

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

Offline

#5 2016-07-29 09:48:16

asebastianelli
Member
132 posts

asebastianelli said:

Re: How use existing mysql db as MDM database.

in case this can give some hints


https://jira.talendforge.org/browse/TMDM-4927

https://help.talend.com/display/KB/MDM+SQL+Storage

Last edited by asebastianelli (2016-07-29 09:50:49)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy