Maathra

Configuring Oracle Autonomous Database as a Datasource for ReportFactory

Configuring Oracle Autonomous Database as a Datasource for ReportFactory

Autonomous Database as a Datasource

Arun Mohan's photo
Arun Mohan
·

2 min read

Table of contents

In this comprehensive guide, we delve into the process of configuring Oracle Autonomous Database as a datasource for ReportFactory.

Downloading Oracle DB Wallet

  • Follow the instructions provided in this article, "Integrating Oracle Autonomous Database with Maathra ReportFactory - Backend," to download the Oracle wallet.

  • Unzip the wallet and move it to the ReportFactory Root Folder --> Wallets.

  • Rename the wallet to match the datasource shortcode. This step is crucial. If you miss this step, ReportFactory cannot recognize the datasource.

Configuring Datasource

  • Log into the ReportFactory administrative screen.

  • Navigate to the datasource by going to Menu --> App Settings --> Datasources.

  • Click "Add New."

  • Check the option "Data source is an Oracle Autonomous Database."

  • Enter the shortcode, using the same name as the wallet folder.

  • Provide a descriptive name for the datasource.

  • Ignore the host and port fields.

  • Enter the TNS name in the servicename field.

  • Enter the username and password.

  • If you are creating an APEX Workspace without changing the default settings, the APEX workspace is prefixed with "WKSP_" to form the username.

Refer to the sample configuration below.

Common Error

Most often, report generation fails due to incorrect username and password. Please validate the username and password and try again. You can also attempt to connect to the workspace schema from SQL Developer using the wallet you have downloaded. If you encounter an "invalid username/password" error, consider logging into SQL Developer Web as the instance admin and resetting the password.

Thank you for following along with our guide on configuring Oracle Autonomous Database as a datasource for ReportFactory. We hope this tutorial has been helpful in enhancing your setup for improved data management and reporting capabilities. Should you encounter any challenges or have additional questions, don't hesitate to reach out for support at or refer back to our detailed documentation. Happy reporting with your newly integrated system!

oracleatporclapex#maathrareportfactory