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 »

An Automotive Parts Manufacturer’s Digital Vision Quest

Crafting an interactive digital portal for the partner, customer, and automotive aftermarket ecosystem at large.

Going Digital

This US-based global manufacturer leads the automotive aftermarket in the research, development, manufacturing, testing, and supply of brake system components. Over time they amassed a diverse portfolio of parts and products through acquisitions of other leading parts suppliers and most importantly, continuous innovation in the automotive aftermarket space.

Each of its major brand has its own separate website, and all data is fed back and forth between the main corporate website. While the client was in the process of modernizing each site, their greater digital plan required an interactive web portal geared towards its customers, partners, and the automotive aftermarket ecosystem at large. They sought ennVee’s help to design a solution that would enable seamless sharing of product and other technical information to their partners, customers, and ecosystem.


Key Requirements

ennVee’s solution included building a portal that would provide access to all product details, search catalog, Technical Bulletins, and various company-related and/or sponsored events. ennVee would also need to re-build the underlying product search engine and catalog database from the ground up.

Build an interactive web portal that will enable the customer to accomplish the following:

  • Accelerate growth of business with partners and customers

  • Create an unparalleled customer experience by imparting a digital world of information related to all products, parts, technical bulletins, news, and events

  • Increase digital presence and the number of active registered users via exclusive access to the portal and eCatalog.

 


Web Portal At A Glance

ennVee worked closely with the client to build a digital portal solution that caters to its global ecosystem of customers and partners.

Key Features Breakdown

Portal Catalog Case Study diagram4

 

Products

  • Provides an overview of the product
  • Provides details for new and re-manufactured starters, alternators, and steering systems

Technical bulletins

  • Periodically uploaded by the customer’s Product Engineering team
  • Provides details related to any new or updated products, parts, or services

Literature

  • Articles and write-ups on various parts standards and quality aspects

“News and Events

  • Company and industry-related events
  • Filter by georgraphy

eCatalog

  • This is the database that contains comprehensive information on the customer’s product portfolio
  • Responsive and provides an optimal viewing experience across all types of devices
  • Search for parts from the home page itself
  • Locate parts via the actual Part Number or VIN number
  • Search by selecting options from a drop-down menu, and the vehicle’s category, make, model, or year. Any parts that match the search criteria are subsequently displayed.
  • View the details of each part including Engine, Amperage Rating, Fitment Notes, Grade, Voltage, Pulley details, Regulator Plug Position, Rotation Direction, Engine, Grade, Power rating, Starter rotation, Tooth quantity, Voltage etc.

Detailed View

  • Multiple images are available to view for each part
  • Download technical documentation (PDF files) to any device
  • Part details can be printed from any device
  • Users can select multiple parts to compare side-by-side in a tabular layout
  • Generate a detailed review of each part
  • Users can input competitor part numbers to view related parts
  • Comprehensive search using criteria like begins with, contains, ends with, and exact match based on the available input. A list of parts matching search criteria is displayed along with a detailed view that can be displayed by selecting each part.
  • Any part-related inquiries can be submitted directly through the portal

Project Topology

  • HTML, CSS, JavaScript
  • jQuery
  • Ajax
  • Java
  • REST Web Services
  • MS SQL Server
  • Magnolia CMS
  • Adobe Photoshop
  • Sublime
  • Eclipse
  • Apache Tomcat
  • Load balanced instances: Development (2), Staging (2), Production (2)

Business Benefits

The digital portal is a strategic addition to the portfolio of facilities that the client offers to its global customer and partner ecosystem. A cornerstone of its digital strategy, the portal will enable the customer to provide a seamless omni-channel experience, leading to more business and greater loyalty from both partners and customers. The portal has also been integrated properly with the client’s back-office Oracle Enterprise Resource Planning (ERP) system, automatically synchronizing and sending data to each department (Sales, Marketing, etc.).

The digital journey is ongoing and requires continuous tweaks and enhancements to maximize Return on Investment. With this in mind, the portal is scalable, allowing the customer to rapidly introduce new features without disrupting normal business operations.


Visit our website to learn more about ennVee Digital, or contact us at +1 888-848-6059.

Read more digital success stories »


 

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. 

XML Gateway Integration to Oracle E-Business Suite

Project Overview

    The client’s business faced an increased volume of customers which resulted in an increased time in delivering key information. The high frequency and volume of transactions would require streamlining the communication between customer and trading partners for a seamless flow of business transactions across multiple systems for Sales Orders, Invoices, Purchase Orders and Advanced Shipment Transactions. They chose Oracle XML Gateway for the integration with Oracle E-Business Suite, and to create and consume XML messages generated by business events. This would ultimately automate the communication process and reduce cost, while allowing the customer to be more efficient.

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

  • Oracle XML Gateway

Click here to download the white paper



Talk with us about your integration objectives. Contact us.