Cannot configure H2 DB to be used in TOS for MDM CE.

Highlighted
One Star

Cannot configure H2 DB to be used in TOS for MDM CE.

I downloaded MDM 5.6.2 (community edition. i.e. open source free one), I can connect to it, create data models and enter data using the Web UI (hosted on a Jboss AS).  Everything is fine.
Now, I want my data to be stored in a H2 database. Because right-now the data is stored in XML files (according to the user guide). 
How can I (a.) configure the built-in H2 database?.
I browsed the installation guide, and user guide for MDM 5.6.2, but it has no information on these.  The web help guide has a procedure described here, however it says that "To help you administrate the H2 embedded database, a dedicated Web console is available directly from Talend Administration Center.".
The TAC, if I am not mistaken is only available in the Enterprise Edition, right?
Does this mean that ,even the H2 DB is available only with the Enterprise edition???
This user guides and other web-guides are not clear on this.
Any help would be greatly appreciated.
Moderator

Re: Cannot configure H2 DB to be used in TOS for MDM CE.

Hi,
For your job requirement, please check document:
 https://help.talend.com/search/all?query=Manually+moving+system+objects+from+an+XML+database+to+a+re....
In addition, we have obliterated XML DB support since Talend 6.0
Please see jira issue:https://jira.talendforge.org/browse/TMDM-6823
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.
One Star

Re: Cannot configure H2 DB to be used in TOS for MDM CE.

Sabrina, you link is the one to the Installation & Upgrade guide. I have the PDF version of that also. But it does not have how to configure MDM to store the repository objects and data in a H2 database.  
If you search the PDF version of the "Talend Open Studio for MDM Installation and Upgrade Guide 5.6.2", and search that PDF for "h2" you get only ONE match. 
My understanding is that the H2 database should be added as a "Server Location" in the Open Studio for MDM under "Server Explorer". But when you right-click and select "Add Server Location", you have to give the server name. Here, do we have to give the H2 server name???? How to configure this???

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog