DWH Deck 2.0: Step 1 Create solution database and other connections
The DWH Deck is a simple tool that allows you to build and maintain your data warehouse better and faster.
In this blog post I’ll describe the steps necessary to create the solution database and other connections that will be used as source or target connection.
In this sample we will use the Northwind database as the source connection.
And an empty database NorthwindDW1 which we will use as the solution- and target database.
In the DWH Deck first create the solution:
- Enter DW1 in the Name Textbox
- Enter Server[\Instance] in the Server Textbox
(Do not use “localhost” or “ .” for your server name) - Choose NorthwindDW1 in the Database Listbox.
- Click the Create solution button
The DW1 connection is added to the tree view, beneath Connections.
In the Message text box feedback is provided about the actions performed by the DWHDeck.
Next check in SQL Server Management Studio that the tables and stored procedures are added to the database.
- In Object Explorer open the NorthwindDW1 database.
- Open Tables, Programmability and Stored Procedures and check the tables and stored procedures that are added to the solution database.
Next we will create the source connection to the Northwind database:
- Click Connection in the menu bar.
- Enter Northwind in the Name Textbox
- Enter Server[\Instance] in the Server Textbox
- Choose Northwind in the Database Listbox.
- Click Save in the menu bar.
After we have created the connections we can start creating the jobs.
This will be the subject of my next blog post.