Ask Your Question
1

How to do concatenation with StreamSets?

asked 2019-05-14 08:25:52 -0500

Dep gravatar image

updated 2019-05-14 10:11:25 -0500

metadaddy gravatar image

Team, I am playing with Oracle and PostgreSQL using StreamSets. I am fetching the entire database using ORACLE CDC CLIENT and destination JDBC PRODUCER, but In Oracle I have table like ABC and in PostgreSQL like test_abc, how will i do with table concatenation ABC to test_abc ?? the following parameter is not working

test_${str:toLower(record:attribute('jdbc.tables'))}
edit retag flag offensive close merge delete

Comments

What do you see with that? An incorrect table name? An error?

metadaddy gravatar imagemetadaddy ( 2019-05-14 10:11:51 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-05-14 10:10:56 -0500

metadaddy gravatar image

I'm not sure why that isn't working, but you can use the str:concat EL function:

${str:concat('test_',str:toLower(record:attribute('jdbc.tables')))}
edit flag offensive delete link more

Comments

@metadaddy Thank you, It's working now.

Dep gravatar imageDep ( 2019-05-15 04:36:28 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-14 08:25:52 -0500

Seen: 57 times

Last updated: May 14