MDT Frequently Asked Questions

  • Where is the MDT environment?
    • The MDT environment is located on the Unix server known as IRPROD and referenced by irprod.admin.uillinois.edu.
  • How is the MDT environment organized?
    • The root directory of the MDT region is /mdt. Beneath the root directory, MDT environment is organized by legacy application. For example, data that was salvaged from the UFAS General Ledger application in the mainframe environment is stored in the /mdt/gl_history directory.
  • How do I know what data is available in the MDT environment?
    • The MDT Application Inventory lists the legacy applications that MDT has already completed and indicates whether or not data was salvaged.
  • How is data stored in the MDT environment?
    • The format of the legacy data determines the data storage format in the MDT environment. Data from VSAM, sequential, and flat files on the database are stored in zipped text files in the MDT environment. Data that exists in database format in the legacy application is converted to reside in an Oracle database in the MDT environment. All data in the MDT environment will be "read only".
  • How do I get access to data in the MDT environment?
    • The functional owner of the data will designate an Authorizer who controls access to that data in the MDT environment. The Authorizer for each legacy application can be found on the MDT Application Inventory. As a general rule, access to MDT data is intended for only university personnel who had access to the original legacy data.
  • Once I have permissions, how do I access data stored in flat files stored in the MDT environment?
    • The MDT is a read only environment so flat files will have to be securely FTP'd to a local machine and unzipped before they can be accessed. The detailed procedures can be found here.
  • Once I have permissions, how do I access data stored in an Oracle database in the MDT environment?
    • Oracle databases in the MDT environment can be accessed using an ODBC connection and any of the standard Oracle access tools including Microsoft Access, SAS, and Oracle SQL Plus. Detailed procedures can be found in this document (this doesn't have to be completed until there actually is an Oracle database available for access in the MDT environment).
  • Now that I have the data, how do I know the format?
    • The MDT project provides the detailed file format of all data files stored in the MDT region so that advanced users who knew how to use the legacy data in its source format would be able to use the replatformed data in the MDT environment. The documentation for each application can be found on the MDT Application Inventory.