Oracle to Postgres - XML_TYPE and CLOB conversion

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!
Four Stars

Re: Oracle to Postgres - XML_TYPE and CLOB conversion

Hi,
Have you tried tConvertType?
Vaibhav
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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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