Hello Ruby, You can use FTP/SFTP connection in Informatica Cloud for your usecase: Refer below doc https://docs.informatica.com/integration-cloud/cloud-data-integration/current-version/data-integration-connections/connection-properties/ftp-sftp-connections.html https://kb.informatica.com/faq/7/Pages/18/506098.aspx Thanks, Ashwini
Thanks Ashwini . Yes I tried FTP/SFTP Connector and its working fine . Actually I didnt eloborate properly in my original question . My source is sql query and target should be flat file in remote sftp server . Currently the source sql queries result export as flat file to informatica and again in the same mapping task change the target as FTP/SFTP and file exporting to remote SFTP . Instead i want to export directly the sql queries result to remote SFTP.
Hello Ruby, We have File processor connector which as feature to move file to the SFTP server. https://docs.informatica.com/integration-cloud/cloud-data-integration-connectors/current-version/file-processor-connector/preface.html Please go through above doc,let us know if helps your use case. Thanks Ashwini