Loading Excel into Hortonworks

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
mehimadri_123
Premium Member
Premium Member
Posts: 3
Joined: Sat Aug 26, 2017 7:55 pm

Loading Excel into Hortonworks

Post by mehimadri_123 »

Hello Friends,

Can anyone done this and let me know how to load an excel file into Hortonworks?

Thanks!
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Break down the problem into two parts. (1). Read an excel file with DataStage. This is done using the Unstructured Stage. Get that working sending the data to something simple, like a local Sequential File. (2). Work on loading hdfs or hive in Hortonworks. This might be the FIle Connector, or the ODBC Connector, or the JDBC Connector, or the Hive Connector, depending upon your release, your performance requirements, your drivers available, skill sets, etc.

Once both are working, put them together.....don't try to do this all in one step.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply