Exercise: Create Global Databases
Global databases ensure seamless multi-environment management of database connections. In the below exercises we will create connections for our Business Unit, DSA, and MDW layers. For more detailed information, please see Configure Global Databases.
Step 1: Create Global Database for Business Unit
- In the Tools menu select Environment Properties
- Click New Global Database
- Type in [Business Unit] in the Name box
- Select Staging Database in the Type drop-down list and click OK
- Click the settings text box
- Type [localhost] in the Server text box
- Type [TX_BU_DEV] in the Database text box
- Right-click the settings text box, select Create Database
- Right-click the settings text box, click Test Connection
- Click OK
Note: Video is free of audio
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
- In the Tools menu select Environment Properties
- Click New Global Database
- Type in DSA in the Name box
- Select Data Warehouse in the Type drop-down list and click OK
- Click the settings text box
- Type localhost in the Server text box
- Type TX_DSA_DEV in the Catalog text box
- In the Direct read option, select Matching Server.
- Right click the settings text box, select Create Database
- Right click the settings text box, select Test Connection
- Click OK
Note: Video is free of audio
Step 3: Create Global Database for MDW
- Click New Global Database
- Type in MDW in the Name box
- Select Data Warehouse in the Type drop-down list and click OK
- Click the settings text box
- Type localhost in the Server text box
- Type TX_MDW_DEV in the Catalog text box
- In the Direct read option, select Matching Server.
- Right click the settings text box, select Create Database
- Right click the settings text box, select Test Conection
- Click OK
Note: Video is free of audio
Have Questions?
- Search for key words in the Support Portal to find topics that may already have answers.
- Can't find the answer to your question? Post your question in the TimeXtender community forum!
- Write your question in the box and select the appropriate topic.