About IU departmental Data Warehouse accounts

• Overview
• Sponsorship
• Usernames
• Request a departmental account
• Data Warehouse hours of accessibility

---

Overview

Indiana University departments can use departmental Data Warehouse accounts to connect to the Data Warehouse to perform automated extracts of data. This data may then be fed into a departmental application or presented in a reporting tool, such as Tableau. Using a departmental account rather than an individual account to access the Data Warehouse avoids loss of access to data should staff members change jobs or leave the university.

Sponsorship

Every departmental Data Warehouse account must have a sponsor who is an IU employee and who has completed the Acceptable Use Agreement. Only an account sponsor can request a password change for the departmental account. If an account sponsor changes jobs or leaves IU, the sponsor should identify a new sponsor and request that the account sponsorship information be updated. When account sponsorship changes, UITS recommends the account password be changed.

Usernames

Usernames for departmental Data Warehouse accounts are six to eight characters long, and are usually made up of an abbreviation for the department's campus and department followed by a two- or three-digit number (for example, BLVPFA01 for the Bloomington Vice Provost for Faculty Affairs). Alternatively, if a departmental application is known by an acronym, the username may be that acronym followed by a two- or three-digit number (for example, for an application known as ARMS, the username might be ARMS001).

Request a departmental account

To request a departmental Data Warehouse account, fill out the EDSD Support Form :

1. Select IUIE Support Request.
2. Under "Type of Request", select Account Questions.
3. Under "Type of Account Request", choose Departmental Access Request.
4. In the "Account name" box, enter the desired username for your departmental account; in the "Sponsor" box, enter the IU username of the account's sponsor. (If you already have a departmental account, you may select No for "I Need a Departmental Account".)

   If your requested username is already taken, the Data Warehouse team will contact you.

5. Fill in any relevant comments and select Submit.

After your account has been processed, UITS Tier 2 Accounts and Student Information Systems (ASIS) will provide you with the password for your departmental account.

Send requests for access to data for the new account to the data manager for the relevant area of responsibility.

Data Warehouse hours of accessibility

Departmental Data Warehouse accounts are meant for direct data access only, not for IUIE application use. Accounts can only access the DSS1PRD database during online hours. A copy of DSS1PRD is available during the nightly batch schedule (10pm-5am) for special cases; separate authorization is required.