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!

Maathra