Oracle to Postgres - XML_TYPE and CLOB conversion

Highlighted
One Star

Oracle to Postgres - XML_TYPE and CLOB conversion

Hi, I am currently trying to migrate an existing Oracle DB (with data already in it) to a new Postgresql DB. Each table I am migrating over has at least one field of XML_TYPE or CLOB type. I would like to convert these two types to the existing corresponding types in Postgres, but I am having a hard time doing this. I understand there is an "XML" type and "TEXT" type in Postgres, and I am trying to us the tMap component to map these values to each other, but I am not sure how to do it. Any help is greatly appreciated! Thanks!
Highlighted
Four Stars

Re: Oracle to Postgres - XML_TYPE and CLOB conversion

Hi,
Have you tried tConvertType?
Vaibhav
Highlighted
One Star

Re: Oracle to Postgres - XML_TYPE and CLOB conversion

Yes I have tried but I'm having trouble - if I have a CLOB or XML type they start out as "Object" types and then to write them to another database type, which type do I want to convert them to? I try mapping an Object to a String but it fails when I try to run it...
Looks like this when failing (and nothing gets added to the table):
Batch entry 0 INSERT INTO "TABLE1" ("XML_FILE") VALUES (oracle.sql.CLOB@386ac2) was aborted. Call getNextException to see the cause.

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog