Page Comparison

General Overview 

• WebFOCUS – WebFOCUS is a

...

UCSADM is the University of Connecticut Student Administration Data Mart. It was formerly known as SADM and was a mostly purchased piece of software. It was a SQL server database housed on a Windows 2003 server. The UCSADM databases although modeled after SADM, were developed here at UConn by a team of UConn employees. They are now Oracle databases that are stored on an EXADATA server. There are ETL processes (Extract, Transform and Load) that are used to load the UCSADM database tables from the PeopleSoft Student Administration system tables every day. Because of that, the data in UCSADM is usually always one day old, from yesterday. 

There are three main database pieces to UCSADM, the database created daily, ODS_CURRENT, and the two census databases, ODS_CENSUS and ODS_END. The ODS_CENSUS database is created on the 10th day of each and every term. The ODS_END databases are created at the end of each term. The CENSUS databases are a “point in time” snapshot of the database to make a historical record of the data for institutional reporting purposes. You will mostly be using ODS_CURRENT for all of your UCSADM reporting.

To query the UCSADM databases we will be using the WebFOCUS InfoAssist tool. We are currently using Information Builders WebFOCUS Release 8.1.0.5 for all of our WebFOCUS environments. The URL for our production environment is https://bi.uconn.edu

Basic Terminology 

...

• KFDM – Kuali Financial Datamart; the location for storing data from KFS, Genesys and other data marts  that will be the source information for financial reporting at UConn
• SADM - Student Administration Datamart; add description/definition here

  business intelligence and data analytics tool. It is used throughout the university to create, publish, share, and collaborate on analytics content. The foundation of this tool is the WebFOCUS query and reporting engine, which enables users to gain access to numerous databases and file systems through a Web browser. 

• InfoAssist – A tool within WebFOCUS that is used to create customized reports. InfoAssist articles can be found in the next section of the IT Knowledge Base.

• KFDM – Kuali Financial Datamart; the source of information from Kuali Financial System (KFS) for financial reporting at UConn.

• SADM - Student Administration Datamart; the source of information from PeopleSoft Student Admin data for student reporting at UConn.

• HRPYDM - Human Resource/Payroll Datamart;

   add description/definition here 
• WebFOCUS – one of the reporting platforms used by UConn that can bring together information from various sources (data marts) by creating and executing valuable reports
  • InfoAssist – tool within WebFOCUS that is used to create customized reports. (How to use InfoAssist is the subject of the Introduction to InfoAssist class.)

...

• the source of information from Core-CT data for human resource and payroll reporting at UConn.

Related Articles

...

...

...

...

...