Securing imported data in FDI

Stefano_Mazzocca

I need to know what kind of security is available for importing csv file in FDI through sftp, in particular:

1. Is it possible to authenticate via SSH key? It seems so by looking at this, I just want to be sure: https://docs.oracle.com/en/cloud/saas/analytics/26r1/fawag/load-data-from-sftp-source-into-fusion-data-intelligence-preview.html
2. Is it possible to import a PGP encrypted file (or any other type of encryption)?

Thank you

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/28329/securing-imported-data-in-fdi

Hi @Stefano_Mazzocca,

I think you are correct for Point 1. Not sure about Point 2.

On a separate note: If you are looking for Role Level security to External Data in FDI; please take a look into the following Oracle Video.

https://www.youtube.com/watch?v=KPGIf7fBXvs

Hi @Sumanth V -Oracle,

Hope you are well. Can you please help and share your expert opinion?

Sumanth V -Oracle

@Stefano_Mazzocca - Please find the responses below:

• Yes, it is feasible to connect to an SFTP server using the connector provided by FDI. The connector supports authentication using a username, password, and private keys.
• At present, the connector supports only unencrypted CSV files. Encrypted files are not supported because there is no mechanism available for defining decryption within the connector.

Note: The SFTP server’s IP address must be provided as a public IP. Hostnames, fully qualified domain names (FQDN), or Class A private IP addresses are not supported as part of the prerequisites.

Hope this clarifies. Thanks for using Oracle community!.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/75389#Comment_75389

Very helpful as always.

Thank you very much @Sumanth V -Oracle! Much appreciated.