topic Re: Extract Blob from Oracle in Talend Studio

Extract Blob from Oracle

Anonymous — Sat, 16 Nov 2024 11:44:12 GMT

Hello,
i work in an oracle database and i want to extract pictures of client. This pics was encoded in Blob field.
I try to export in tfiledelimited, but it doesn't work because i have 275 clients.
I would like to know how i can create 275 jpg files and if it's possible rename pic with the id_cli (primary key)

regards
Dams

Re: Extract Blob from Oracle

Anonymous — Fri, 28 Feb 2014 20:03:33 GMT

I am working on a tLOBDownload component. This component will accept a record set made by the tOracleRow component. In the tLOBDownload component you have to configure the columns you need for download the BLOB/CLOB and identify the LOBs (e.g. key fields or file names in the database).
You have to define the file name for the LOBs by the help of these fields.
The component iterates through the record set (actually a Java ResultSet) and writes all LOBs into files (one LOB has its own file).
Does this solution would fit also to your needs?

Re: Extract Blob from Oracle

Anonymous — Mon, 03 Mar 2014 10:04:09 GMT

hello,
thanks for your answer. That's exacltly that i would!

Re: Extract Blob from Oracle

Anonymous — Tue, 04 Mar 2014 21:17:26 GMT

I have published this component. It would be great if you try it and provide feedback for it. If you experience any problems please contact me or post it in this forum. This component is tested only by me as developer and is only in usage in one project so far.
http://www.talendforge.org/exchange/index.php?eid=1135&product=tos&action=view&nav=1,1,1

Re: Extract Blob from Oracle

Anonymous — Thu, 06 Mar 2014 13:07:19 GMT

Jan,
it's working fine.
Thanks a lot

Re: Extract Blob from Oracle

Anonymous — Thu, 11 Sep 2014 04:36:41 GMT

Is this just for Oracle? or can it be used for MSSQL?

Re: Extract Blob from Oracle

Anonymous — Thu, 11 Sep 2014 16:19:44 GMT

please help to install complent in talend 5.5.1, don´t apear in pallete

Re: Extract Blob from Oracle

Anonymous — Thu, 11 Sep 2014 16:24:56 GMT

hi,
talend help is done for you :
https://help.talend.com/search/all?query=Installing+a+custom+component&content-lang=en
regards
laurent

Re: Extract Blob from Oracle

Anonymous — Thu, 11 Sep 2014 22:58:34 GMT

The component tLOBDownload:
http://www.talendforge.org/exchange/index.php?eid=1277&product=tos&action=view
does not depend on Oracle. It works with every database which provides objects with the java.sql.Clob or java.sql.Blob interface.

Re: Extract Blob from Oracle

Anonymous — Thu, 15 Jan 2015 22:15:53 GMT

sorry, the component doesn't work for me...
context.pathWORKSPACE1 is the directory where I want to save the files
tjavarow_1 shows information only
no error, no files.... What happen? I'm running 5.4.1 on ubuntu linux.
thanks for your help.
--

Re: Extract Blob from Oracle

Anonymous — Fri, 16 Jan 2015 08:30:11 GMT

Ok, now works. It was my fault with the schema.
sorry about that.

Re: Extract Blob from Oracle

Anonymous — Fri, 16 Jan 2015 08:40:21 GMT

Great to hear 😉

Re: Extract Blob from Oracle

Anonymous — Fri, 16 Jan 2015 19:33:07 GMT

Hello,
I just downloaded this tLobdownload component and tried to use it.
I have a problem. I am wondering what data type I should put for the blob column. See the attached image. Thanks!

Re: Extract Blob from Oracle

Anonymous — Sat, 17 Jan 2015 10:39:37 GMT

No please use as type Object. If you let the studio decide the type in this case it does not work.

Re: Extract Blob from Oracle

Anonymous — Wed, 21 Jan 2015 18:29:59 GMT

Thanks! It works fine now.

Re: Extract Blob from Oracle

Anonymous — Wed, 21 Jan 2015 21:23:46 GMT

Great! Have a lot of fun... (This was for a couple of years ago the standard greeting of SuSE Linux 😉

Re: Extract Blob from Oracle

Anonymous — Fri, 29 May 2015 23:01:26 GMT

sorry, the component doesn't work for me...
context.pathWORKSPACE1 is the directory where I want to save the files
tjavarow_1 shows information only
no error, no files.... What happen? I'm running 5.4.1 on ubuntu linux.
thanks for your help.

logarda,
After I added a javarow in bewteen dbinput and tLOBDownload components, I got nothing saved in my output. No error. May I know how you solved the problem?
Thanks!

Re: Extract Blob from Oracle

Anonymous — Sat, 30 May 2015 08:58:29 GMT

The tJavaRow does not connect the flows automatically. You have to synchronise the schema and click on Generate Code to get the Java code to transfer the values. After this you can add you own code or tweak the existing one.

Re: Extract Blob from Oracle

Anonymous — Mon, 01 Jun 2015 19:52:57 GMT

Exactly! Thanks, jlolling!

Re: Extract Blob from Oracle

Anonymous — Mon, 01 Jun 2015 20:17:43 GMT

Hi jlolling,
If I want to process the output file from stream instead of saving it to a file, do you know if there is a way?
The workflow is like this: DBInput - tJavaRow - tFileInputExcel.
It is work fine if save the blob into a file and let tFileInputExcel read from a file. I am wondering if we can let tFileInputExcel directly read from stream.
Thanks!