Melco OS Statistical Reporting - Centralize Reporting

Centralize Reporting

 

This article is step by step guide to centralize Melco OS reporting into one or more groups/databases.

System requirements

• SQL Server 2012 or higher( SQL Express is supported )

• SQL Server should be accessible from all the computers with Melco OS Installed.

Use Case 1: Connecting All Machines to one Database

Steps

Please follow below configuration steps

• Attach Database: Copy “<MelcoOS install Folder>\Reports\IBS.mdf” and “<MelcoOS install Folder>\Reports\IBS.ldf” on to the central sql server computer. Follow these instructions to attach database. Default database name after attaching will be “Amaya” but it can be attached with any preferred name.
  
   

• Update Connection String: now update the connection string for Melco OS to connect the reporting to central database. Open “<MelcoOS install Folder>\Reports\DataAccess.config” with notepad or any text editing tool.
  
  Existing file will look like below

  1. <?xml version="1.0" encoding="utf-8"?> 
  2. <Settings>
  3. <ConnectionString value="LocalDB" /> 
  4. </Settings>

File after update will look like as below

1. <?xml version="1.0" encoding="utf-8"?>
2. <Settings>
3. <ConnectionString value="Server=[SQL Server];uid=[UserName];pwd=[Password];Initial Catalog=Amaya;Persist Security Info=True;" />
4. </Settings>

• Update Connection Strings for All Melco OS : now repeat previous step for all Melco OS installations.

• Restart: Restart Melco OS after updates to make sure configuration updates are loaded correctly.

Use Case 2: Connecting Machines into groups/multiple databases

Steps

Please follow below configuration steps

• Attach Database: Copy “<MelcoOS install Folder>\Reports\IBS.mdf” and “<MelcoOS install Folder>\Reports\IBS.ldf” on to the central sql server computer. Follow these instructions to attach database. Attach database as many time you want to create groups ( 2 Groups= 2 Databases). you can give the group name as database name for easy configuration or follow any pattern.
  
   

• Update Connection String: now update the connection string for Melco OS to connect the reporting to central database. Open “<MelcoOS install Folder>\Reports\DataAccess.config” with notepad or any text editing tool.

  Existing file will look like below

  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Settings>
  3. <ConnectionString value="LocalDB" />
  4. </Settings>

File after update will look like as below

1. <?xml version="1.0" encoding="utf-8"?>
2. <Settings>
3. <ConnectionString value="Server=[SQL Server];uid=[UserName];pwd=[Password];Initial Catalog=[GroupName];Persist Security Info=True;" /> 
4. </Settings>

• Update Connection Strings for Groups: now repeat previous step for all Melco OS installations but remember to update the groups/database names in connection strings correctly.

• Restart: Restart Melco OS after updates to make sure configuration updates are loaded correctly.

Display

• Any Melco OS grouped into centralized database can generate the reports.

• Reports are always generated for all the machine connected to one database.