IN2BI

In  my presentation at the DWHAutomation conference in Amsterdam on 20.09.2012 I gave a demo of the new version of the DWH Deck: DWH Deck 2.0. Here are the slides of that presentation:

This new release is now available for interested parties.
(If you are interested send me an e-mail: marco@in2bi.nl)

The DWH Deck is a simple tool that allows you to build and maintain your data warehouse better and faster. The basic idea is best described by looking at the input and the output:

INPUT:

• Meta data that describes the the source object
• Templates that describe target table and load pattern
  (I have provided 9, but you can change these and add additional templates)

OUTPUT:

• SQL Statements to create target tables and additional objects,
• SQL Statements to create stored procedures to load the data
• BIML Files to create SSIS Packages that will handle the data load
   

In these blog posts you’ll find additional information:

• Support
• 1. Create solution database and other connections
• 2. Add Jobs by selecting source objects and applying a template
• 3. Publish the jobs to create the SQL Statements and BIML Files
• 4. Create SSIS packages from the created BIML Files
• How to change or add templates