You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Manickam P <ma...@outlook.com> on 2013/07/30 13:53:45 UTC
Sqoop Connect with oracle
Hi Experts,
Do we need to install oracle client to connect with oracle database from sqoop? bcoz we need to mention the service name in import command. Will it work without having the oracle client?
Please tell me.
Thanks,
Manickam P
Re: Sqoop Connect with oracle
Posted by Venkat Ranganathan <vr...@hortonworks.com>.
You need the Oracle T4 JDBC driver only to use Sqoop - not the complete
client installation. The JDBC URL has the format
jdbc:oracle:thin:@host:port:siid
or jdbc:oracle:thin:@//host:port/service
Thanks
Venkat
On Tue, Jul 30, 2013 at 4:53 AM, Manickam P <ma...@outlook.com> wrote:
> Hi Experts,
>
> Do we need to install oracle client to connect with oracle database from
> sqoop? bcoz we need to mention the service name in import command. Will it
> work without having the oracle client?
>
> Please tell me.
>
>
> Thanks,
> Manickam P
>