How to extract and load data from an Oracle database to hadoop cluster ?

[#1]

Hi,

I'm a newbie in Big Data ecosystem, and I'm looking on a way to connect a Hadoop application to a relationnal database like Oracle Database. Is it possible from a Hadoop application to extract data directly from an Oracle database and load them to a Hadoop cluster ? How can one implements this (if possible) with Hortonworks tools and VM ?

Thanks

[#2 · Accepted solution]

@ida ida

There a couple of ways to accomplish this id recommend starting with sqoop. It is a tool designed specifically to extract data from an RDBMS and load it into Hadoop.

This tutorial should help you get started.