Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher report encryption

Accepted answer
47
Views
5
Comments
User_SI7HK
User_SI7HK Rank 4 - Community Specialist

Hi, we are using OAS 7.0, OBIA 7.9.6.4, EBS 12.2.1 with Oracle19c database on Linux. We have a BI Publisher report that runs on a query based on EBS tables (real time) which has sensitive data. We have made the report content that is distributed as email attachment, password protected but the users are asking for the report content to be encrypted during distribution for security reasons. Is there a way to encrypt the report content while it is being distributed as email attachment, in addition to being password protected. Any tip is highly appreciated.

Best Answer

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead
    Answer ✓

    Excel can be password protected.

    And the file can be encrypted when sent to a SFTP target. The link I sent includes details:
    Use PGP Keys for Encrypted Report Delivery

    Rgds,

    Kevin

Answers

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    See Administering Oracle Analytics Publisher in Oracle Analytics Server

    Chapter 11 Secure Reports.

    https://docs.oracle.com/en/middleware/bi/analytics-server/administer-publisher-oas/secure-reports.html#GUID-E5C7DAD2-622A-4FFC-AAB4-E7EB6917BF19

    Rgds

    Kevin

  • User_SI7HK
    User_SI7HK Rank 4 - Community Specialist

    Thanks Kevin, I see the PDF output has option for encryption, we are using excel output, is there a way to apply/extend the encryption on excel output of the BI Publisher report ?

  • User_SI7HK
    User_SI7HK Rank 4 - Community Specialist

    Thanks Kevin, that was helpful, we will explore the FTP route for delivering encrypted BIP reports.

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    Glad I could help.

    Kevin