Analytics Extension components and roles
TANDBERG Analytics Extension Admin guide
7
Analytics Extension components and roles
To plan a deployment of the Analytics Extension, it is important to understand the components and
roles used in the solution so you can deploy the solution in the best possible way for your
environment. The following table and illustration explain the various elements involved with the
TANDBERG Analytics Extension and how they relate to each other.
TMS Web Server
– The Windows installation that hosts the TMS web application.
The TMS Web Server also requires a TMS SQL Server, which may or may not be
the same Windows Server.
TMS SQL Server
– The Microsoft SQL Server hosting the TMS Database. In smaller
installations, this server is typically hosted on the same physical server that the TMS
Web Server is hosted on. In advanced installations, these tasks are usually different
physical Windows Servers.
tmsng
TMS Database
– The main database used by TMS itself. This database is hosted by
the TMS SQL server role and the default name of the database is tmsng.
TMS SQL Login
– The SQL Login used by the TMS Web Server to access the
tmsng database. By default, this is the sa account of the TMS SQL server, but can
be customized during TMS installation.
Data Warehouse Server
– The Microsoft SQL Server that will be hosting the
Analytics Databases and SQL Server Analysis Services. This server can be the
same SQL server as the TMS SQL Server, but is recommended to be a separate
SQL server. This Server installation must be operational before attempting to install
the Analytics Extension.
tmsng_dwh
Data Warehouse Database
– A new database created by the Analytics Extension
which serves as the long-term data repository for the Analytics Extension. This
database is hosted by the Data Warehouse Server
CUBE
Data Warehouse CUBE
– A new specialized multi-dimensional database created by
the Analytics Extension which contains the pre-computed data created by the
Analytics Extension. This database is hosted by the SQL Server Analysis Services
Instance running on the Data Warehouse Server.
DWH Service User
– A Windows domain user account used by the Analytics
Extension to log into the data warehouse Server for ongoing operations. This
account will be given the necessary permissions by the Analytics Extension installer.
DWH TMS Service User
– A SQL Login for the TMS SQL server used by the
Analytics Extension to read data from the TMS Database. This account is a SQL
Login, not a Windows Account and must have at least the
db_datareader
role.
See Appendix 2: Creating User Accounts in Windows Server and Microsoft SQL
Server in the
Analytics Extension installation guide
for information on how to set up
such an account.
