Migrating from Oracle Discoverer to Microsoft SSRS

A Private, Women’s Liberal Arts College Migrates from Oracle Discoverer to MS SSRS in 8 weeks.

Retiring legacy reporting tools

The client is an internationally-recognized, private, women’s liberal arts college located in Massachusetts. As an IT-savvy institute they use Oracle Discoverer for all MIS requirements. After Oracle stopped supporting Discoverer in mid-2017, they sought an optimal migration path to migrate their analytical reports to a more intuitive platform, ultimately selecting Microsoft SQL Server Reporting Services (MS SSRS) to replace Discoverer.

Having already installed and used MS SSRS for years, the client avoided the need for a separate implementation project and additional user training. In this case, the three primary constraints were time, cost, and resources needed to migrate. The client’s internal IT team did not have the availability to manually migrate from Discoverer to MS SSRS, and needed ennVee’s help to automate the migration process.

Customer Snap Shot

  • Private women’s liberal arts college
  • Location: Massachusetts, USA
  • 2300 students
  • Annual endowment: ~$2 billion USD

Solution Process

Due to the constraints for both cost and time, we aimed to automate as much of the migration process as possible by utilizing our proprietary ennSight tool, which automatically identifies, assesses, and extracts all reports from Discoverer, including security and business rules.

To start, we conducted a comprehensive assessment of the client’s Discoverer reporting environment. The assessment produced a detailed snap shot of all reports broken down by department, owner, duplicates, complexity of the SQL, and estimated effort to migrate. to help them determine which reports to migrate, sunset, and consolidate. Then, the client went back to its business users and had them scrub the list for any duplicates or obsolete reports. The final decision for what to migrate consisted of 500 essential reports covering four tracks, HRMS, FINANCE, FACULTY, and PAYRPT.

After, the ennVee team used ennSight to automatically extract all 500 identified reports from Discoverer, identifying all user roles and user assigned schema. Based on the extraction each report was divided into one of three categories, Simple, Medium, or Complex. This categorization allowed us to determine the complexity and effort required to convert and test the workbooks and reports. Post-extraction, we automatically migrated each report “as is”. This allowed us to significantly expedite the migration process, and gave the client the opportunity to review and decide whether any enhancements were required in the final MS SSRS output. Finally, each report was unit tested before being deployed to the client’s server.

Total time to migrate: 8 weeks

discoverer to MS SSRS migration diagram - wordpress.png

Topology


Outcome

All 500 Discoverer reports were successfully migrated to MS SSRS in eight weeks without any loss of data or disruptive rebuild. Automation helped the customer reduce the amount of complexity involved, as well as time, cost, and resources required to migrate. Rather than dedicate its internal staff to manually migrating the reports, the ennVee team handled and automated the process, affording the customer additional time to focus on strategic projects.

Additionally, Discoverer users are able to create substantially more intuitive reports via the self-service MS SSRS reporting platform. They can also move reports to Microsoft Power BI to augment the analytics or visual effects. Overall, automation has enabled the college to dedicate more time to strategic initiatives, while simultaneously migrating from Oracle Discoverer in just eight weeks.


Visit our website to learn more about automated Oracle Discoverer migration, or contact us at +1 888-848-6059.

Read more customer success stories »

ennVee to Host Session on Oracle E-Business Suite R12.2 Upgrade Automation at Upcoming OAUG Event

ennVee will be presenting and exhibiting at the upcoming Gateway Kansas City OAUG event on November 8th.

We’re excited to announce that ennVee will be presenting and exhibiting at the upcoming Gateway Kansas City OAUG event on November 8th.

Make sure to catch our Customer Experience session hosted by ennVee President, Veera Venugopal and Vice President of Global Sales and Marketing, Joe Bong. Both will discuss ways in which customers can leverage automation to accelerate the Oracle E-Business Suite ERP upgrade process to the latest R12.2 release. 

About our Session

Automation: Or How We Eliminated Manual R12.2 Upgrades and Become Cost Saving Hero
Who doesn’t want peace-of-mind from their Oracle E-Business Suite R12.2.7 upgrade? President and Vice President, Veera Venugopal and Joe Bong will discuss how project and business teams can expedite R12.2.x upgrade process through automation. We will share tips, best practices, and lessons learned from past upgrades, which will help you leverage automation to create efficiency, reduce time and cost, while increasing quality.

When: Wednesday, November 8th from 10-10:40AM CDT.
Where: GRID Collaborative Spaces, 12022 Blue Valley Parkway, Overland Park, Kansas 66213

Full agenda and registration – http://bit.ly/2xOYRAq

Learn more about the centerpiece of our session, ENNABLE

ennVee is attending MIDHEUG Alliance 2017

ennVee will be attending this year’s Midwest Higher Education User Group (MIDHEUG) conference from October 12th-13th at Pheasant Run Resort in St. Charles, IL.

ennVee will be attending this year’s Midwest Higher Education User Group (MIDHEUG) conference from October 12th-13th at Pheasant Run Resort in St. Charles, IL. This is the first year that we are attending, and we look forward to connecting.

The Midwest Regional User Group (MIDHEUG) is a HEUG online community that includes Kansas, Illinois, Indiana, Iowa, Michigan, Minnesota, Missouri, Nebraska, North Dakota, Ohio, South Dakota, and Wisconsin. The annual Alliance conference will bring together higher education institutions in the region who use Oracle applications/technology.

We will highlight our current business intelligence initiatives and Oracle Discoverer migrations for colleges and universities across the US. If you’re attending, stop by our booth and pick up some freebies.

Register to attend at https://www.heug.org/e/in/eid=349

Salesforce to Oracle E-Business Suite Integration using MuleSoft

Client Snapshot

  • Leading manufacturer of physical
    infrastructure for Data Center, Enterprise,
    and Industrial environments
  • 5,000 employees worldwide
  • $1+ billion (USD) annual revenue
  • Location: Chicago, IL (USA)

Project Overview

  A sales person is effective only to the extent of knowledge they have about the product or service that they are selling. Even the most “blue chip” CRM systems do not effectively provide the internal product or services information required by the sales person at that time. Typically, the information related to customer, sales order, availability, etc. resides within the internal ERP systems, which limits access to the increasingly mobile salesforce. Being able to access information on-the-go in real-time expedites the sales process and enables the sales person to make more effective sales.

Topology

  • Oracle E-Business Suite (EBS) R12.x

  • MuleSoft AnyPoint Studio 3.8
  • Salesforce – Summer ’17


Click here to download the full White Paper!

tcp-download-thumbnail.png



Are you experiencing an issue with a current custom development project? Would you like assistance with an upcoming project? Contact us. 

WorkDay HCM to Oracle E-Business Suite Integration

white-paper-hcm-workday-ebs-ennvee-blog-12-2017In 2016, Human Resources-related OPEX were on the rise and creating chaos for an industry leading manufacturer of network infrastructure. They concluded that a switch from Oracle HRMS to WorkDay HCM Cloud would be the most effective way to tackle ascending HR costs. Since the customer runs a bulk of their business operations on Oracle E-Business Suite, it was imperative to properly integrate the new WorkDay HCM system with the existing Oracle E-Business Suite. Our objective was to build the real-time and batch mode integrations between Workday and the client’s existing Oracle E-Business ERP system to provide the ability to leverage employee information across both systems.

Client Snapshot

  • Leading manufacturer of physical infrastructure for Data Center, Enterprise, and Industrial environments
  • 5,000 employees worldwide
  • $1+ billion (USD) annual revenue
  • Location: Chicago, IL (USA)

Topology

  • Oracle E-Business Suite (EBS) R12.x

  • WorkDay HCM Cloud

  • Oracle Fusion Middleware

  • Oracle Forms / Reports / SQL Developer

 

Click here to download the white paper 



Are you experiencing an issue with a current custom development project? Would you like assistance with an upcoming project? Contact us.