https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-extract-and-load-data-from-an-Oracle-database-to/m-p/148783#M28376 <P>Hi,</P><P>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 ? </P><P>Thanks</P> Fri, 16 Sep 2022 10:19:37 GMT dayidir 2022-09-16T10:19:37Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-extract-and-load-data-from-an-Oracle-database-to/m-p/148783#M28376 <P>Hi,</P><P>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 ? </P><P>Thanks</P> Fri, 16 Sep 2022 10:19:37 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-extract-and-load-data-from-an-Oracle-database-to/m-p/148783#M28376 dayidir 2022-09-16T10:19:37Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-extract-and-load-data-from-an-Oracle-database-to/m-p/148784#M28377 <P><A rel="user" href="https://community.cloudera.com/users/10481/dayidir.html" nodeid="10481">@ida ida</A></P><P>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.</P><P><A href="https://community.hortonworks.com/articles/14802/sqoop-importexport-tutorial.html">This tutorial</A> should help you get started.</P> Mon, 16 May 2016 00:07:53 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-extract-and-load-data-from-an-Oracle-database-to/m-p/148784#M28377 emaxwell 2016-05-16T00:07:53Z