BLOB Data conversion from Oracle to Postgresql is possible

[prbrganguly]

BLOB Data conversion from Oracle to Postgresql is possible ?

Thanks With Regards

Prabir

prbrganguly@gmail.com

[Anonymous]

Hi @prabir kumar​ 

There is no Blob type in Postgresql, however, we can run an insert SQL on tPostgresqlRow and call function lo_import() to load the file to Postgresql, refer to this article.

Read the Blob Data from Oracle and write the file to local system, and then execute the SQL on tPostgresqlRow.

You can try and let me know if you have any questions.

Regards

Shong

[Anonymous]

Hello @prabir kumar​ ,

Data flow should be:

DbType: BLOB -> Talend (Java) Type: byte[] -> Postgres DbType: bytea

This way the data is read into a bytearray, and can be transported to Postgres.