Support Questions

Find answers, ask questions, and share your expertise
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community BlogsRead the Announcement

Secured SSL sqoop for AS400

avatar
New Member

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.