Talend MDM Server running on PostgreSQL

Anonymous — Wed, 17 Apr 2019 11:55:44 GMT

Hi!

I'`m trying to deploy TMDMS with PostgreSQL datasource, so I added to my datasource.xml this part:

	<datasource name="PostgreSQL-Default">
        <master>
            <type>RDBMS</type>
            <rdbms-configuration>
                <dialect>POSTGRES</dialect>
                <connection-driver-class>org.postgresql.Driver</connection-driver-class>
                <connection-url>jdbc:postgresql:<my_host_address>:<port>/TMDM_DB</connection-url>
                <connection-username>mdm_master</connection-username>
                <connection-password><my_password>==,Encrypt</connection-password>
                <fulltext-index-directory>/usr/local/TOS_MDM-Server-20181026_1147-V7.1.1/data/indexes/PostgreSQL-Default</fulltext-index-directory>
                <schema-generation>update</schema-generation>
                <properties>
                    <property name="hibernate.show_sql">false</property>
                    <property name="hibernate.default_schema">mdm_master</property>
                </properties>
            </rdbms-configuration>
        </master>
        <staging>
            <type>RDBMS</type>
            <rdbms-configuration>
                <dialect>POSTGRES</dialect>
                <connection-driver-class>org.postgresql.Driver</connection-driver-class>
                <connection-url>jdbc:postgresql:<my_host_address>:<port>/TMDM_DB</connection-url>
                <connection-username>mdm_staging</connection-username>
                <connection-password><my_password>==,Encrypt</connection-password>
                <schema-generation>update</schema-generation>
                <properties>
                    <property name="hibernate.show_sql">false</property>
                    <property name="hibernate.default_schema">mdm_staging</property>
                </properties>
            </rdbms-configuration>
        </staging>
		<system>
            <type>RDBMS</type>
            <rdbms-configuration>
                <dialect>POSTGRES</dialect>
                <connection-driver-class>org.postgresql.Driver</connection-driver-class>
                <connection-url>jdbc:postgresql:<my_host_address>:<port>/TMDM_DB</connection-url>
                <connection-username>mdm_system</connection-username>
                <connection-password><my_password>==,Encrypt</connection-password>
                <schema-generation>update</schema-generation>
                <properties>
                    <property name="hibernate.show_sql">false</property>
                    <property name="hibernate.default_schema">mdm_system</property>
                </properties>
            </rdbms-configuration>
        </system>
    </datasource>

and changed value db.default.datasource in my mdm.conf to PostgreSQL-Default

After starting embedded Tomcat, i found this in catalina.out:

java.lang.IllegalArgumentException: Not supported database type 'POSTGRES'
	at com.amalto.core.storage.hibernate.DefaultStorageClassLoader.getDialect(Unknown Source)
	at com.amalto.core.storage.hibernate.DefaultStorageClassLoader.generateHibernateConfiguration(Unknown Source)

and this in com.amalto.core.storage.hibernate.DefaultStorageClassLoader.java module:

    protected String getDialect(RDBMSDataSource.DataSourceDialect dialectType) {
        switch (dialectType) {
            case H2:
                // Default Hibernate configuration for Hibernate forgot some JDBC type mapping.
                return H2CustomDialect.class.getName();
            case MYSQL:
                return "org.hibernate.dialect.MySQLDialect"; //$NON-NLS-1$
            default:
                throw new IllegalArgumentException("Not supported database type '" + dialectType + "'");
        }
    }

So, my question is - if anybody can help me with this?

Should I continue my attemts? Or this functionality is not supported?

Re: Talend MDM Server running on PostgreSQL

Anonymous — Fri, 19 Apr 2019 07:36:30 GMT

Hello,

Which is MDM product build version you are using? Talend Open Studio for MDM or subscription solution?

With talend open studio for MDM, H2 database which is embedded during the product installation is the only supported database in open source(free version) till now.

For more information, please have a look at this online documentation

TalendHelpCenter:Compatible databases

Best regards

Sabrina

topic Talend MDM Server running on PostgreSQL in Talend Studio

Talend MDM Server running on PostgreSQL

Re: Talend MDM Server running on PostgreSQL