Oracle Fusion BI Publisher - SFTP server using SSH

N i c k

Summary

Oracle Fusion BI Publisher - SFTP server using SSH

Content

Anyone had any success and willing to share how to set up BI publisher sftp using SSH private key file?

If yes:

What format was the key: SSH-1, SSH-2 RSA, SSH-2 DSA, OpenSSH?

Bits?

What are the requirements?

We have tried using PuTTY Key generator and TIBCO MFT key generator. 

Every key we tried returns: Could not establish connection. oracle.xdo.delivery.ssh2.transport.publickey.InvalidSshKeyException: The key format is not a supported format

The following Documents where followed but didn't resolve issue.

Doc ID 2282898.1 - Oracle Fusion BI Publisher: How to setup private key authentication with sFTP delivery

Doc ID 2329541.1 - Fusion BI Publisher - External SFTP Authentication With Private Key Fails With: Could Not Establish Connection.

oracle.xdo.delivery.ssh2.SshException: Exception in Authenticating

N i c k

Oracle BI Publisher 11.1.1.9.0 (build:20171025.0622) doesn't support AES.

Generated a new key-pair (using ssh-keygen command on unix) with DES encryption instead of AES.

Doc ID 2342872.1 - Fusion Application Bi Publisher - How to generate SFTP private key using SSH-KEYGEN command and import the same to SaaS