Step 1: Create Global Database for Business Unit

1. In the Tools menu select Environment Properties
2. Click New Global Database
3. Type in [Business Unit] in the Name box
4. Select Staging Database in the Type drop-down list and click OK
5. Click the settings text box
6. Type [localhost] in the Server text box
7. Type [TX_BU_DEV] in the Database text box
8. Right-click the settings text box, select Create Database
9. Right-click the settings text box, click Test Connection
10. Click OK

Direct Read for Improved Performance

For the DSA and MDW it's important to enable Direct Read to ensure data is transferred directly within the SQL database engine using "SELECT" queries whenever possible. This bypasses intermediate layers like SSIS or ADO.net and improves performance—especially when TimeXtender isn’t collocated with SQL Server. Two options are available:

• Matching Server: On-Prem SQL Server supports "cross-database queries" so your Business Unit, DSA, and MDW can be in the same server, but different databases.
  • If the BU, DSA, or MDW Server do not match, data is routed through the application using ADO.net
• Matching Server and Database: Since Azure SQL Database does not support cross-database queries, it's highly recommended your Business Unit, DSA, and MDW are co-located on the same database.
  • If the BU, DSA, or MDW Server and Database do not match, data is routed through the application using ADO.net.

Step 2: Create Global Database for DSA

1. In the Tools menu select Environment Properties
2. Click New Global Database
3. Type in DSA in the Name box
4. Select Data Warehouse in the Type drop-down list and click OK
5. Click the settings text box
6. Type localhost in the Server text box
7. Type TX_DSA_DEV in the Catalog text box
8. In the Direct read option, select Matching Server.
9. Right click the settings text box, select Create Database
10. Right click the settings text box, select Test Connection
11. Click OK

Step 3: Create Global Database for MDW

1. Click New Global Database
2. Type in MDW in the Name box
3. Select Data Warehouse in the Type drop-down list and click OK
4. Click the settings text box
5. Type localhost in the Server text box
6. Type TX_MDW_DEV in the Catalog text box
7. In the Direct read option, select Matching Server.
8. Right click the settings text box, select Create Database
9. Right click the settings text box, select Test Conection
10. Click OK