Simplify Oracle BI Publisher Report Management Upload & Download

Managing Oracle BI Publisher reports and data models across multiple Oracle Cloud instances, such as development, testing, and production, is typically a cumbersome task. Teams often create, test, and optimize BI Publisher reports and their data models in a development environment before migrating them to production.

The traditional process involves manually exporting BI Publisher reports from one instance and then importing them into another. This manual method is time-consuming, error-prone, and lacks transparency, especially when dealing with complex or frequent migrations. Fusion Toolkit CLI simplifies this process significantly.

This detailed guide shows how you can automate the entire BI Publisher report management process using the Fusion Toolkit CLI, allowing seamless migrations and reliable synchronization across Oracle Cloud environments.

Why Automating BI Publisher Management Matters

Oracle Cloud ERP setups typically involve multiple environments, each with its specific role:

Development (DEV): Used by developers for initial creation and testing of BI Publisher reports and data models.
Test (TEST): QA environment to test report accuracy, performance, and integration.
Production (PROD): The live environment serving your business users.

When migrating BI Publisher reports and data models from DEV to PROD, IT administrators and ERP consultants regularly face several common issues:

Manual exports: Exporting BI Publisher artifacts manually is repetitive, error-prone, and difficult to track.
File Management Issues: Handling zipped archives manually can lead to version mismatches or overwrites.
Security & Control: Manual uploading Bi Publisher Object can give permission issues

Fortunately, Fusion Toolkit CLI was designed specifically to address these issues, streamlining the entire BI Publisher management lifecycle securely, reliably, and quickly.

Why Use Fusion Toolkit CLI for BI Publisher Management?

The Fusion Toolkit CLI provides easy-to-use commands for securely downloading, archiving, and uploading BI Publisher reports, data models, or entire folders, directly through a command-line interface. Key benefits include:

Quick migrations: Archive an entire report folder from one instance, and seamlessly import it into another in seconds.
Easy Version Control: Downloaded report archives can be easily version-controlled in Git, making audit trails simple.
Security and Local Control: Data and credentials remain securely stored on your infrastructure, with no data leaving your control.

Typical Use-Case: Migrating BI Publisher Reports from DEV to PROD

Let’s explore a detailed example where we’ll migrate a folder containing BI Publisher reports and data models from a DEV instance to a PROD instance using Fusion Toolkit CLI.

Configure Fusion Toolkit to Connect to DEV Environment

Ensure Fusion Toolkit is installed and configured with OpenJDK 17+ on your machine. Set your configuration to point to your DEV Oracle Cloud ERP instance first. Read more in the documentation.

java -jar ./fusion-cli-toolkit.jar set-config \
    --username="DEV_ADMIN_USER" \
    --password="DEV_USER_PASSWORD" \
    --hostname="https://dev-pod.fa.ocs.oraclecloud.com:443" \
    --licenseKey="YOUR_FUSION_TOOLKIT_LICENCE_KEY"

Download a BI Publisher Folder or Report

For this example, we’ll assume you’ve created and optimized a report AP_INVOICES_ALL_R and its associated Data Model AP_INVOICES_ALL_DM stored under the folder path shared/Custom/SQL in your DEV environment.

To download the entire folder (shared/Custom/SQL) from DEV, run:

java -jar ./fusion-cli-toolkit.jar bi-publisher-download \
    --reportPath="/Custom/SQL" \
    --outputFile="./SQL_FOLDER.xdrz"

Fusion Toolkit CLI securely communicates with Oracle Cloud BI Publisher via SOAP APIs to download your reports and saves the result as a .xdrz archive file.

Now, your report and data model are securely archived and ready for migration.

Switching Configuration to PROD Environment

Before uploading the report archive to your production environment, update the CLI configuration to point to your PROD Oracle Cloud ERP environment:

java -jar ./fusion-cli-toolkit.jar set-config \
    --username="PROD_ADMIN_USER" \
    --password="PROD_USER_PASSWORD" \
    --hostname="https://prod-pod.fa.ocs.oraclecloud.com:443"

Uploading Reports to the PROD Environment

To upload your archived folder to the PROD environment, use the following command:

java -jar ./fusion-cli-toolkit.jar bi-publisher-upload \
    --file="./SQL_FOLDER.xdrz" \
    --targetPath="/Custom/SQL"

The Fusion Toolkit CLI uploads your archived folder using Oracle Cloud API, unpacking and creating the report and associated data model in the designated folder path automatically.

Within seconds, your PROD environment is synchronized with the DEV environment, completely eliminating manual intervention and drastically reducing migration errors.

Benefits Recap

Automating BI Publisher management using Fusion Toolkit CLI delivers immediate benefits:

Reduced errors through automated, scripted transfers.
Improved productivity: Save hours of manual labor every week.
Easy scheduling and integration with your existing systems.
Increased security by maintaining control of data at all stages.
Simplified change management with clear version history.

Fusion Toolkit CLI transforms your Oracle BI Publisher management, migration, and data export processes into efficient, reliable, automated workflows. By automating downloads/uploads and parameterized report execution, your teams save valuable time, reduce errors, and streamline ERP integrations, enabling faster innovation and higher data integrity.

Simplify Oracle BI Publisher Report Management Tasks