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

Highlighted
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
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
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?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download