Integrating ARA into Analytics

You can seamlessly integrate ARA into Analytics by taking a few simple steps.

The following steps are only necessary for updating/upgrading the system or for manual installationnull scenarios. None of these steps are required when using the ONE Installer.

To Integrate ARA into Analytics

Setup Reports for Analytics
1. Create a DB user (e.g. UsrAnalytics) in your DB system with read-only access to the Reporting DB (or Main DB) table sets. This will be used by Analytics to access ARA data.
2. Create the required reports in ARA with the command line tool admin-cli.exe.
  - If the same database for ARA-data and reports is used (main database) the following syntax must be used to create the required table set:
    
    admin-cli create report -fi Data4Analytics.xml -connection MainDatabase -con http://localhost/ARA -usr 100/AUTOMIC/AUTOMIC -pwd automic
  - Optionally, you can use the following syntax if you already have a dedicated database for reporting data (reporting database):
    
    admin-cli create report -fi Data4Analytics.xml -connection ReportDatabase -con http://localhost/ARA -usr 100/AUTOMIC/AUTOMIC -pwd automic
    
    Make sure the database connection in the Analytics backend configuration file also points to the reporting database.
  For more information see Import & Export Services in the ARA Integration Guide.
The Data4Analytics.xml file is located in the ara folder of the Backend sub-component (.../backend/ara).
Install ARA's sample dashboard
- As a starting point for dashboards a sample dashboard that focuses on ARA is distributed with ARA. This can be installed by importing the provided XML file into the proper AE client. To do so, go to the Process Assembly perspective, right-click the Home page and select the Import/Export option from the context menu.
Setup the Analytics connection
1. Setup the connection to the correct ARA DB and configure the table sets for each client.
2. Specify the created DB user for Analytics.