topic Re: Load html data to Oracle Table in Talend Studio

Load html data to Oracle Table

abhi90 — Sun, 01 Apr 2018 08:29:13 GMT

Hi All,

I am very new in the API HTML XML Part of Talend. I got a html file which I have to load to oracle Table and have to do cleansing and further processing. Now the html file looks like(attached) where at the top a line is coming and below it a Table is there where 5 rows present. My Task is to load the data below it under REPORT_GRID. Can anyone tell me how to achieve it? If anyone can help will be really grateful to him or her @rhall, @TRF, @manodwhb, @vapukov, @shong, @xdshi

Re: Load html data to Oracle Table

abhi90 — Sun, 01 Apr 2018 08:36:09 GMT

@vboppudi

Re: Load html data to Oracle Table

abhi90 — Sun, 01 Apr 2018 09:09:54 GMT

I saw 4 custom components available in Talend Exchange for html.anyone of that will be useful for my scenaio?

Re: Load html data to Oracle Table

abhi90 — Sun, 01 Apr 2018 09:48:03 GMT

Anyone with help please

Re: Load html data to Oracle Table

abhi90 — Sun, 01 Apr 2018 18:00:53 GMT

Can anyone help on this topic

Re: Load html data to Oracle Table

abhi90 — Mon, 02 Apr 2018 05:44:42 GMT

Did anyone loaded this kind of html File? If anyone loaded atleast any can u please reply

Re: Load html data to Oracle Table

abhi90 — Mon, 02 Apr 2018 15:37:30 GMT

Can anyone enlight on this issue? @rhall, @TRF, @manodwhb, @vboppudi, @shong, @xdshi

Re: Load html data to Oracle Table

vboppudi — Mon, 02 Apr 2018 15:54:39 GMT

Hi Abhi,

Please go through the following link.

http://dwetl.com/2015/04/20/thtmlinput-parse-html-in-talend/

Regards,

Re: Load html data to Oracle Table

manodwhb — Tue, 03 Apr 2018 06:01:45 GMT

@abhi90,You can try tHTTPTableInput. This component has been designed for extracting data directly from HTML Pages.
http://www.talendforge.org/exchange/tos/extension_view.php?eid=72

Re: Load html data to Oracle Table

abhi90 — Tue, 03 Apr 2018 13:31:02 GMT

Hi @manodwhb,

Thanks for your reply. can you please tell me whether it can be able to load data from html I attached as example?