Operational Reporting architecture
This topic outlines the connections and flow of data between the user, Sterling™ Order Management System, and IBM Cognos Analytics.
- Log in from the Cognos Analytics web page.
- Use one of two single sign-on links in Sterling Order Management System. These links are located in the Business Center (Launch Business Intelligence under Products, Pricing, Customer, or Inventory modules) and Application Console (Business Intelligence > Launch Reports).
Any authorized user can generate and view reports once they are logged into Cognos Analytics. For more information about the user groups and permissions, see Cognos user groups and permissions.
In the production environment, the reports run against the High Availability Disaster Recovery (HADR) standby database to prevent any performance issues in Sterling Order Management System. There is a nominal delay of a few milliseconds between data in the live production database and data in the standby database. So, when you run reports, you have access to the most recent data. These reports can be run either on demand or scheduled to run at preset times, and be configured to either save their output to Cognos or email the report.
To minimize downtime in production, the Cognos server has backup servers that can take over if only specific components require restarting. However, there might still be minor outages if the entire system needs to be restarted.
