Oracle BI users have been aware of the pending end-of-support status of Oracle Business Intelligence Enterprise Edition (OBIEE) for years. Depending on their OBIEE and Fusion Middleware versions, most users are now beyond Oracle’s Error Correct Support (ECS) deadline and are facing a migration.
Challenges:
- OBIEE tool is dependent on traditional data architecture with rigid data pipelines
- Traditional data modeling, ETL, and Data warehousing are time-consuming, especially for larger volume complex applications such as EBS, NetSuite
- Legacy Oracle Business Intelligence Enterprise Edition (OBIEE) is reaching end-of-life and updating existing reports is a resource-intensive process for highly specialized staff that delays the delivery of insights
Incorta – A Unified Data Analytics Platform
Incorta is a unified data and analytics platform designed to address modern data analytic challenges. It is an all-in-one solution that combines data acquisition, data processing, data curation, a semantic layer, and data analysis, all accessible from a single web interface.
Like OAC, Incorta is a fully managed cloud service with embedded BI tools. Incorta directly maps to Oracle and third-party data sources using its Direct Data Mapping technology. This eliminates traditional transformation and aggregation steps and delivers data to the business in record time.
Incorta simplifies and automates traditionally complex and time-consuming tasks, such as data extraction, cleansing, and refining EDW table schemas for analytical queries. Since data is stored in a query-ready format, there’s no need to optimize EDW tables or build OLAP models.
Incorta Data Apps (formerly Blueprints) come with prebuilt reports, dashboards, and user-friendly data views, tailored for popular Oracle and third-party business applications like Oracle EBS, NetSuite, and Oracle ERP. These features significantly reduce implementation time, cutting it from months to just weeks, which lowers project costs and accelerates time to value.
Migrating OBIEE Reports To Incorta
The below high-level processes simplifies migrating or replicating OBIEE reports/dashboards with Incorta dashboards.
Installation of Data Applications (Incorta Data Apps):
Incorta Data apps provide ready-to-use analytic templates for popular business applications like Oracle E-Business Suite, ERP Cloud, NetSuite, SAP, JD Edwards, and Salesforce. These data applications provide physical schemas, business schemas, and even dashboards.
After installing a data application template in Incorta, only light customization is typically required to adjust for local preferences. The results can be dramatic, often reducing implementation times by several months. These can be deployed to your cluster from the Marketplace tab (available on Incorta Cloud and On-premises starting with 5.2) and loaded with your own data very quickly.
Prioritize OBIEE Dashboards To Migrate
During the data discovery phase, identify and group the OBIEE dashboard content that you want to migrate into Incorta. A module-by-module grouping can be effective as the data modeling on the Incorta side that supports the reporting will be contained. Use the OBIEE report usage statistics from the repository to prioritize the dashboards. This usage analysis provides the frequency that users access the dashboards and response times.
Use the NQuery logs to get the physical query that generates when the OBIEE report runs. Having that SQL available will help you as you build your data model in Incorta. The Incorta Data Apps may cover most of what you need but having the specifics of the tables and columns in the dashboards you intend to build in Incorta will make it easier to fill any gaps that remain.
Customize Business Schemas on OBIEE Subject Areas
One key concept in Incorta is the Business Schema, which provides an abstraction layer on top of Incorta’s physical schemas, making it easier for business users to interact with data. To simplify the translation of OBIEE dashboards, you can model your Incorta Business Schemas based on the OBIEE Subject Areas you use. Each Business Schema can correspond to one Subject Area, and you can create a Business View for each folder within the Subject Area. This approach ensures that your report and dashboard builders have a familiar set of data elements to work with, streamlining the transition and improving usability.
Organize Multiple OBIEE Reports in a Single Incorta Dashboard
In Incorta, you can put multiple reports, or Insights in Incorta parlance, onto a single dashboard tab and create multiple tabs per dashboard. This allows users to have a lot more information together in one place which is generally more efficient for them. If your OBIEE dashboards consist of a single report, then you can take advantage of the migration to Incorta to enhance the experience for your users.
Replicate OBIEE Security Model In Incorta
We can mimic the roles as defined in OBIEE in Incorta to manage access to the dashboard content that you create. Define clear guidelines and differentiate power users and dashboard users using pre-defined Incorta roles. It is possible to emulate any row-level security rules that you have established in OBIEE in Incorta using run-time security filters and session variables.
Leave a Reply