OpManager

Integrating with OpManager

Analytics Plus seamlessly integrates with ManageEngine OpManager, and enables you to easily analyze your OpManager data by generating detailed reports on alarms, business views, availability, inventory, performance data, and much more.

General

  1. What is Analytics Plus?
  2. What are the highlights of this integration?

Setup

  1. How do I integrate Analytics Plus with OpManager?
  2. How long should I wait for my OpManager data to appear in Analytics Plus initially?
  3. Can I edit the synchronization settings?
  4. Can I synchronize my OpManager company data instantly?
  5. How do I create custom reports over my OpManager data?
  6. Can I set up the OpManager integration in existing workspaces in Analytics Plus?
  7. Is it possible to create multiple OpManager integration setups in Analytics Plus?
  8. How do I remove this setup?

Data synchronization

  1. What is the synchronization behavior of the tables imported from OpManager?
  2. What should I do when the data synchronization fails?
  3. How do I enable analytics on Interface Performance metrics and granular CPU utilization?

Reporting Features

  1. What are the report types supported by Analytics Plus?
  2. Can I modify the pre-built reports created on integrating with OpManager?
  3. How do I create reports using fields/columns across different OpManager modules?
  4. What are formulas in reports?
  5. Is it possible to create custom formulas in Analytics Plus?
  6. Can I modify the tables imported from OpManager?
  7. Can I add new columns to the tables imported from OpManager?
  8. Can I import new tables into the OpManager workspace?
  9. Can I combine data from other sources with the data from OpManager, and create reports and dashboards?
  10. What are Query Tables?

Sharing & Collaboration

  1. How do I share reports, dashboards, and tables in Analytics Plus?
  2. Why are my colleagues unable to access the reports I create?
  3. Can other users create reports using the tables in the OpManager workspace?
  4. Is it possible to share the same report to multiple users such that they each see different data?
  5. Can I export a report or a dashboard?
  6. How do I print the reports and dashboards created in Analytics Plus?
  7. Can I email reports and dashboards at scheduled times?
  8. Can I embed reports?

Help & Support

  1. How do I get technical support on Analytics Plus?
  2. Can I have get a personalized demo of this integration?

General

1. What is Analytics Plus?

ManageEngine Analytics Plus is an on-premises reporting and business intelligence application that helps you analyze your IT data and create insightful reports & dashboards for informed decision-making. It offers the following important capabilities:

  • Import data from local files, web feeds, local and cloud databases, and cloud storage/drive.

  • Displays data in an easy-to-view excel format.

  • Build custom reports and dashboards easily, with the drag-and-drop report builder.

  • Supports powerful visualizations in the form of charts, pivot tables , summary views, tabular views, and dashboards

  • Generate reports and KPIs in seconds with Zia, Analytics Plus' intelligent analytics assistant powered by Machine Learning and Artificial Intelligence.

  • Create custom formulas using the built in formula engine that contains a wide range of mathematical, statistical and logical functions.

  • Share reports and dashboards with your colleagues easily, through a wide range of collaboration features. 

  • Export and publish reports and dashboards in various formats, and configure permissions and filters for the views.

  • Supports out-of-the-box integrations with a wide number of applications, to give you pre-built reports and dashboards on your application's data within minutes.

2. What are the highlights of this integration?

Analytics Plus offers out-of-the-box analytics using data from the following modules:

  • Inventory
  • Alarms
  • Alarms history
  • Business views
  • Business views history
  • Performance details
  • Availability 
  • Interface performance*
  • Granular CPU utilization*

* Granular CPU utilization module and Interface performance metrics are not enabled by default. Please follow these steps to enable them. 

Setup

1. How do I integrate Analytics Plus with OpManager?

2. How long should I wait for my OpManager data to initially appear in Analytics Plus?

After setting up the integration, you might have to wait some time for the initial fetch to happen. Depending on the amount of data in your application, the reports and dashboards might take up to 5 minutes to display all the metrics. If you access the workspace before the initial fetch, it will not display any data. 

3. Can I edit the synchronization settings?

To edit the connection and synchronization settings, select Data Sources -> OpManager from the side panel. 

The synchronization summary is displayed with the following data:

  • OpManager URL: The OpManager web-client URL.

  • Last data sync status: Status of the most recent synchronization from OpManager.

  • Last data sync time: Time at which the most recent synchronization was completed.

  • Schedule: The frequency of data synchronization between Analytics Plus and OpManager.

  • Next Schedule time: Time at which the next data synchronization is scheduled to happen

  • Manual Sync done: Number of times the data has been manually synchronized in a particular day.

To edit the setup, click the Edit Setup link, modify the settings as needed, and click Save.

4. Can I synchronize my OpManager data instantly?

Yes. To do this, select Data Sources -> OpManager from the side panel. In the Data Sources page that appears, click Sync Now

5. How do I create custom reports over my OpManager data?

You can easily create custom reports in the form of charts, pivot tables, summary and tabular views in Analytics Plus. Click the corresponding links to learn more about creating reports. These reports can also be organized together to form intuitive dashboards. Refer this documentation to learn more about creating dashboards.

6. Can I set up the OpManager integration in existing workspaces in Analytics Plus?

Yes. Follow the steps below to do this.

  • Open the required workspace, click the Create button from the side panel, and select the New Table / Import Data option.

  • Select the OpManager tile in the Import Your Data screen that appears, and follow the setup procedure.

7. Is it possible to create multiple OpManager integration setups in Analytics Plus?

Yes. Follow the steps below to do this. 

  • Open the required workspace, click the Create button from the side panel, and select the New Table / Import Data option.

  • Select the OpManager tile in the Import Your Data screen that appears, and enter the details of the required OpManager account according to the usual setup procedure.

8. How do I remove this setup?

  • Open the corresponding workspace, and click the Data Sources option from the side panel.

  • Click the Settings icon that appears on mouse over the data source's name, and select Remove Data Source.

Data synchronization

1. What is the synchronization behavior of the tables imported from OpManager?

The following table lists the data synchronization behavior of the various modules and tables imported from OpManager.

TablesSynchronization behavior
OPM Alarm HistoryThe entire data is fetched during each synchronization. The Active Alerts metric present in this table will be updated every time the severity changes. 
OPM AlarmsDuring the initial synchronization, data from the specified period will be imported. Subsequent synchronizations will fetch data from the time of the previous successful synchronization.  
Business Views and Inventory modulesData from OpManager is fetched during every synchronization cycle.
OPM Performance DetailsDuring the initial synchronization, performance metrics from the specified period will be imported in batches of 90 days (data collected for a 90-day period). Once all historical data is synchronized, subsequent synchronization cycles will fetch data from the last 2 hours.
Device Groups tablesThe entire Device Group data is fetched during each synchronization.
Availability History of DevicesDuring the initial synchronization, data from the specified period will be imported. Subsequent synchronizations will fetch data from the time of the previous successful synchronization.  
Today's Availability of Devices

The current day's data will be fetched from OpManager during every synchronization.

CPU Utilization of DevicesDuring the initial synchronization, data from the specified period will be imported. Subsequent synchronizations will fetch data from the time of the previous successful synchronization.  
InterfacesThe current day's data will be fetched from OpManager during every synchronization.
Interface Performance MetricsDuring the initial synchronization, data from the specified period will be imported. Subsequent synchronizations will fetch data from the time of the previous successful synchronization.  

2. What should I do when the data synchronization fails?

The synchronization of your OpManager data can sometimes fail, due to a variety of reasons. To resolve this, click the Data Sources option from the side panel and click the Re-Authenticate link. In the popup that appears, click Authorize OpManager. Verify the OpManager URL, enter the regenerated API key, and click the Authorize OpManager button. 

3. How do I enable analytics on Interface Performance metrics and granular CPU utilization?

To access data on Interface performance metrics and granular CPU Utilization, please make the following modifications to your files. 

  • Step 1: Login to your Analytics Plus server and navigate to the directory where Analytics Plus is installed. Head to the app.properties file found under the AnalyticsPlus/conf folder, open the file in a notepad, include the following line towards the end of the file and save. 

    • conn.opm.skip.module=false

  • Step 2: Connect to your OpManager database, and execute the following query. (To learn more about connecting to the OpManager database, click here.)

    • UPDATE SystemSettings SET PropVal = 'true' WHERE PropName = 'DataRetentionFile';

  • Step 3: Restart both the Analytics Plus and OpManager applications. 

Note: To access data from these modules, please ensure you are on OpManager build 125215 and Analytics Plus build 4590. If you need further assistance, please drop us an email at analyticsplus-support@manageengine.com. 

Reporting Features

1. What are the report types supported by Analytics Plus?

Analytics Plus supports a wide variety of reports, in the form of charts, pivot tables, summary views and tabular views. To know more about the various types of reports, click here. To know more about dashboards and KPI widgets, click here.

2. Can I modify the pre-built reports created on integrating with OpManager?

Yes. If you are the Server Administrator or a workspace administrator of the workspace in which the integration is set up, click the Edit Design button in a report's toolbar and make the required changes. If you are a user to whom a report is shared, save a copy of the report by clicking Save > Save As, and modify the copied version as needed.

3. How do I create reports using fields/columns across different OpManager modules?

Columns from different OpManager modules are joined by default. Therefore, reports can be created over this data by simply dragging and dropping the respective columns in the report builder. Click here to learn more about creating reports. 

4. What are formulas in reports?

Formulas are calculations that can be defined using the powerful formula engine in Analytics Plus, to create required reports. Refer this documentation to know more. There are also several default formulas created based on the OpManager modules. To view the default formulas, open the required table, click Add and select the Edit Formulas option.

5. Is it possible to create custom formulas in Analytics Plus?

Yes. Refer this documentation to learn more.

6. Can I modify the tables imported from OpManager?

The data from OpManager is synchronized with Analytics Plus automatically, and stored in the form of various tables. Therefore, it is not possible to add data or modify the existing data present in these tables.

7. Can I add new columns to the tables imported from OpManager?

No. However, you can add Formula Columns and Aggregate Formulas to these tables, to help create custom reports. Refer this documentation to know more.

8. Can I import new tables into the OpManager workspace?

To do this, open the OpManager workspace, click Create from the side panel and select the New Table / Import Data option. You can integrate with other applications, or choose to import data stored in local files, web URLs, local databases, cloud databases and cloud drives. Click the corresponding links to know more.

9. Can I combine data from other sources with the data from OpManager, and create reports and dashboards?

Yes. To do this, import or add a new table to the OpManager workspace and define a lookup relationship between the added data and the existing data in the workspace. To define a lookup relationship between two tables, it is essential that the tables have at least one column in common between them. Follow the below steps to establish a lookup relationship.

  • Open the corresponding table, right click the column header and select the Change to Lookup Column option.

  • In the dialog that opens, select the column from the second table to look up.

  • Click OK.

Click here to learn more about lookup columns. 

10. What are Query Tables?

Using query tables, Analytics Plus allows you to import the required data required by writing standard SQL queries. This feature also allows you to combine data from different tables, and create reports from the combined data. Refer this documentation to know more.

Sharing & Collaboration

1. How do I share reports, dashboards, and tables in Analytics Plus?

You can share the out-of-the-box reports, dashboards and tables, and the ones you create, with other users easily. Refer this documentation to know more.

2. Why are my colleagues unable to access the reports I create?

The OpManager workspace can be accessed only by the administrator who set up the integration. To allow other users to access the out-of-the-box reports and dashboards, you can share the reports and dashboards as needed. Refer this documentation to know more. You can also share the entire workspace with a user. Refer this documentation to know more. 

3. Can other users create reports using the tables in the OpManager workspace?

Yes. To do this, share the required table with the users with the required permissions and filters. Refer this documentation to know more.

4. Is it possible to share the same report to multiple users such that they each see different data? 

Yes, you can do this by creating Variables. This allows you to share the report to several users, with associated filter criteria so that each user can access only the data specific to them. To learn more, refer this documentation.

5. Can I export a report or a dashboard?

Yes, you can export the report or dashboard in various formats such as CSV, EXCEL, PDF, HTML and image. To learn more, refer this documentation

6. How do I print the reports and dashboards created in Analytics Plus?

To do this, export the report or dashboard in the required format and print the exported file. To learn more about exporting a view in Analytics Plus, refer this documentation

Note: To export a shared report or dashboard, the Export permission has to be enabled. Refer this documentation to learn more about permissions.

7. Can I email reports and dashboards at scheduled times?

Yes, you can easily set up email schedules. Refer this documentation to learn more.

8. Can I embed reports? 

Yes. You can easily embed reports and dashboards into websites, applications or blogs. Refer this documentation to know more.

Help & Support

1. How do I get technical support on Analytics Plus?

Technical support is free for all users, even during the trial period. You can contact technical support through:

You can also get answers straight from our community

2. Can I have get a personalized demo of this integration?

Yes, please register for a demo using the form on this page.

Share this post : FacebookTwitter