This document covers the overall requirements needed to begin using TX DWA on your system.
Complete the following steps to properly configure your system. Click the links to jump to each section.
- Select Desired Server Configuration
- Review and Select Recommended Hardware
- Ensure System Meets Minimum Software Requirements
- Create Necessary Users
- Define a Security Group
- Configure System Security Permissions
- Download and Install TX DWA
The architecture behind Discovery Hub™ powered by TX DWA is shown below. This diagram represents the database configuration on your server once TX DWA has been installed and configured.
TX DWA can be set-up in multiple configurations which are detailed below.
Dedicated BI Server (Recommended)
In this set-up Applications and Databases are placed on the same server and will handle the full ETL (Extract-Transform-Load) process internally on a single machine.
Separate Application and Database Servers
In this configuration the BI Application server will handle the full ETL process but will use external data storage on the BI Database server. It is important to consider the additional network traffic produced by this configuration.
2. Recommended Hardware
There are no minimum hardware requirements for TX DWA beyond that which is required by MS SQL Server. If you have an existing BI server, this a great place to start.
3. Minimum Software Requirements
Please consult the TX DWA Prerequisites article for the minimum software requirements for TX DWA.
Steps 4-6 list the recommended user and security configuration
Create the following Active Directory user profiles (Use existing user profiles for existing users).
- One user for each TX DWA developer.
- One "TXService" User account used for the TX DWA Server and Scheduler Services. This is necessary to enable multiple environment migration and scheduled execution.
5. Security Group
Create an Active Directory(AD) Security Group called TXDevelopers and add the above users
Provide the following permissions to the Security Group created Above
BI Application Server
Windows OS level
System Administrator on the PC/System Application Server
BI Database Server
SQL Server Database
sysAdmin security role membership on the Database Server.
BI Database Engine/Server/Security/Logins/New Login/[TXDevelopers]/Properties/ServerRoles
dbOwner security role membership on all TX Created Databases. This includes the Project Repository, all staging databases, and all data warehouse databases.
BI Database Engine/Server/Databases/Source Database/Security/Roles/[TXDevelopers]/Properties/ServerRoles
SQL Server Integration Services (if using SSIS for Data Transfer)
db_ssisadmin security role membership on msdb system database on the Database Server.
Destination Database Engine/Server/System Databases/msdb/Security/Users/[TXDevelopers]/Properties/Membership
SQL Server Analysis Services (if using Analysis services OLAP Cubes)
Server Administrator on the Analysis Services Server on the Database Server
Analysis Server/Properties/Security/Server Administrators/Add../[TXDevelopers]
Source Database Server
SQL Server Database
db_datareader security role membership on all Source Databases (e.g. Online Transactional Processing Databases).
Source Database Engine/Server/Databases/Source Database/Security/Roles/[TXDevelopers]/Properties/ServerRoles
7. Download and Install TX DWA
Install TX DWA on the Application Server if you have not already. Download the software in the version that matches your SQL Server bit version. Consult the How to Install TX DWA or Upgrade to a Newer Version article for installation instructions.