High-level flow
Setting up data warehouse project typically consists of the following stages (simplified):
- In Qlik Replicate, define a task that replicates the source tables to a landing zone in the data warehouse.
- In Compose:
- Configure access to your data warehouse.
- Configure access to your data sources.
- Use the "Discover" option to auto-generate a model from the source tables or import an existing model that was created in ERwin. You can even create the model manually if you prefer.
- Once your model is ready, create the data warehouse tables and populate them with the source data.
- Create a data mart from the data warehouse tables.
- Populate the data mart tables.
See also Introduction.