Integrating Oracle Autonomous Database with Maathra ReportFactory - Backend

Autonomous Database as Backend

UpdatedMay 23, 2024

Integrating Oracle Autonomous Database with Maathra ReportFactory - Backend

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 4 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.

Up next

Configuring Oracle Autonomous Database as a Datasource for ReportFactory

Autonomous Database as a Datasource

Introduction

This article explains the steps to configure Oracle Autonomous Database as the backend for Maathra ReportFactory. Please note that these instructions are not applicable if you are using APEX as a service. If you're using a standalone database, refer to this article for configuration: https://blog.maathra.com/guide-to-installing-and-configuring-maathra-reportfactory

This is an additional step to connect to the Autonomous Database as a backend. You must complete the other steps mentioned in this article.

Connecting to Autonomous DB

Connecting to Oracle Autonomous Database involves two steps: downloading the cloud wallet and configuring the JNDI source in Apache Tomcat.

Downloading Database Wallet

Oracle Wallet is a secure container used to store authentication and signing credentials, including private keys, certificates, and trusted certificates, necessary for secure connections to your database.

Log in to your Oracle Cloud account.
Find the Oracle Autonomous Database service you want to connect with ReportFactory.
Click Database Connection
Select Wallet Type: Instance wallet
Create a wallet password and click download
Note down the connection string

Configuring Apache Tomcat

Unzip the downloaded wallet and move it to a secure location on the server.
If you plan to use the same database as a data source, it is recommended to place the unzipped files inside the ReportFactory root folder --> wallets.

Configuring Application Datasource in Apache Tomcat

Open context.xml for editing from the Apache Tomcat Root folder --> conf --> context.xml.

<Resource name="jdbc/OracleDB"
          auth="Container"
          type="javax.sql.DataSource"
          driverClassName="oracle.jdbc.OracleDriver"
          url="jdbc:oracle:thin:@TNS_NAME?TNS_ADMIN=/path/to/wallet"
          username="DB_USER"
          password="DB_PASSWORD"
          maxTotal="20"
          maxIdle="10"
          maxWaitMillis="-1"/>

Add additional jar files to the lib folder to connect to the Autonomous Database

Once you complete the above setup restart the Tomcat server.

Verifying the Installation

Open a web browser and enter the ReportFactory status URL.

    http://host:port/apex-report-factory/scheduler/checkstatus

If the server responds with code 200, the installation is successful.
```
        {"code":"200","message":"All Maathra ReportFactory services are up and running."}
```
Return to the article "abcd" and continue configuring or testing ReportFactory from the section "Configuring Maathra ReportFactory using the APEX application."

Thank you for following this guide. We hope it has provided you with the necessary steps and insights to effectively configure and utilize ReportFactory with the Oracle Autonomous Database. Should you have any further questions or require additional support, please don't hesitate to consult the referenced materials or reach out to our support team at arf.support@maathra.com. Good luck with your continued use of ReportFactory, and we look forward to assisting you in maximizing your reporting capabilities.

Integrating Oracle Autonomous Database with Maathra ReportFactory - Backend

Comments

ReportFactory

Configuring Oracle Autonomous Database as a Datasource for ReportFactory

More from this blog

Installing and Exploring the ReportFactory Demo Application

Configuring Oracle Autonomous Database as a Datasource for ReportFactory

Comprehensive Guide to Installing and Configuring Maathra ReportFactory

Oracle APEX Use Cases: Streamline Approvals

Introduction

Connecting to Autonomous DB

Downloading Database Wallet

Configuring Apache Tomcat

Configuring Application Datasource in Apache Tomcat

Add additional jar files to the lib folder to connect to the Autonomous Database

Verifying the Installation

Command Palette

Comments

ReportFactory

Configuring Oracle Autonomous Database as a Datasource for ReportFactory

More from this blog

Introduction

Connecting to Autonomous DB

Downloading Database Wallet

Configuring Apache Tomcat

Configuring Application Datasource in Apache Tomcat

Add additional jar files to the lib folder to connect to the Autonomous Database

Verifying the Installation