-Re: When use import tool to connect a database, is it possible to store the username and password in a separate properties file for security?
The parameter --connection-param-file is more targeting user experience than a security. It can be used to hide password from command line to a file similarly as parameter -P. However it's worth mentioning that the password will still be serialized into JobConf and thus openly available to all users that have access to the JobTracker.
On Mon, Feb 18, 2013 at 02:05:06PM +0530, abhijeet gaikwad wrote:
> Hi Sam,
> Would this option help?
> --connection-param-file <filename>
> Read more here - http://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html
> On Mon, Feb 18, 2013 at 8:13 AM, sam liu <[EMAIL PROTECTED]> wrote:
> > Hi Experts,
> > Is it possible or has any other similar methods? Because we really want to
> > hide all connection related parameters like username/password in a
> > properties file, for improving security. Our Sqoop version is 1.4.2.
> > Thanks!
> > Sam Liu