Data integration is a fact of life for those of us who are in the information technology business. Since we are yet to invent a single system that does everything for everyone in an enterprise, it is inevitable that we have to support and deal with multiple systems. It is equally true that unless the data from these diverse systems are integrated, we will not be able to understand the data in a coherent fashion. With the proliferation of “best of breed” solutions we have a complicated mess in hand.
Most institutions have a large administrative system like Banner or PeopleSoft that is considered to hold the authoritative data. In addition, for the purpose of reporting, we all have a data warehouse or a data mart into which data from the central systems is inserted typically on a nightly basis. The general premise of this is that the administrative systems were originally designed to take in the transactional data and therefore optimized for that purpose. They were not designed for complex reporting. Combining both of these in one system means a drain in resources and everyone suffers. Modern systems like Workday claims to have designed their system in ways that you can do all activities in one system. When you have multiple systems, generally, the data is integrated with the administrative systems, though in some cases, directly into the data warehouse.
(more…)
I constantly refer to EDUCAUSE in my blog, which is the organization that fosters the professional relationship amongst Higher Ed IT leaders. Prior to EDUCAUSE, there were two organizations, one called EDUCOM and the other called CAUSE. EDUCOM was primarily the gathering place for academic computing and CAUSE was for administrative computing. In 1998, the two merged to form EDUCAUSE. If you look at what is happening at EDUCAUSE conferences lately, they tend to be light on administrative systems because administrative systems professionals gather more at the meetings organized by the major ERP vendors – Ellucian Live, PeopleSoft HEUG and Jenzabar JAM. I was pleasantly surprised to hear about a collaborative effort between EDUCAUSE and NACUBO (National Association of College and University Business Officers) to bring together CIOs and CBOs (Chief Business Officers) of about 150 institutions for an Administrative IT summit in Chicago in June.
A report was produced based on the proceedings in the summit, which I have found to be very informative and easy reading. One of the most important things, while obvious, is not stated often enough, can be found in this report:
“Although administrative IT systems and services are essential to the operations of our institutions, most of them do not significantly differentiate one institution from another. For example, hiring and paying employees, handling procurements, and managing budgets are all important—even mission-critical—functions, but they don’t influence a student’s decision to attend an institution.”
I thought it would be nice to review the recommendations from this report and see how we are doing with respect to these.
(more…)