Setup ODBC Connection to NuLook

Objective

These instructions describe how to setup an ODBC connection to connect to the Enterprise Data Warehouse, previously known as Nulook for reporting from applications such as Excel and Access.

Before You Begin

Prior to setting up your connection you will need to request access to the server. Once your access has been approved and granted you will need to work with your local IT support team to configure your workstation for access to High Risk data. This will add you to the Level 4 network which is a prerequisite to setting up your ODBC connection.

Secondly, verify you have the latest ODBC Driver for SQL Server. As of this revision, the latest version is 18. The driver can be download from Microsoft here:
https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

Steps

List the steps and include screen shots when necessary:

1. To start you need to open the ODBC Administrator. There are several ways to do this including using the start menu and control panel.
2. To use the Start Menu press the Windows key on your keyboard if present or click the Start Menu button and start typing “ODBC Data Sources”. Almost immediately results should start coming up. You will want to select “ODBC Data Sources (64 bit)

3. Alternatively, To open Windows Tools using the Run dialog:
   1. Press Win + R to open the Run box.
   2. Next, type control admintools and click OK. This will open the Windows Tools folder on your PC.

4. Once you have the ODBC Data Source Administrator open, make sure you are on the first tab which is the User DSN tab. If a nulook data source is present and the driver column is "ODBC Driver 18 for SQL Server", select the nulook data source, click on Configure, and skip to step 6. Otherwise, remove the existing nulook data source if it exist

5. Add new data source by clicking on "Add...". Select "ODBC Driver 18 for SQL Server" and click Finish.

6. Now enter the name and server. The name should be “nulook” and the server “warehouse.nebraska.edu”. Click Next

7. If you are logged in from UNMC, select the third option "WIth SQL Server authentication using a login ID and password enterd by the user".  Then enter your nulook Login and password below. If you any other campus, make sure “With Integrated Windows authentication” is selected. Click Next.

8. On the next screen check “Change the default database to” and make sure nulook is selected in the drop down. Change "Application Intent:" to READONLY. Lastly, check "Multi-subnet failover." Click Next.

9. On the next screen you can leave all the defaults. Click Finish.

10. The last step is to click on “Test Data Source…” to verify everything is working correctly.

11. If the test was successful you should see a result of "TESTS COMPLETED SUCCESSFULLY!"