Support Questions
Find answers, ask questions, and share your expertise

I need to sqoop data from an MS SQL DB which has SSL enabled on it. The DBA has provide me a .cer file. How to use that .cer file in my sqoop command?

 
11 REPLIES 11

Mentor

@Syed Shahzer

Can you share your sqoop command please mask only important data !

@Geoffrey Shelton Okot

sqoop import -Dmapred.job.queue.name=fabpops_q1 --connect "jdbc:jtds:sqlserver://XXXXXXXXXXXX;useNTLMv2=true;domain=ms;databaseName=XXXXXX;username=XXXXXXX;password=XXXXXX;encrypt=true;trustServerCertificate=false;trustStore=/mssql.jks" --null-string '' --null-non-string '' --fields-terminated-by --m "1" --query "SELECT * FROM table_name a where \$CONDITIONS" --target-dir XXXXXX