Analytics Extension components and roles
TANDBERG Analytics Extension Admin guide
9
Data warehouse updates
Data mining and long term analysis of information is done using historical data. The focus is on
historical data, instead of real-time data. Because of this, the data warehouse contents are not
recorded in real-time as in the traditional reporting information viewed via TMS. Instead the DWH data
is refreshed daily by the Windows Service installed on the TMS web server by the Analytics Extension.
The Windows Service initiates two updates, the ETL Task and the CUBE refresh. The ETL (Extract,
Transform, Load) task extracts from the TMS database all new (recorded since the last time the ETL
task run) data updates values and computations stored in the data warehouse database. Because
only new information is processed, the ETL task is extremely efficient. This task is initiated by the
Analytics
Extension‟s Windows Service connecting to the data warehouse server at a scheduled time
using the supplied DWH service user credentials. The ETL job executes on the data warehouse server
and uses the defined linked server to read information from the TMS database. There is no significant
extra load placed the TMS web server. An administrator may also initiate the ETL job to run
immediately via the Analytics Extension web interface in TMS.
The CUBE refresh is performed daily after the data warehouse database has been updated by the
ETL task. To initiate this update, the Analytics Extension Windows Service on the TMS Web Server
connects to the Analytics Service on the data warehouse server using the DWH service user
credentials and tells the CUBE to refresh. The CUBE uses the connection properties defined in the
CUBE‟s Data Source definition to connect to the data warehouse database.
Service account permissions and uses
Data warehouse service user
The data warehouse service user account is used by Analytics Extension to log into the data
warehouse database and data warehouse CUBE. This user account must be a valid Windows Domain
account. It does not need any pre-existing permissions. It is also used by the data warehouse CUBE
to connect to the data warehouse database in the Database Engine instance.
If the account password changes the installation must be reconfigured. See the
Analytics Extension
Reconfiguration
section for more information.
DWH TMS service user
The TMS service user account is used by the data warehouse server to pull data from the TMS
database. This account must have an SQL Login capable of connecting to the TMS database
tmsng
.
It only needs SQL login access to the TMS and the
db_datareader
role on the TMS database.
If the account password changes, the installation must be reconfigured. See the
Analytics Extension
Reconfiguration
section for more information.
