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
How to configure an Identity Data Collector in RSA Identity Management and Governance 6.9.1 to collect from a .csv file wi… Number of Views StealthAUDIT module for RSA Identity Governance and Lifecycle does not collect data from machines having an IP address wit… Number of Views RSA Governance & Lifecycle Services 101: Dynamic Reports & Charts - What are they and how do you use them? Number of Views CSV Data Collectors of Data Source Type Database return incorrect result sets when joining multiple CSV files in RSA Ident… Number of Views In RSA Identity Governance & Lifecycle, an application restart resets the Aveksa Application request workflows to OOTB if … Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA Authentication Manager 8.9 Release Notes (January 2026) AFX Server Fails to Start with 'Could Not Build a Validated Path' and 'Timed Out Waiting for AFX Applications to Start' in…
Don't see what you're looking for?
