topic Re: BLOB Data conversion from Oracle to Postgresql is possible in Talend Studio

BLOB Data conversion from Oracle to Postgresql is possible

prbrganguly — Fri, 15 Nov 2024 22:59:25 GMT

BLOB Data conversion from Oracle to Postgresql is possible ?

Thanks With Regards

Prabir

prbrganguly@gmail.com

Re: BLOB Data conversion from Oracle to Postgresql is possible

Anonymous — Tue, 26 Apr 2022 05:56:22 GMT

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

Re: BLOB Data conversion from Oracle to Postgresql is possible

Anonymous — Sun, 01 May 2022 17:53:13 GMT

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.