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.

1. Log in to your Oracle Cloud account.

2. Find the Oracle Autonomous Database service you want to connect with ReportFactory.

   

3. Click Database Connection

4. Select Wallet Type: Instance wallet

   

5. Create a wallet password and click download

   

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

• https://mvnrepository.com/artifact/com.oracle.database.security/oraclepki/19.3.0.0

• https://mvnrepository.com/artifact/com.oracle.database.security/osdt_cert/19.3.0.0

• https://mvnrepository.com/artifact/com.oracle.database.security/osdt_core/19.3.0.0

  

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.