Special characters in column names with Talend

Six Stars

Special characters in column names with Talend

Hello,

 

I saw this old post which indicates that the hyphen are not handle in the column names by Talend.

https://community.talend.com/t5/Design-and-Development/resolved-special-characters-in-field-names-CS...

However, I notice that currently it works.

 

My question : does it works (with any tricks) with the % character ?

I get this error: ORA-00911: invalid character

 

Thanks

Eight Stars

Re: Special characters in column names with Talend

Hi @Mayot,

No it will not work. U can try and Test. as far as my knowledge it will not work

Six Stars

Re: Special characters in column names with Talend

I tested, and actually the hyphen - is replaced by an underscore in Talend schema. But in the schema of the DB (in Talend and in Oracle) the hyphen - exist. It's the same with the sign percent %, it appears in the schema of the DB (Talend + Oracle) but it's replaced by an underscore _ in Talend mapping.

When I insert data in a column with the hyphen sign in his name, it works (I don't have any error). On the other hand, when I insert data in a column with the sign percent % in his name, it doesnt work.

I will have to test with parenthesis, square brackets, currency signs etc. In the meantime I renamed my column with PCT instead of % in Oracle.

Eight Stars

Re: Special characters in column names with Talend

Do that and let me know @Mayot

Six Stars

Re: Special characters in column names with Talend

I already test like I said in my precedent post.

 

create table TEST (
"Column-with-hyphen" varchar2(2),
"Column_with_underscore" varchar2(2),
"Column_with_%_PCT" varchar2(2)
);

You can try to create this table, it will work in Oracle : Table TEST créé(e).

 

But when I import the schema in Talend, the hyphen will not be an issue, but the % will.

Screenshot in Oracle :

TEST.PNG

 

Screenshot in Talend, as you can see, the Column name has been modified by Talend (the special char became an underscore), but the "Db Column" is fine.

In my job, when I insert data in table that has a column name with a hyphen, it works. But when there's an % it won't work. Don't know why however.

TEST_TALEND.PNG

 

Highlighted
Four Stars

Re: Special characters in column names with Talend

Hi,

 

How did it work for you? I'm using Big data and the TmongoDBinput component but it still won't let me use special characters.

 

Cheers,

 

John

Four Stars

Re: Special characters in column names with Talend

Hi Guys,

 

I have found out how to do it, You have to export your XML schema and edit the encoding type for that file, from 8 -> 16
and then you add the hyphen to the column name as well as the output column name.

 

Works for me now thanks.

 

John

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch