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

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.

image

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

image

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.

image

 

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.

image

 

After we have created the connections we can start creating the jobs.
This will be the subject of my next blog post.

Overview of the DWH Deck 2.0

» Similar Posts

  1. DWH Deck 2.0: Step 2 Add Jobs by selecting source objects and applying a template
  2. DWH Deck 2.0: Step 3 Publish the jobs to create the SQL Statements and BIML Files
  3. DWH Deck 2.0: Step 4 Create SSIS packages from the created BIML Files

» Trackbacks & Pingbacks

    No trackbacks yet.

» Comments

    There are no comments.

Comments are closed