[resolved] Use postgres for storage

Highlighted
One Star

[resolved] Use postgres for storage

Hi. I'm new to Talend and using Talend Open Studio MDM 6.2.0. I want to use postgres for MDM SQL Storage and tried to follow helpcenter (Mdm sql storage)

0) Tried  cnange mdm.conf
db.default.datasource=Postgres-Default
Got errors Error creating bean with name 'defaultXmlServer', Data source 'Postgres-Default' can not be found in configuration.
1) Changed MDM\conf\datasources.xml (mdm.conf default)
<dialect>Postgres</dialect>               
<connection-driver-class>org.postgresql.Driver</connection-driver-class>   
<connection-url>jdbcSmiley Tongueostgresql://localhost:5432/testdatabase;DB_CLOSE_ON_EXIT=FALSE</connection-url>
<fulltext-index-directory>C:\MDM\data\indexes\PostgreSQL</fulltext-index-directory>
   
2) Created model and container "test", tried deploy and got error
INFO   Application {}TMDMService#{}putDataModel has thrown exception, unwinding now: java.rmi.RemoteException: Unable to create/update the Data Model test; 
: Could not create storage test with data model test.
: Could not create storage for container test (MASTER) using data model test.
: java.lang.RuntimeException: Could not create storage class loader
: Could not create storage class loader
: Could not generate Hibernate configuration
: Not supported database type POSTGRES; nested exception is: 
com.amalto.core.util.XtentisException: Unable to create/update the Data Model test    
Full log in attachment  
Can postgres be used as sql storage? How it can be done?      
UPD Found answer.

localhost.2016-10-25.log_20161025-0110.log
localhost.2016-10-25_.log.log
Moderator

Re: [resolved] Use postgres for storage

Hello, 
We see that this topic has been set as resolved. Could you please share your solution with us?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download