OpenLM Reporting Hub installation instructions - OpenLM Software License Management
Israel +972 4 6308447         USA +1 866 806 2068        JAPAN +81 3 45208991 担当:萩原

OpenLM Reporting Hub installation instructions

OpenLM Reporting Hub installation instructions

Java

  • Navigate to the “Java” folder, found in the “OpenLM Reporting Hub” folder.
  • Install “Java JDK 8.exe”
  • Activate “Set variables.bat”
    • NOTE: Manually set JAVA_HOME and KETTLE_HOME to system variables if operating under different users on the same machine.

Reporting database

  • Navigate to “Postgres” folder, found in the “OpenLM Reporting Hub” folder.
  • Install “Postgres Editor.msi”.
  • Install “Postgres Server.exe”.
  • Navigate to C:\…\PostgreSQL\9.5\data
  • Edit the file “pg_hba.conf” and add the following line to the file:
    • host    all             all             0.0.0.0/0            md5
  • Save the edited file and restart the PostgreSQL service.
    • NOTE: Do not install the “stack builder” addon.
    • NOTE: Select your postgres database password when prompted.

Power BI

  • Navigate to “Power BI” folder, found in the “OpenLM Reporting Hub” folder.
  • Install “Power BI Desktop.msi”.
  • Install “Power BI Connector.msi”.
    • NOTE: Install “Power BI Data Gateway.exe” in case of Power BI cloud subscription
    • NOTE: Install the GAC component when prompted in the “Power BI Connector” installation

Connection properties

  • Navigate to “.kettle” folder, found in the “OpenLM Reporting Hub” folder.
  • Edit file “kettle.properties”.
  • Input SMTP server details (server, port, username, password,  sender email and destination email)
  • Input source database details and save. (server, port, username, password,  database name)
  • Input destination Postgres database details and save (server, port, username, password,  database name)
  • Input the server hostname and MAC address in the designated fields.
  • place the “.kettle” folder in “C:\Program Files”
    • NOTE: Default Postgres database and username are “postgres”.
    • NOTE: Check that there are not empty spaces at the end of the value.
    • NOTE: Do not place “.kettle” in “Program Files (x86)”.

ETL Engine

  • Navigate to “ETL” folder, found in the “OpenLM Reporting Hub” folder.
  • Inside “Jobs” folder, go to  “License” folder and paste the Reporting Hub license you have received.
  • Activate “Run ETL.bat”.
    • NOTE: Wait for the ETL run to finish, might take a while.

ETL scheduling

  • Activate “Windows Task Scheduler” and choose the “Task Scheduler Library”.
  • Under “Actions”, click on “Create Task”.
  • Under the tab “General”, Name the task “OpenLM ETL”.
  • Check the checkbox “Run whether user is logged on or not”.
  • Check the checkbox “Run with highest privileges”.
  • Navigate to the tab “Triggers” and click on “New”.
  • Set the schedule to be once a day at 12:00 AM and click ok.
  • Navigate to the tab “Actions” and click on “New”.
  • Choose the action “Start a program”,
  • Select the file “Run ETL.bat”.
  • Click OK, and now the scheduled task of the ETL is set.

Sample Reports

  • Navigate to “Reports” folder, found in the “OpenLM Reporting Hub” folder.
  • Activate a report by double clicking it.
  • In the Power BI → “Edit Queries” → “Data Source Settings” → “Change source”
  • Input the correct postgres host and database name then press “OK”.
  • Click on “Edit Permissions” → “Edit”
  • Input the correct postgres username and password then press “OK”.
  • Refresh data or “Apply Changes”

 

Currently, the installation and configuration of the OpenLM Reporting Hub and reporting system requires the presence of an OpenLM support person.

Please contact our support team at support@openlm.com , and our representatives will be glad to assist and guide you online.

 

in

Related Articles