IN2BI, Microsoft Business Intelligence
data, stories & insights
rss | email | twitter

DWH DECK Part 2: Creating your data warehouse

Adapted for version 1.1 on 18/04/2011

This is the second part of a series on the DWH DECK. A tool that will allow you to build and maintain your data warehouse better and faster. This series will act as documentation and will give you some insides into the way the program works.
Overview of this series

Before you can create your data warehouse you'll have to establish a connection to the server for your data warehouse: Menu Application - Connect.
In the dialog Connect to Server enter the server name and choice the authentication mode you'll use. If you use SQL Server Authentication enter the user name and password.

It's important that the authentication account that you will use has sufficient rights on the server and read rights to the source server(s) / database(s).

Now let's create the data warehouse: Menu Application - New Data Warehouse

Enter the name of your data warehouse and click create .. You can see the progress of the creation of databases and tables in the progress textbox.
 


As you can see four databases are created:

  • YourDataWareHouse, which holds the meta data for your solution.
  • YourDataWareHouse_st, the staging database
  • YourDataWarehouse_dv, the data vault database
  • YouDataWareHouse_dm, the data mart database 

» Similar Posts

  1. DWH DECK Part 3: Importing Source Information
  2. DWH DECK Part 4: The Model Window
  3. DWH DECK Part 6: Data Vault

» Trackbacks & Pingbacks

    No trackbacks yet.

» Comments

    There are no comments.

Comments are closed