Required Software

Software Needed:

In order to have access to the Data Warehouse your computer needs:

• Oracle Client Software

• Ohio University Data Warehouse Utility (OUDW Utility)

• Software Query Tool such as Microsoft Access, Crystal Reports, or Brio Query
  

Note:  The OUDW Utility will update the tnsnames.ora Oracle client file and create the ODBC data source used by most query software.  For Microsoft Access, there is an option to create an Access database and automatically setup links to the tables you have access to in the data warehouse. Review the Microsoft Access Guide for help with using Microsoft Access to query the data warehouse. If you are using any other software, refer to the appropriate manual.

To connect to the Data Warehouse in Crystal Reports: 

Choose the Database Tab, then Logon Server, then ODBC, then choose the ORDJ Data Source, then NEXT, enter userid and password. 

To connect to the Data Warehouse in Brio Query: 

Choose the DataModel Tab, then connections, then create, choose ODBC for connection software, Oracle 8 for database software, then enter your username, password and choose ORDJ as the datasource.

Microsoft Access (included on the Office Suite CD) is covered under Ohio University's Microsoft Agreement. For more information on obtaining Microsoft Access visit our software website.