How to collect data from a .csv file on a password protected FTP server in RSA Identity Governance and Lifecycle 7.0.0
Originally Published: 2016-11-03
Last Modified: 2023-10-06
Article Number
000065578
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle (RSA G&L)
RSA Product/Service Type: All

 
Issue
When 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

 
Resolution
There 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>

Related Articles

Trending Articles

Don't see what you're looking for?