Sqoop Teiid with truststore

[w4shington]

Hello,

I am trying to access a VIrtual Database from JBoss Data Virtualization using Sqoop. This database is defined to connect using a Truststore (JKS format), using another application like Squirrel i can connect using the following argument:

 -Djavax.net.ssl.trustStore=/home/user/truststore-xxxxx.jks

Does anyone knows how can I use this argument with Sqoop?

Ps.: I already deploy my .jar file on $SQOOP_HOME/lib.

Thank you

[rareddy]

Before this can work, there are couple questions

1) Test with Sqoop with JDV without any SSL.

2) Have you configured the JDV to use SSL? Have you configured the JDBC transport to use SSL? Some instructions on this is at JDBC/ODBC SSL connection using self-signed SSL certificates with Teiid or in Teiid documents Teiid Server Transport Security · Teiid Documentation and SSL Client Connections · Teiid Documentation

3) have you tested (1) without Sqoop? Like using plain java client or tool like SquirreL

If you finished (1), (2) and (3)  then you can try with Sqoop to see if that works.

Ramesh..