Installing and Exploring the ReportFactory Demo Application

A Guide to Advanced Printing Solutions

PublishedMay 22, 2024

Installing and Exploring the ReportFactory Demo Application

I am an experienced IT professional with over 10 years of expertise in ERP, specializing in manufacturing and finance modules.

As a solution architect, I am skilled in Oracle PL/SQL and Oracle APEX, with experience in software development, project management, and solution architecture.

Leveraging my expertise in Enterprise Performance Management (EPM), I help businesses make data-driven decisions and improve their performance.

I am committed to staying current with the latest trends and technologies in the industry and enjoy collaborating with colleagues and clients to design and implement solutions that align with their unique business needs.

If you would like to learn more about my experience or have any questions, please feel free to connect with me.

Comments

Join the discussion

No comments yet. Be the first to comment.

ReportFactory

Part 6 of 6

In this series, we will explore every aspect of leveraging Maathra ReportFactory for print reports in Oracle APEX, guiding you from download to configuration and beyond. Stay tuned for expert tips.

Start from the beginning

Maathra ReportFactory: Introduction

Simplifying Print Reporting for Oracle APEX

Introduction

Welcome to the comprehensive guide on installing and exploring the ReportFactory Demo Application. This application is designed to showcase a variety of use cases including QR code generation, invoice printing, and continuous printing among others. Whether you're looking to enhance your understanding of ReportFactory's capabilities or need a practical demonstration of its diverse applications, this guide will provide step-by-step instructions to help you set up and navigate through the demo. Explore the full potential of ReportFactory and discover how it can transform your reporting and printing processes.

Prerequisites

ReportFactory is installed and configured.
A schema with a sample data set has been added.
Sample report templates have been downloaded and copied to the ReportFactory templates folder.

Installing Sample Data Set

This tutorial uses a sample data set provided on Oracle Autonomous Database. Before installing the application, ensure that the sample data set is installed. If it is not installed, follow the steps given below.

Log in to Oracle APEX Workspace
Navigate to SQL Workshop --> Utilities --> Sample Datasets
Install "HR Data"
Click Next and click "Install Dataset"
Review the objects in object browser

Uploading Report Templates

From the downloads, copy all report templates and images to the report templates and logo directories, respectively, on the report server.

Installing Demo Application

Login to Oracle APEX
Import the demo application "arf-demo-app.sql" from the downloads
Follow the onscreen instructions to complete the installation
Make sure supporting objects are upgraded
If the installation is successful, it will add the following database objects
- Tables
  - MTC_ARF_CONFIG
  - MTC_SCHEMA_LOG
- Packages
  - MTC_RPF_UTILITIES_PKG
If these objects are not shown, go to Application --> Supporting Objects and click "Upgrade Supporting Objects" from the right-side menu

Configure Demo App

Think of this demo application as your APEX app where you want to integrate Maathra ReportFactory.

To invoke Maathra ReportFactory APIs, you need to pass a token. This token will be validated by ReportFactory on every request.

Run the Demo Application
Log in with the default username and password.
We recommend that you modify the authentication scheme to suit your business needs.
From the left menu, click on "ARF Configuration."
Update the settings with values from the "ReportFactory" administrative application
Organization ID: The numeric ID displayed on the navigation bar of your ReportFactory APEX application
Base URL: https://<your reportfactory domain>/apex-report-factory
Client ID: Client ID generated from the "ReportFactory" administrative application
Client Secret: Client Secret generated from the "ReportFactory" administrative application

Auth Token key: Visit "ReportFactory" administrative application --> App Settings --> App Variables --> TOKEN_KEY

Configure Data Sources

Complete the data source configuration in the ReportFactory administrative application to query data from the schema where you installed the Demo app.

Based on the database type i.e, standalone or autonomous database, the configuration changes.

Standalone DB: Refer to the section "Configure Report Data Source (Non-autonomous Oracle Database)" in the article "Comprehensive Guide to Installing and Configuring Maathra ReportFactory"
Autonomous DB: Refer to the article https://blog.maathra.com/maathra-reportfactory-oracle-adb-data-source

Update Datasource in Reports

Once the data source is configured, update the new data source in the report definition.

Navigate to Menu --> Report Definition
Open the reports for which you want to update the data source
Click Edit
Select the data source you want to use and click save

Explore Sample Reports

Navigate to different pages and explore various uses.

Thank you for exploring the setup and capabilities of our demo application. We hope this guide has been helpful in demonstrating how ReportFactory can streamline and enhance your reporting processes. If you have any further questions or need additional support, feel free to reach out or consult our documentation. Happy reporting with ReportFactory!

Installing and Exploring the ReportFactory Demo Application

Comments

ReportFactory

Maathra ReportFactory: Introduction

More from this blog

Configuring Oracle Autonomous Database as a Datasource for ReportFactory

Integrating Oracle Autonomous Database with Maathra ReportFactory - Backend

Comprehensive Guide to Installing and Configuring Maathra ReportFactory

Oracle APEX Use Cases: Streamline Approvals

Introduction

Prerequisites

Installing Sample Data Set

Uploading Report Templates

Installing Demo Application

Configure Demo App

Configure Data Sources

Update Datasource in Reports

Explore Sample Reports

Command Palette

Comments

ReportFactory

Maathra ReportFactory: Introduction

More from this blog

Introduction

Prerequisites

Installing Sample Data Set

Uploading Report Templates

Installing Demo Application

Configure Demo App

Configure Data Sources

Update Datasource in Reports

Explore Sample Reports