Integrating NetSuite and Tableau using MuleSoft AnyPoint Studio

We integrated NetSuite with Tableau to enhance our analysis and reporting capabilities. Download the white paper to learn how you can too.

ennVee TechnoGroup uses an internal employee time sheet system that was designed and built on the NetSuite ERP platform. We decided to build the NetSuite to Tableau integration using MuleSoft. As a result, our analysis and reporting capabilities were significantly enhanced.

Fill out the form to download the NetSuite integration to Tableau white paper.

Migrating from Oracle Discoverer: Automation

Oracle Discoverer is de-supported as of July 1, 2017. You’ve likely started to evaluate self-service alternatives, but how complex is the actual migration? 

“Extended Support” Ended After June 30, 2017 

The general consensus is that Disco music died on July 12, 1979 after the infamous  “Disco Demolition” event host ed by Chicago radio disk jockey Steve Dahl. Even though artists continued to release Disco records during the early 1980’s, the populace had already lifted and shifted to a different genre.

If you use Oracle E-Business Suite or Banner, you’re probably familiar with Oracle Discoverer, a 20-year ad-hoc querying and analysis reporting tool that has officially retired as of June 30th, 2017. Since 2009 Oracle has been transparent about its strategic direction for business intelligence, so the announcement of retirement does not come as a shock to those still using Discoverer.

Numerous BI and reporting platforms have been released since Discoverer reached its apex. As we lift and shift to a new standard of self-service reporting, it’s imperative to select a scalable, sustainable, and cost-effective replacement that solves existing business needs, eliminates the possibility of “shadow BI” projects, and is desired by both end users and IT.

Discoverer Replacement & Migration Options 

  1. Do nothing
  2. OBIEE / BI Foundation Suite
  3. Tableau
  4. Power BI
  5. Migration Automation

 

1. Do nothing

If it’s not broken, why fix it? There still exists the option to upgrade to the latest release 11gR1and utilize the pre-packaged integration with Oracle E-Business Suite (EBS) and Oracle EBS Federal Financials.

Oracle’s Sustaining Support policy excludes the following:

  • New updates, fixes, security alerts, data-fixes, and critical patch updates
  • New tax, legal, and regulatory updates
  • New upgrade scripts
  • Certification with new third-party products/versions
  • Certification with other Oracle products

While day-to-day reporting and licensing will remain the same, the cost of a few iterations can exceed that of a replacement or migration project.  There’s also the potential of failed integration with later versions of E-Business Suite, and any new desktop, browser, or Windows OS updates. Additionally, migration is necessary to remain compatible with the latest Oracle E-Business Suite R12.2.x releases, Oracle Database 12c, and to use any of Oracle’s Fusion Applications.

Inevitably, both business and users will need a more accessible solution that provides stronger data visualizations and interactivity. Continued usage increases the complexity of transforming that data into actionable insights to support strategic decision making.


 oracle_bi_logo.png

2. BI Foundation Suite / OBIEE

Oracle Business Intelligence (Enterprise Edition), OBIEE, is part of Oracle’s strategic road map for business intelligence.

From what we’ve encountered helping customers migrate, OBIEE is often selected because they already own the licenses and can spin it up faster than implementing and migrating to another application. OBIEE is still “in” support, and can be interfaced directly with Oracle EBS, Fusion, and Forms, which makes it an ideal choice for Oracle customers running Discoverer. Customers who wanted analytics and dashboards tended to choose OBIEE, while those looking for day-to-day operational reporting gravitated towards other (non-Oracle) applications.

While OBIEE delivers what it promises, an army of reporting tools for executives and end users alike, it’s important to consider the time, cost, and effort required before, during, and after implementation and Discoverer migration.

Migration from Discoverer to OBIEE

discoverer-to-obiee-migration-process.png

Migrating from Discoverer to OBIEE is complex. For starters, there are no tools available to automatically migrate workbooks, which means all queries must be re-created from scratch.

The End User Layer (EUL) can be migrated automatically using Oracle’s Discoverer Metadata Conversion Assistant. Converted elements include business areas, simple, complex, and custom folders, columns, joins, conditions, and hierarchies.

Many elements cannot be migrated simply because there is no equivalent in OBIEE. These include: item classes, summary folders, optional conditions, complex folders (either dimensions or based on complex folders), and hierarchies based on complex folders. Click to read the full list.

Other Considerations for OBIEE and BI Foundation Suite

Licensing
OBIEE requires separate licensing costs for each “pack”; BI Server, BI Answers, BI Interactive Dashboards, BI Delivers, BI Publisher, Oracle Real-Time Decision Server, Oracle Scorecard and Strategy Management, and/or Oracle Data Visualization.

Based on the Oracle Technology Global Price List, the cost to license OBI or Essbase may not provide due diligence if you require a composite of features not limited to a single application.

Training, Maintenance, and Support
There is a considerable learning curve in OBIEE, which requires learning multiple tools and aspects of business intelligence in order to make it work well together. After migrating off Discoverer, a substantial amount of RPD modeling work and dashboard preparation is required for end users to start utilizing OBIEE. Additionally, maintenance and support will require hiring additional resources.


tableau-logo

 3. Tableau

Tableau’s powerful packaged BI offering, Tableau Desktop, allows users to drag and drop to analyze data, connect to data in a few clicks, and visualize and create interactive dashboards with a few more.

Over the course of our past Discoverer to Tableau migration projects, the primary factors for selecting Tableau has ranged from the amount of available features, data visualizations, scalability via ease-of-upgrade, and affordable licensing.

ennVee’s Discoverer migration accelerator automatically transfers all reports and objects to Tableau. Provided below is an example to highlight the comparison of between a Sales Orders report before and after migration.

Sales Orders(DIS)
Sales Orders in Discoverer
Sales Orders(TWB)
And after migrating to Tableau Desktop

 


power-bi_logo.png

4. Microsoft Power BI

Over the course of the last few years, Microsoft has continued to beef up its Power BI analytics tool. Power BI has ascended from a middle-of-the-road solution to the leading business intelligence and analytics platform of 2017.

What makes Power BI an attractive replacement for Discoverer is the “out of box” data modeling and self-service analytics capabilities. We have helped many customers migrate to Power BI by way of our accelerator, which automatically extracts complete Discoverer reports and imports them into Power BI without requiring a rebuild.

Power BI and Power BI Desktop are available to use for free, while Discoverer power users may opt for the Pro version ($9.99/user/month). The Pro version is required in order to migrate from Discoverer, as it is the only version that enables users to share data, security details, roles, and access information.

Min Max Parts(DIS)
A Min Max report in Discoverer
Min Max Parts(PBI)
And after migrating to Power BI

Aside from cost-effective licensing, Discoverer migration to Power BI has become a feasible route for the growing number of companies that are switching over to Office365. If you’re in the process of moving to Office365, Discoverer to Power BI migration would be a synergistic side-effect.


5. Automated Migration to Tableau, OBIEE, Qlikview, Power BI, etc. in 2-8 Weeks

ennVee offers an accelerated conversion process that automatically migrates all Discoverer workbooks and elements to  Tableau, OBIEE, Qlikview, SQL Server, SQL Server Reporting Services (SSRS), PowerQuery, Power BI and more. Our packaged automation significantly reduces manual effort and time to migrate, at minimal cost and zero rebuild.

Our accelerator completes the Discoverer migration in 2-10 weeks. We provide a live interactive demonstration, PoC, and assessment free of cost. The cost of the actual migration is fixed based on the number and complexity of reports.

Click here to download the datasheet

List of migrated elements

  • Reports
  • Infrastructure
  • Folders
  • Calculations
  • Filters
  • Workbooks
  • Sheets
  • Conditions
  • Joins
  • Classes
  • Hierarchies
  • Business Rules
  • Security
  • Roles

 


We offer a complimentary assessment with conversion timelines and fixed bid pricing. Complete the form below or contact us to learn more.


Kickstart your free assessment

60% of customers, who have utilized our free assessment, choose ennVee for their Discoverer migration.