Section IX. Configure Database Environment

In order to run the database examples, you need to do some set up. There are three tasks.

1. Create two data source names (DSN)

2. Install a copy of the 2016 version of the AdventureWorks database

3. Create the EDW database

4. Create the ODS database

Create DSN

1. Create a System DSN using the “ODBC Driver 13 For SQL Server” driver.

2. Name it ETL. Point the DSN to the ODS database.

3. Create another system DSN.

4. Name it AdventureWorks. Point the DSN to the AdventureWorks database.

If you do not know how to do this, follow one of the links below for your system.

Create A DSN On Windows

Create A DSN On Mac

Create Databases

In the next section, you will download the source code for the tutorial. In the source code folder, go to the following directory.

tutorial-python\SQL\01 Preflght\00 SQL\Section VIII

In that folder will be a file that creates the necessary databases. Run that file.

Once you've done that, download and install a copy of the 2016 version of the AdventureWorks database. Instructions on how to download and install the database files can be found here.