Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
    • Getting started
    • Introduction video
      Welcome to Accure Project Management System
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?
      Create a new account

Side Menu

  • Overview
  • Documents
  • Impulse DW
    Impulse DW
  • Inset BI
    Inset BI
  • Momentum User Guide
    Momentum User Guide
  • Wiki
    Wiki

Content

You are here:
  1. Impulse DW
  2. 2. Warehouse Management
  3. 2.1 Create a Warehouse

2.1 Create a Warehouse

  • More
    • Print
    • Table of contents

Data warehouse (or DW for short) is a collection of logically related tables or data sources. You create a DW to organize tables within it. 

To create a new data warehouse:

  1. On the main navigation menu, click "Data Warehouses". 
  2. Click on the + icon located at the top left corner of the page (see Figure 2.1.a below)
  3. Fill out the form:
    1. Warehouse Name: This is a user defined name to recognize this warehouse
    2. Warehouse Alias: This is short name or code given by user to this warehouse. Ensure there is no space or special characters in the warehouse alias. All tables are referenced using the warehouse alias. For example, if the alias is "patientdw" and there are two tables -- patient and schedule -- within this warehouse, the tables are uniquely identified using the alias as patientdw.patient, and patientdw.schedule.
    3. Description: User defined description or purpose of this warehouse.
  4. Submit to create the DW. 

Figure 2.1.a: Screen indicating the + icon to create a new data warehouse

Figure 2.1b: Screen showing the warehouse fields with sample data entry

Loading...