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
Article Number
Applies To
RSA Product/Service Type: All
Issue
- Data Source Type: Database
- DB type: CSV
- URL in the following format: jdbc:csv:ftp://<hostname>/<path>?<properties>
java.sql.SQLException: Failed to load table sherine:sun.net.ftp.FtpLoginException: Invalid username/password
Resolution
- Include the FTP username and password in the connection URL, with the following format:
jdbc:csv:ftp://<USERNAME>:<PASSWORD>@<IP>?<properties>
- 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
StealthAUDIT module for RSA Identity Governance and Lifecycle does not collect data from machines having an IP address wit… Number of Views 'Request could not be handled' error exporting metadata from RSA Identity Governance & Lifecycle Number of Views RSA Identity Governance and Lifecycle IBM Lotus Notes (Domino) collector does not collect group data. Number of Views Raw Data counts and Task Result counts in Role Collector data runs are sometimes inconsistent in RSA Identity Governance &… Number of Views Request Could not be Handled while generating server.keystore & client.keystore in RSA Governance & Lifecycle Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
