Case Study - INA Upgrades Oracle Forms and Reports from 6i to 10g
Contact CipherSoft
Do you have a question of comment about this Case Study? We would like to hear from you. Please fill out our Contact Form
Background
The Nunavut Regional Office and NT Region are partners in the Indian and Northern Affairs Canada’s (INAC) DO-North initiative to support activities related to Land Mining and Geoscience. DO-North was established to support the common vision of Land, Mining, and Geology business partners.
Over the next 5 years, the Land, Mining and Geology partners will align information technology and business resources to deliver Web-based solutions, offering spatially enabled data, to support economic development of the North and enhance preparedness for devolution of the Territories.
DO-North is a framework for a series of activities and projects that will assist in harmonizing information and integrating business processes for the North. For more information, visit: www.ainc-inac.gc.ca
Challenge
Indian and Northern Affairs development team were utilizing Oracle Forms and Oracle Reports 6i, and recognized that support for Oracle Forms 6i and Oracle Reports 6i was discontinued effective January 31, 2005. Although Oracle continued to offer extended support through January 31, 2008, it came at a cost. Indian and Northern Affairs needed to upgrade their applications to Oracle Forms 10g in order to ensure continued operational efficiency, while preserving the existing functionality and capabilities within the applications.
Additionally, WordPerfect was being replaced by Microsoft Word as the standard word processor for Indian and Northern Affairs. One of the problems they faced was the requirement to use WordPerfect macros in their applications and the need to replace these macros with Microsoft Word macros. They ultimately turned to Unify | CipherSoft to assist with the project due to Unify | CipherSoft’s expertise.
CipherSoft's Solution
Unify | CipherSoft provided upgrade services from Forms 6i to 10g for both the Oracle Forms and Reports, assisted with deployment in a Citrix environment, and migrated reporting macros from WordPerfect to Microsoft Word. The upgrade and maintenance project for Indian and Northern Affairs leveraged past investments in the core applications and business processes, maintaining current functionality, improvements in speed and reporting capabilities, and within a cost effective solution.
In addition, the migration to Oracle’s 10g technology allows Indian and Northern Affairs the ability to leverage their investment in the original application, while taking advantage of the robust capabilities of the 10g environment. This enables the organization to meet the business requirements for the application for future growth.
Client Reference
- John Jackson
Indian and Northern Affairs
jacksonj[ at ]inac.gc.ca
