Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to extract data from a webpage(Updates daily) to any target format

Status
Not open for further replies.

learnb2b

Technical User
Oct 11, 2010
1
US
Hello Friends.
I have encountered a situation.




I want to pull the data from a webpage, using any transformation I have to load the data into target ( Oracle, DB2, Teradata, Flat File or XML File) Any format is fine.




The data will be updated every day on the webpage.
so I have to extract that data using any transformation and load it to any format.



Please suggest me a solution. I thought of using HTTP transformation. Please let me know how to set paramaters, etc. Can you explain step by step.

Can you send me step by step solution, because I never did such type of ETL.

Can you tell me the step by step apporach, i.e how to do it using informatica what transformations I have to use, what paramaters I have to set. And how can I save a web page as xml. Can you please let me know how to do that.



Thank You



Regards



J
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top