Chico State Data Warehouse 8.9 to 9.0 Upgrade

By rlobban

  • Data Warehouse 9.0 testing prep

  • Period: to

    Prep for testing

    Get acocunts for our 9.0 instances
    HACHITST
    HACHIUPG
    setup Firewall rules
    setup Dev databases
  • Period: to

    Test Staging pull process

  • Clob issue found

    In our 9.0 databases columns that were long are now clobs. time to pull tables with clobs increased exponentially.
    example: ps_communications use to take 3 minutes now takes 8 hours
  • Period: to

    Investigate clob issues in table pull

    Clob issue writeupWe did very extensive testing on this

  • Found a workaround for Clobs

    After lots of back and forth with George Mansoor at CMS, Chico State found a workaround for the clob issue. The workaround is not scalabale but does work currently. Still awaiting reply from George Mansoor for a solution our a document stating why no solution

  • Begin Analysis of source and staging tables

  • Period: to

    Staging table comparison

    Analyze the differences in staging tables making note of the following:
    Missing fields
    New fields
    Data type changes
    Data length changes
    Precision changes
    scale changes

  • Begin RDS Analysis

  • Period: to

    Catalog issues building Data Warehouse from 9.0 tables

    Continuously rerun Data Warehouse builds and document issues that we find
  • Period: to

    Iteratively resolve issues

  • Developer testing begin

  • Period: to

    Developer Testing

    This testing will be iterative and cyclical.
    Test, fix, test, fix

  • Ready for production