Connecting to the Data Warehouse (ODS)

Connecting to the Data Warehouse (ODS) on a Windows computer enables you to use Data Warehouse data in your desktop applications (Excel, MS Access, Power BI Desktop, etc.).

To connect to the ODS on a Windows computer, you’ll need to install a compatible version of Oracle InstantClient. The InstantClient is available in 32-bit and 64-bit versions. You'll need the 'bit' version that matches your applications. Most applications are 64-bit so if you're unsure, start there. You'll also need a configuration file, TNSNAMES.ora file. Your Helpdesk team can help with the software installation and getting the TNSNAMES.ora file from the Division of IT.

Once installed, you can create an ODBC connection to the ODS database. Instructions from Microsoft are available with the link below.

How to make an ODBC connection