Skip to Content

Connecting AR System data source with a replicated read-only AR database

Remedy Smart Reporting users can connect with a read-only replicated AR database for reporting operations. To keep the AR production database unaffected but allow Remedy Smart Reporting users to continue with the reporting operations, you must connect your AR System data source with a read-only replicated AR database.

To avoid issues related to license updates, complete the user onboarding process by connecting with a read/write AR production database. After completing the user onboarding process, perform the following steps to connect your AR System data source with a read-only replicated AR database.

Warning

Important

The Remedy Smart Reporting database must always be in read/write mode.

  1. Log in to Remedy Mid Tier as a Remedy Smart Reporting administrator.
  2. Navigate to Applications > Smart Reporting > Smart Reporting console.
  3. On the Remedy Smart Reporting console, navigate to Administration > Admin console > Data sources.
  4. Click AR System connection.
  5. Under the Connection section, in the Host field, enter the AR Server host name that is connected to the read-only replicated AR database.
  6. Under the Test Connection section, click Click here to test connection to check if the connection works. 
  7. Click Save to complete the connection setup.

Success

Best practices when generating reports against a read-only database
You must restart the AR System server before generating reports against a read-only database that contains modified or customized objects such as forms, fields, or active links. 
Restarting the AR System server ensures that the changes you made to the schema are reflected in your report.

This recommendation applies to all objects that are cached by the AR System server. You can modify the objects through Developer Studio, Innovation Studio, D2P deployment, or any other mechanism that you follow to modify the objects.

(SaaS subscribers) If there are any changes in the production system and you want those changes to be reflected in a report, contact BMC support.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Remedy Smart Reporting 19.11