Load html data to Oracle Table

Eight Stars

Load html data to Oracle Table

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 Smiley Happy @rhall_2_0@TRF@manodwhb@vapukov@shong@xdshi

 

Eight Stars

Re: Load html data to Oracle Table

Eight Stars

Re: Load html data to Oracle Table

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

Eight Stars

Re: Load html data to Oracle Table

Anyone with help please

Eight Stars

Re: Load html data to Oracle Table

Can anyone help on this topic
Eight Stars

Re: Load html data to Oracle Table

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

Re: Load html data to Oracle Table

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

Nine Stars

Re: Load html data to Oracle Table

Hi Abhi,

 

Please go through the following link.

 

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

 

Regards,

 

Veeru Boppudi
Thirteen Stars

Re: Load html data to Oracle Table

@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

Manohar B
Eight Stars

Re: Load html data to Oracle Table

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?

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.