topic Re: I cannot find tMysqlLookupInput !? in Installing and Upgrading

I cannot find tMysqlLookupInput !?

Xenoflex — Sat, 16 Nov 2024 08:31:38 GMT

Hallo all,

I downloaded the 6.5.1. Version of Talend Open Studio for Data Integration and installed all additional packages. Mysql is shown as installed in the Modules section.

But I only have tMysqlInput, in sum 16 components only. But according to https://help.talend.com/search/all?query=tMysqlLookupInput&filters=EnrichProdName~%2522Talend+Open+Studio+for+Data+Integration%2522 it should be there?

How can I enable/install it?

Many thanks in advance,

Alex

Re: I cannot find tMysqlLookupInput !?

Anonymous — Mon, 26 Mar 2018 10:01:51 GMT

Hello,

The streaming version of this component is available in the Palette of the Studio only if you have subscribed to Talend Real-Time Big Data Platform or Talend Data Fabric not open source.

Best regards

Sabrina

Re: I cannot find tMysqlLookupInput !?

Xenoflex — Mon, 26 Mar 2018 12:25:52 GMT

Hi Sabrina,

thanks for your help, thats really bad for me, because its an basic and simple function that should be available for all. 😞

Kind regards,

Alex

Re: I cannot find tMysqlLookupInput !?

Anonymous — Tue, 27 Mar 2018 04:46:30 GMT

Hello,

What does your requirement look like? Are you able to use tMySqlXXX components to achieve your goal? Which are generally available.

Best regards

Sabrina

Re: I cannot find tMysqlLookupInput !?

Xenoflex — Tue, 27 Mar 2018 06:45:25 GMT

Hello Sabrina,

yes I use the tMySqlxxx components, but now I need to make a different SELECT (in the WHERE clause) for every row.

Otherwise I have to take the whole table and let the tMAP make the selection, but thats a huge load of data.

Do you have any suggestions?

Best wishes,

Alex

Re: I cannot find tMysqlLookupInput !?

Anonymous — Wed, 28 Mar 2018 10:22:50 GMT

Hello,

The tMySqlInputLookUp works differently than the tMySqlInput component, and you need to provide a WHERE clause to select the join records.

The feature "Join Model" of tMap doesn't work for you?

Best regards

Sabrina

Re: I cannot find tMysqlLookupInput !?

Xenoflex — Tue, 17 Apr 2018 07:54:09 GMT

Hi Sabrina,

sorry for being late.

Well I tested it with the Join Model, but the performance is not so practicable.

Its acceptable if you have less than 10000 rows to work with, but not with 1M rows.

But I guess, when using the tMysqlLookupInput it isn't faster.

Anyway, thanks for your help,

Alex

Re: I cannot find tMysqlLookupInput !?

Anonymous — Thu, 19 Apr 2018 10:33:43 GMT

Hello,

Feel free to let us know if there is any further help we can give.

Best regards

Sabrina