How To Use Oracle Wallet with Sqoop Java API?

[Şükrü Hasdemir <su...@fikrimuhal.com>]

Hello,

I'm trying to use the Oracle Wallet when using Sqoop's dev API, doing
something like...

import com.cloudera.sqoop.SqoopOptions()
import org.apache.sqoop.tool.ImportTool()

val options = new SqoopOptions()

// set the sqoop options here

val importTool = new ImportTool()
importTool.run(options)

...inside a Spark job that is meant to programmatically automate multiple
Sqoop jobs and SparkSQL queries. I've tried Googling but could not find an
answer. I know my wallet is configured correctly, because I can use it with
the Sqoop command line client as described in the ASF blog post:

export HADOOP_OPTS= "-Doracle.net.tns_admin=$PWD/wallet
-Doracle.net.wallet_location=$PWD/wallet"

sqoop import -D mapred.map.child.java.opts= '-Doracle.net.tns_admin=.
-Doracle.net.wallet_location=.'

-files $HOME/wallet/cwallet.sso,\
$HOME/wallet/ewallet.p12,\
$HOME/wallet/sqlnet.ora,\
$HOME/wallet/tnsnames.ora \

-connect ‘jdbc:oracle:thin:@w_orcl’ \

<<rest of sqoop options>>

Thanks in advance,

*Sukru Hasdemir*
Co-Founder
Fikrimuhal Technology

sukru@fikrimuhal.com
T: 0 505 804 8186
www.fikrimuhal.com