Northwind setup record

Record the actual names you use. The suggested names identify separate database roles. Keep passwords in your password manager.

Entries stay in this tab only. Save a text copy before closing or refreshing it. You can continue editing the saved text file later.

· Blank text copy · Guide

1. SQL Server and tools

Open the related guide page

Server address and instance (localhost only for this computer)LAN hostname and actual TCP port, if usedSQL Server engine version and editionSign-in method and account name (no password)OLE DB driver version and application architectureSSMS version; SSIS runtime version and full DTExec.exe path

2. Northwind and database preparation

Open the related guide page

Source server and database (Northwind)Northwind copy: already prepared or loaded from the supplied sampleSource check date and result; sample revisionSettings name reserved: NorthwindTutorial; repository: repo_NorthwindTutorialDesign database reserved: dwh_NorthwindTutorialSeparate warehouse destination: NorthwindWarehouse; actual serverSQL Server database-file folder; creation and loading permissions

3. AnalyticsCreator and saved settings

Open the related guide page

AnalyticsCreator release and 32-bit / 64-bit choiceActual saved warehouse name and repository databaseActual design database and server

4. Northwind model

Open the related guide page

Northwind connector name and successful connection testSelected source tables and packagesActual warehouse schema/table/column names for Customers, Products, Orders and Order DetailsAnalytical table names, keys and relationshipsSales calculation and rounding rule

5. Generated files

Open the related guide page

Deployment name; SQL/SSIS generation targetDestination server/database checked against NorthwindWarehouseOutput folder and configuration folderConfiguration connection checked; package source and destination checkedFull main package path; configuration path; generated file hashesGenerated .pbip file and associated .Report / .SemanticModel folders

6. Load and result checks

Open the related guide page

Validation command, date, exit code and log pathFirst load: date, exit code and log path; attempt markerSource and destination row counts: Customers / Products / Orders / Order DetailsKey, relationship and column comparison resultsGenerated sales fact: complete line key, row count, units and net sales checkQuantity and line-rounded sales total; first differing record if anyRetry, if needed: preserved logs; new target and output paths

7. Optional Power BI report

Open the related guide page

Desktop version and generated .pbip locationWarehouse connection and refresh resultSales measure and report total compared with the warehouse