topic Re: Reload Database in Hierarchical Mapper in Talend Studio

Reload Database in Hierarchical Mapper

Anonymous — Fri, 01 Sep 2017 13:04:20 GMT

I have created a Database object in "Meta-Data > Hierarchical Mapper > Databases" and imported all the Views and Tables into the "Structures" folder.

Now if a new View or Table gets added to the Database and I want to load the definitions into Talend, I right click on that Database and execute "[Re]Load Table Definitions...", after some waiting it tells me its finished, but nothing got updated or imported.

Is there some way to do that, without deleting all Structures and recreating the whole Database?

BR,

Max

Re: Reload Database in Hierarchical Mapper

Anonymous — Fri, 01 Sep 2017 13:28:29 GMT

Hi,

There is a feature request about it:

https://jira.talendforge.org/browse/TDM-5368

Eric

Re: Reload Database in Hierarchical Mapper

Anonymous — Tue, 05 Sep 2017 13:54:47 GMT

Since the issue got closed, I guess it's not on the radar to be implemented any time soon, right?

BR,
Max

Re: Reload Database in Hierarchical Mapper

Anonymous — Tue, 05 Sep 2017 14:15:45 GMT

Hi,

This one was closed because it was redundant, The old one https://jira.talendforge.org/browse/TDM-316 is still opened.

Eric

Re: Reload Database in Hierarchical Mapper

Tobi1 — Thu, 24 May 2018 16:51:10 GMT

Hello everyone,

I am happy to have found your work around. But I am wondering how such a basic feature as metadata retrieval from a database is still not properly working?

Also it says in the wizard that the database functionality is deprecated and will be discontinued in future versions. How will it be replaced? Will it be integrated with the metadata of Talend Integration?

Regards.

Re: Reload Database in Hierarchical Mapper

Anonymous — Fri, 25 May 2018 06:04:45 GMT

Hi,

You can confirm with Talend support but according to me they will suggest you use database component at job level to replace this functionnality.

Eric

Re: Reload Database in Hierarchical Mapper

Tobi1 — Fri, 25 May 2018 08:43:13 GMT

Hi Eric,

Thank you for your response. That is what I am doing as well, using the database component on job level to write data into a database table. I did not feel that errors can be caught sufficiently, when using a database connection in the TDM.

But what I am looking for is a way to create TDM structures from database tables, as I have around 50 tables with up to 200 columns. Is there any other way to do so, besides the mentioned way?

Tobi