📌 Note: The following steps apply only to Mosaic versions earlier than 24.1.
Important
Mosaic can use a separate ReportDS datasource to improve report generation performance. We expect the datasource to point to a read-only copy of the Mosaic database, refreshed nightly. In Mosaic, the system property enableReportDatasource must be set to ‘true’ for this datasource to work. If the system property has any other value, Mosaic will ignore the datasource and generate reports from the existing Mosaic instance.
Creating a ReportDS datasource for the Job Scheduler
Step 1
Log into the WebLogic Administration Console (usually http://NameOfMachine:7001/console)
Step 2
Click on DataSources in the Services section:
Step 3
Create a new generic DataSource by clicking on New → Generic DataSource.
Step 4
⚠️ Important: Ensure Data Sources Are Targeted Correctly Each managed server should have exactly two data sources targeted to it - one with a JNDI name of OracleDS (the main data source), and one with a JNDI name of ReportsDS (the reports data source). What you call these is up to you, but you should never target a data source to more than one managed server.
Follow the instructions the same way as for creating the main datasource. However, you should ensure that on the first Generic Datasource screen, instead of using OracleDS, you must specify ReportsDS as the JNDI name, as per the below screenshot.
Step 5
Continue to follow the instructions as per the main data source configuration. Finally, please ensure that on the Select Targets page, select the Managed Server.
Step 6
Click Finish.
📌 Note: To access the below link, you'll be redirected to the Access Portal.
If you’d like more information on creating a datasource, check out page 57 of our Installing, Configuring, and Maintaining Mosaic guide.