How to Successfully Configure InfoAccess

This document serves as a reference document and table of contents to successfully configure InfoAccess on your Windows computer.

First Steps

There are two things you must determine before you begin:

  1. Determine if an Oracle client is already installed on your machine.

    • Open Command Prompt, type tnsping, then press Enter. If the response to this command is 'tnsping' is not recognized as an internal or external command, operable program or batch file., then you do not have an Oracle client installed. Any other response indicates an active Oracle client installation on the machine.

  2. Determine if you need a 32 or 64-bit version of the Oracle client.

    • The bit-version of the Oracle client should match the programs you wish to use to connect to InfoAccess. If you're unsure, you should install 64-bit as modern data querying applications typically require a 64-bit connection. If you're using Microsoft Office applications to query InfoAccess, you can check the version of your applications by following these linked instructions.

Once you have verified whether you have an Oracle client on your computer and what version you require, you may move on to the next steps.

Install and Test the Oracle Client

Important: the first two steps in this section require administrative rights on your computer. If you do not have administrative rights, you must partner with your IT staff to successfully complete the first two steps in this section.

Please reference the linked KnowledgeBase documents and follow these steps in order.

  1. Downloading and Installing Oracle Client

  2. Adding, Editing, or Replacing Your TNSnames.ora File

  3. Testing an Oracle Database Connection to InfoAccess

If the test in step 3 succeeds, you have successfully installed the Oracle client on your computer.

Configure the Oracle Client with an ODBC Connection

You may need to set up an ODBC connection if you wish to use InfoAccess with Microsoft Office applications. The bit-version of the connection will depend on which bit-version of the Oracle client you installed. Please follow the instructions at this KB article: Configure an ODBC connection to InfoAccess.

If the ODBC connection test succeeds, you have successfully configured the Oracle client to connect to InfoAccess.

Need More Information or Help?

If you have performed all of the steps in this document and still cannot connect to InfoAccess after you have contacted your IT staff, please contact the Office of Data Management and Analytics Services (ODMAS, https://data.wisc.edu/) at info@data.wisc.edu.



KeywordsConfigure InfoAccess Oracle 12c 11g install home tnsnames tns database data base warehouse dwh   Doc ID101010
OwnerMehrnaz A.GroupData KB
Created2020-04-22 10:26:57Updated2023-11-14 09:21:58
SitesData, Academic Planning & Institutional Research, DoIT Help Desk
Feedback  1   0