Here is a brief description of the components used in a simple migration of Oracle data into a MySQL MyISAM table: tOracleinput (contains one CLOB column) --> tMap --> TMysqlOutput (with a longtext column for the CLOB data) We are using TIS 4.0.3 and this results in an error "cannot convert from Object to String" since the CLOB database column is represented as an Object type in Talend and the MySQL longtext column is represented as a String in Talend. I am hoping that there is someone in this forum that has encountered this issue and has found a resolution. I have used many search terms and did not find any close hits. Thanks.
Thanks, vgalopin for your response. I am glad I posted this in the forum because I am still waiting for Talend Support's reply to my support request (we have TIS). I am not a java expert so any help in how I can use the example you provided will be appreciated. Do I create a Talend Routine? Thanks.
As a matter of fact, the target schema already exists in our case and therefore we followed vgalopin's solution. I just asked for a little help from one of our java folks and we walked through the creation of the custom routine. My realm of expertise is more on the DB-sql-plsql-etc side of things; my java is rusty at best. Thanks a lot to all who assisted here.