Click here to receive your FREE subscription to Campus Technology
Cover Story
Data Mining & Business Intelligence >> Open for Business
2/1/2007
"By not being dependent on proprietary technology,
we have more latitude when it comes to potential
vendors, which gives us greater leverage on pricing."
—Andrew Brenneman, University of Chicago Press
Compatibility is Key
After a dozen years as a satisfied Microsoft customer, Stephen and her teammates concluded that they could no longer use Microsoft SQL for their reporting needs. The latest version of SQL required use of Microsoft’s active directory (AD) system, but NU needed a solution based on a more open standard, compatible with the different kinds of systems the university supported. Administrators “couldn’t use the AD approach if we wanted to,” Stephen explains, adding that her team decided to use the iReports report writer and Jasper Intelligence server from commercial open source BI solution provider JasperSoft, for the same reason that they had originally decided to use Microsoft’s SQL server and NT: compatibility. she claims that JasperSoft allows users to connect to other applications regardless of their place in the server directory structure, unlike Microsoft’s high-end BI products.
Stephen says she asked the Microsoft people “a million times” why the company had created this lack of flexibility, and she came to think it was a marketing ploy. “I think they believed—and in many cases it’s true—that they could control their market by forcing people into the same active directory structure,” she says.
Though she and her team were slow to turn to an open source solution, she says it’s turned out to be “a joy and an awakening,” as she’s become aware of open source offerings not only in BI, but in all kinds of applications.
Stephen confides she has been surprised at the quality of the JasperSoft tools now being rolled out on campus, and singles out the company’s iReports module as a particularly strong one. “iReports is every bit as rich as Crystal Reports [www.businessobjects.com], and it generates beautiful reports,” she says. Shifting to JasperSoft has “made it possible for us to use high-end tools, and to replace the old, archaic, hand-carved drill-down reports that we had developed in-house,” she says.
Price and Flexibility
A lower price tag is another reason campus IT professionals are drawn to open source. Advocates of the approach insist the systems can give an IT department a way to start providing high-quality business intelligence tools quickly, without having to wait for a budget committee to write a $3 million check.
For years, cost concerns kept Indiana University administrators from purchasing a BI system. “It’s hard to ‘sell’ something people don’t know,” says Rebecca Gribble, manager of decision support services at IU. But since her department installed the open source Eclipse BIRT (Business Intelligence and Reporting Tools) system this past fall, Gribble believes she will soon build up a constituency for BI, which may make it easier to include a more established system in the budget at some point—that is, if the school even needs one; at the moment, it’s too early to tell. “We may find that it meets our BI need, period,” says Gribble. “Or, we may find that it just whets the appetite,” she adds.
But consultants and open source BI vendors cite the ability to customize the systems as another key advantage. For a campus IT shop with some in-house programming expertise, having the source code makes it possible to customize the software to meet campus business needs, rather than the reverse: revamping processes or back-burnering need in order to meet software requirements.
The University of Chicago Press (the publishing unit of the University of Chicago) is likely to become another early academic adopter of open source BI. The IT team of the UC Press is now evaluating Pentaho, a full-service BI suite and JasperSoft competitor. “We are still at the evaluation stage and it’s looking very promising,” says Matt Fisher, senior developer for business architecture. What the IT team sees in Pentaho, says Online Business Manager Andrew Brenneman, “is an ease of use and a set of objects that we could easily leverage.”
Recommended Reading
- Sun, Stanford Working To Archive History
In May in San Francisco, experts from leading universities, libraries, and research institutions around the world met as part of an ongoing effort to address a pressing issue: archiving the world's history, right up to today.
- The Quilt Coalition Rolls Out XO Communications for High-Capacity Network Services
The Quilt, a coalition of 28 regional network organizations, has added XO Communications Services to its authorized vendor list. The Quilt represents 200 universities and thousands of other educational institutions across the United States. With this new relationship, Quilt members can purchase XO's high-speed IP transit and network transport services at competitive rates.
- Wimba Classroom 5.2 Expands Classroom Capture Support, Adds MP3 Downloads
At the NECC 2008 conference in Texas this week, Wimba launched a new version of Wimba Classroom, the virtual classroom component of the company's Collaboration Suite. The new 5.2 release expands options for classroom capture and adds a variety of other functional and ease of use features.
- Automation Chimera: Education Is Not Management
The lure of automating workflow online so human intervention is minimized is continually reinforced in the minds of higher education administrators by examples of automated campus systems such as financials, student information systems, and other enterprise systems. But what's good for management is not always good for learning.
- Cognos Releases BI Software for Linux-based IBM System z Mainframe
Cognos, which IBM acquired in January, has released an update to its business intelligence software that will run on the Linux operating system on IBM System z mainframes. IBM Cognos 8 BI was being developed by the two companies prior to the acquisition, but assimilation of Cognos into IBM accelerated development.
- Facebook and Collegiality: A Serendipitous Social Niche
Facebook is a way to greet a colleague as if she or he is on your own campus: a wave at a distance, a hello at the corner burrito place, a honk as you both leave the campus parking lot. Informal collegiality has been extended over the miles.
