topic Re: why I cant see tDecryptColumn or tDataDecrypt components in Talen Studio? in Talend Studio

why I cant see tDecryptColumn or tDataDecrypt components in Talen Studio?

NNYEZEL — Fri, 15 Nov 2024 23:15:30 GMT

why I cant see tDecryptColumn or tDataDecrypt components in Talen Studio Palette?

I have Talend enterprise edition V 7.3.1.

Part of my select query is retrive an encrypt field. When I run the query in Mysql

WorkBeanch

I can see the filed populated no errors. When I run the same select into the component, the talend is complain about the select

Sample

This query run just fine in Mysql WorkBeanch

call set_key('XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX');

select dob from Table.Person;

If I run this in the component tdBInput

"call set_key('XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX');

select dob

from Table.Person

Thank you for all the help

Anonymous — Tue, 01 Feb 2022 01:15:13 GMT

These are not automatically included in the default component palette. To put these into the palette you need to do the following....

This will add them to the palette.

Anonymous — Tue, 15 Feb 2022 04:19:13 GMT

Hello,

The tDecryptColumn is a custom component written by talend community user and shared it on talend exchange portal.

You can download it from talend exchange portal and install it into talend studio freely.

Hope it helps.

Best regards

Sabrina