000034325 - How to collect data from a .csv file on a password protected FTP server in RSA Identity Governance and Lifecycle 7.0.0

Document created by RSA Customer Support Employee on Dec 6, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034325
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle (RSA G&L)
RSA Product/Service Type: All
 
IssueWhen trying to collect from a .csv file located on an FTP server using the following configuration:
  • Data Source Type: Database 
  • DB type: CSV
  • URL in the following format: jdbc:csv:ftp://<hostname>/<path>?<properties> 
The test connection is successful, then the Query test fails with the following error: 
java.sql.SQLException: Failed to load table sherine:sun.net.ftp.FtpLoginException: Invalid username/password

 
ResolutionThere are two possible workarounds: 
  1. Include the FTP username and password in the connection URL, with the following format: 
jdbc:csv:ftp://<USERNAME>:<PASSWORD>@<IP>?<properties>

  1. Mount the ftp and browse to it locally in the collection.  For more information and examples, review this article on how to mount remote ftp directory host locally into linux filesystem.  The commands would be as follows:
acm-700:~ # zypper install curlftpfs
acm-700:~ # su - oracle
oracle@acm-700:~> mkdir mnt_ftp
oracle@acm-700:~> curlftpfs <Username>:<Password>@<IP> /home/oracle/mnt_ftp/

In this case the connection URL will be in the following format:

jdbc:csv:////home/oracle/mnt_ftp/?<properties>

Attachments

    Outcomes