BI Query (Data Warehouse) - Access

Issue/Question

  • I have lost access to Data Warehouse. How do I restore my access?
  • How do I get access to Data Warehouse?

Environment

  • Oregon State University
  • BI Query (Data Warehouse) (DW)

Explanation

Data Warehouse is a colloquial name at OSU for a legacy data query tool called BI Query. This tool is currently being phased out, but is still used for a limited set of data. In IT jargon a data warehouse usually refers to a set of data and the systems used to maintain it rather than the query tool used to access the data.

The most common ask around DW access is why someone has lost access. Reasons people lose access to BI Query (DW) include:

  • They have not logged into the system for a year, which causes them to be locked out.
  • Repeated resets of a person's password can also cause them to be locked out of the system.
  • Installing BI Query (DW) on a new computer can cause the person to be locked out of the system.

Resolution

Caution: Data Warehouse is a deprecated tool. We should consider if a new request can be met with Tableau or CORE reports and dashboards before considering granting access to Data Warehouse. Most data needs at OSU are met with CORE or Tableau.

Restoring BI Query (DW) Access

If the person has lost access to BI Query (DW) contact IAM at banner.access@oregonstate.edu IAM can walk the person through restoring their access to the data in BI Query (DW).

Note: If you have lost access but have used BI Query in the last year you may need to update your connection to the server due to OSU's migration to a cloud database systems. Instructions on how to update your connection can be found at: https://oregonstate.teamdynamix.com/TDClient/1935/Portal/KB/ArticleDet?ID=134408.

Requesting Access to BI Query (DW)

People can request access to BI Query and its associated data using the form at: https://beav.es/banneraccess.

Note: BI Query is a legacy tool that is currently being phased out. A limited set of people are currently using this tool for data needs that have not been addressed with new tools yet. CORE is the primary data access tool for university wide data (eg How many students are enrolled at OSU?). Tableau is the primary data access tool for unit specific needs (eg How does taking WR121 at a community college impact the performance of the students in my college?)

Data still supported in BI Query is:

  • HR Data
    • Only people in HR have access to this
  • Student Data
    • Some units on campus (primarily academic units) still have access to BI Query (DW) to pull student data that has not been set up in other data systems. Most units have been migrated off BI query for student data though. New student data needs are addressed in newer data tools like CORE and Tableau. Follow up with Decision Support if you have questions on where to access student data.

Assistance

For assistance contact the UIT Data Team

Print Article