README.md

WideWorldImporters Sample Database for SQL Server and Azure SQL Database

WideWorldImporters is a sample for SQL Server and Azure SQL Database. It showcases database design, as well as how to best leverage SQL Server features in a database.

WideWorldImporters is a wholesale company. Transactions and real-time analytics are performed in the database WideWorldImporters. The database WideWorldImportersDW is an OLAP database, focused on analytics.

The sample includes the databases that can be explored, as well as sample applications and sample scripts that can be used to explore the use of individual SQL Server features in the sample database.

Latest release: wide-world-importers-release

Documentation: Wide World Importers Documentation

Feedback on the sample: send to sqlserversamples@microsoft.com

Contents

About this sample
Before you begin
Sample structure
Disclaimers
Related links

About this sample

  1. Applies to: SQL Server 2016 (or higher), Azure SQL Database
  2. Key features: Core database features
  3. Workload: OLTP, OLAP, IoT
  4. Programming Language: T-SQL, C#
  5. Authors: Greg Low, Denzil Ribeiro, Jos de Bruijn, Robert Cain
  6. Update history: 21 June 2017 - restructure using SSDT 25 May 2016 - initial revision

Before you begin

To run this sample, you need the following prerequisites.

Software prerequisites:

  1. SQL Server 2016 (or higher) or an Azure SQL Database.
  2. SQL Server Management Studio, preferably June 2016 release or later (version >= 13.0.15000.23).
  3. Visual Studio 2015 Update 3 (or higher) with SQL Server Data Tools.
  4. (to run ETL jobs) SQL Server 2016 (or higher) Integration Services (SSIS). At the time of writing, Visual Studio 2017 does not yet support Integration Services projects. You will need to install Visual Studio 2015 to open the SSIS project.
  5. (to install the SSASMD sample) SQL Server 2016 (or higher) Analysis Services (SSAS). If you are using Visual Studio 2017, download and install the following: Analysis Services

Sample structure

The latest release of this sample is available here: wide-world-importers-release

This sample contains databases as well as a number of sample scripts and workload drivers.

The sample databases are created through SQL Server Data Tools projects in Visual Studio. Each database has its own project; the solution wwi-sample.sln in the root folder of the sample has references to all the projects. To load all project in the solution, SQL Server Integration Services and SQL Server Analysis Services need to be installed on the machine.

The sample scripts are available as Transact-SQL. The workload drivers are sample applications created in Visual Studio.

The source code for the sample is further structured as follows:

power-bi-dashboards

Sample Power BI dashboards that leverage the WideWorldImporters and WideWorldImportersDW databases.

sample-scripts

Sample scripts that illustrate the use of various SQL Server features with the WideWorldImporters sample database.

workload-drivers

Simple apps that simulate workloads for the WideWorldImporters sample database.

wwi-dw-ssdt

SQL Server Data Tools project for the OLAP database WideWorldImporters.

wwi-ssasmd

SQL Server Analysis Services Multidimensional project to create the Analysis Services database WWI-SSASMD.

wwi-ssdt

SQL Server Data Tools project for the main OLTP database WideWorldImporters.

wwi-ssis

SQL Server Integration Services (SSIS) project for the Extract, Transform, and Load (ETL) process that takes data from the transactional database WideWorldImporters and loads it into the WideWorldImportersDW database.

Disclaimers

The code included in this sample is not intended to be used for production purposes.

Related Links

For more information, see these articles: