Ask Your Question

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

edit retag flag offensive close merge delete


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

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:

edit flag offensive delete link more


@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


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

Seen: 190 times

Last updated: May 14 '19