Support Questions

Find answers, ask questions, and share your expertise

Secured SSL sqoop for AS400

avatar
New Contributor

Hi All

 

We are able to make non-secure SSL SQOOP connection with AS400 using below commands

SQOOP import \

–driver com.ibm.as400.access.AS400JDBCDriver \

–connect jdbc:as400://as400servername/dbname \

–username  –password \

–query ‘SELECT * FROM table where $CONDITIONS’ \

–hive-import \

–hive-table table \

–target-DIR /user/HDFS/example \

–fields-terminated-by ’01’ \

–split-by <id> \

-m 4;

I am looking for a way to make it Secured connection . Even though i use secured port 9471 , it defaults to non secured port .

 

please help 

1 REPLY 1

avatar
Master Mentor

@Anup123 
I responded to a similar question see SSL Sqoop
If already have an SSL cert file, then you can generate your own JKS file and import your cert into your jks.