< Previous | Next >

Lesson 2: Preparing a data warehouse application for deployment

In this lesson, you create a deployment package that contains the control flows that you designed in the previous lesson. Deployment preparation is a task that you do in Design Studio and is a prerequisite to deploying an application in the Administration Console, which you will learn to do in the next module.

Overview

You need to create a data warehouse application that contains the necessary information to deploy the load_branch_data and populate_time_and_order_fact control flows on your test system. You will package these two control flows into a .zip file.

When you use the deployment preparation wizard, you select the control flows to include in the data warehouse application. You also need to define the resources and variables that the control flows will use. These attributes represent the application profile.

Procedure

To package the control flows that you created into a data warehouse application for deployment:

  1. Open the Data Warehousing Application Deployment Preparation wizard:
    • Right-click the SQW_Tutorial project folder in the Data Project Explorer and select New > Data Warehousing Application.
  2. Complete the Data Warehousing Application Deployment Preparation wizard as described in the following table.
    Page Action
    Project Selection
    1. Select SQW_Tutorial.
    2. On the Application Profiles page, type the profile name: 
      Data_warehouse_application
    3. Type a description: 
      Populate Sales Mart
    Control Flow Selection Move the populate_time_and_order_fact and load_branch_data control flows from the Available Control Flows list to the Selected Control Flows list.
    Resource Profile Management No action is required.
    Tip: You can use this page to alter some of the settings that you specified when you created your flow to account for differences between your development and test systems.
    Variable Management No action is required.
    Tip: From this page, you can specify values for the DAYS_TO_SUBTRACT variable. For example, you can specify a value to load only what is new today and yesterday (instead of reloading all your time data every time you run the flow). For this tutorial, do not specify a value at this time.
    Miscellaneous File Selection No action is required.
    Important: You must complete all the pages of the wizard prior to clicking Finish.
    Saving Application Profile After clicking Next, you see a progress information dialog before the Code Generation page loads.
    Code Generation After clicking Next, you see the generated-code folder, which shows a list of generated files that you can browse.
    Package Generation

    Specify the location for your deployment .zip file. Specify a local directory where you want to save the deployment .zip file, such as C:\temp on Windows platforms or /tmp on Linux platforms.

    Remember: Write down the target location and .zip file name because you will need that information in the next module when you are deploying the application.
  3. Click Finish to generate the package and complete the wizard. Verify that the deployment .zip file was created by checking the directory that you specified.
You created your first data warehouse application. You are ready to deploy your application on a test or production system.

What's next?

In the next module, you will learn how to deploy and run this application in the Administration Console.
< Previous | Next >


Feedback | Information roadmap