The DWH Wizard allows for the rapid creation of a semi-ready data warehouse. It is especially effective when the data source includes predefined table references or manually maintained source references.

Prerequisites

• At least one source connector must be defined before using the DWH Wizard.
• Note: The DWH Wizard does not support CSV connectors. For CSV sources, use the Source Wizard instead.

To launch the DWH Wizard, click the “DWH Wizard” button in the toolbar.

Instead, the user can use the connector context menu:

Using the DWH Wizard

Select the connector, optionally enter the schema or table filter, and click "Apply". Then, the source tables will be displayed.

Optionally, select the "Existing Sources" radio button to work with already defined sources instead of querying the external system (ideal for meta connectors).

If a table already exists, the "Exist" checkbox will be selected.

To add or remove tables:

• Select them and click the ➕ button to add.
• Select from below and click the ➖ button to remove.

DWH Wizard Architecture Options

The wizard can generate the DWH using:

• Classic or Mixed Architecture: Supports imports, historization, dimensions, and facts.
• Data Vault Architecture: Supports hubs, satellites, links, dimensions, and facts with automatic classification when “Auto” is selected.

Define name templates for DWH objects:

Set additional parameters:

DWH Wizard Properties

1. Field Name Appearance: Leave unchanged, or convert to UPPER/lowercase.
2. Retrieve Relations: Enable automatic relation detection from source metadata.
3. Create Calendar Dimension: Auto-create calendar dimension and define date range.
4. Include Tables in Facts: Include related tables in facts (N:1, indirect, etc.).
5. Use Calendar in Facts: Include date-to-calendar references in fact transformations.
6. SAP DeltaQ Transfer Mode: Choose between IDoc or tRFS.
7. SAP DeltaQ Automatic Synchronization: Enable automatic DeltaQ sync.
8. SAP Description Language: Select SAP object description language.
9. DataVault2: Do Not Create HUBs: Optionally suppress hub creation in DV2.
10. Historizing Type: Choose SSIS package or stored procedure for historization.
11. Use Friendly Names in Transformations as Column Names: Use display names from SAP/meta/manual connectors.
12. Default Transformations: Select default predefined transformations for dimensions.
13. Stars: Assign generated dimensions and facts to data mart stars.