Micro Focus Expert
Micro Focus Expert
485 views

Syncronize Mobile Center metering information to Excel via ODBC

Mobile Center provides metering information via specific tables in its database, as well as there is an option to export it into CSV files.

There is a way to use MS Excel to export and refresh the data. To get Mobile Center metering data into MS Excel, please follow the steps below:

1. On MC DB machine: Allow remote connection to Postresql DB: how to allow remote connections to Postresq

2. On your client machine: 

  1. Install Postresql ODBC drivers: https://www.postgresql.org/ftp/odbc/versions/msi/ (scroll down to the bottom of the page for latest drivers and install 32 or 64 bits drivers).
  2. Configure ODBC data source: Control Panel -> Administrative Tools -> Setup ODBC data sources (32-bit).
    1. Select User DSN
    2. Click on Add button and select PostgreSQL driver
    3. Fill the properties as belowScreen Shot 2018-10-07 at 16.44.08.png

       

    4. Press on Test button to verify that connection is successfull. 

       

  3. Open MS Excel and navigate to Data tab.
  4. Navigate to New Query->From Other Sources->From ODBC
  5. Select Data Source Name (MC in the ODBC screen). If all is well, DB Navigator will open.
  6. Open hp4m scema and export the relevant table:
    1. audit_device: information about devices usage
    2. audit_job: actual usage of the devices and reservations
    3. audit_reservations: reservations created in the system
    4. audit_application: information about application usage
  7. The information from the DB table will be exported to the worksheet.
  8. To refresh the data, click on Refresh button

Now you can create a custom reports from the data, pivot tables and graphs. The data can be refreshed, so you can keep this excel file as the template and refresh the data when needed.

Enjoy,

Evgeny.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.