Skip to main content

Data Warehouse Updates

April 2024

  • The Office of Information Technology (OIT) is actively working on reducing the current security risks with the on-premise data warehouse that is end-of-life by migrating to Oracle Cloud Infrastructure, as well as improving scalability to support future growth of data and analytics.  Arisant, LLC consulting has been hired to provide technical support to design the new Oracle Cloud Infrastructure, migrate from the on-premise data warehouse to the Oracle Cloud Infrastructure and support end-to-end testing.
  • The target date to complete the migration is the end of April 2024.
  • While this change is primarily geared towards ensuring robust security measures through regular updates and patches, end users can expect several positive impacts with this migration. The immediate impact will be the improved performance of reports and dashboards in Oracle Analytics Cloud (OAC) and Data Visualizer. The implementation of continuous monitoring of system performance allows for automatic adjustments based on workloads, queries, and the number of users. Features such as automatic indexing, query optimization, and parallel processing will contribute to faster query execution times and overall system performance. Due to this high scalability and performance, processing of large volumes of data will be more efficient which is crucial for advanced machine learning and AI capabilities. These advancements enable more sophisticated reporting such as predictive analytics and natural language processing. Business Intelligence Reporting Services (BIRS) developers will benefit from additional functionality not available in our current environment, including access to OAC report usage statistics and the ability to optimize high-performance loads. These high-performance loads are expected to notably enhance the efficiency of our Fusion load, while concurrently diminishing the occurrence of load errors that impact OAC (non real-time) reports containing financial and HCM data. Developers will be able to allocate more time and resources to deriving value for the end users rather than managing infrastructure.