Oracle BI

Oracle BI
Name	Oracle BI
Developer	Oracle Corporation
Released	2006
Latest release	12c / 11g versions
Programming language	Java, SQL
Operating system	Cross-platform
Genre	Business intelligence, analytics

Oracle BI is a suite of business intelligence and analytics products developed by Oracle Corporation for data warehousing, reporting, dashboarding, and enterprise performance management. It integrates technologies from acquisitions and in-house projects to deliver tools for reporting, ad hoc queries, scorecards, and predictive analytics across large-scale deployments. The suite is used by enterprises, government agencies, financial institutions, healthcare providers, and educational institutions for decision support and operational reporting.

Overview

Oracle Corporation assembled this business intelligence suite to provide enterprise reporting, interactive dashboards, and analytic applications that connect to relational databases, multidimensional stores, and data lakes. The product family aligns with offerings from competitors such as SAP SE, Microsoft Corporation, IBM, Tableau Software, QlikTech International AB, and SAS Institute. Customers in sectors like Bank of America, Walmart, Pfizer, UnitedHealth Group, and National Health Service (England) deploy the suite alongside platforms from Amazon Web Services, Microsoft Azure, and Google Cloud Platform.

History and Development

Oracle Corporation's BI lineage includes integrations of acquisitions and internal projects that trace through software from Siebel Systems, Hyperion Solutions Corporation, PeopleSoft, and components influenced by standards from The Open Group and the World Wide Web Consortium. Key development milestones coincide with enterprise trends influenced by events such as the rise of Hadoop, the prevalence of Apache Spark, advances from Cloudera and Hortonworks, and shifting requirements after the 2008 financial crisis. Oracle's roadmap incorporated technologies comparable to those in Pentaho, MicroStrategy, and innovations from Teradata Corporation and Netezza acquisitions.

Architecture and Components

The suite employs a multi-tier architecture combining presentation, application, and data tiers that interoperate with Oracle Database, MySQL, Microsoft SQL Server, and IBM DB2. Core components include a metadata services layer, an analytics engine, a reporting server, and a semantic modeler that parallels models from BusinessObjects and Cognos. Integration points exist for Oracle WebLogic Server, Apache Tomcat, JBoss, and identity services such as Oracle Identity Management and Microsoft Active Directory. Data integration is supported by Oracle Data Integrator, Oracle GoldenGate, and ETL tools comparable to Informatica and Talend Open Studio.

Features and Functionality

Functional modules offer ad hoc query builders, pixel-perfect reporting, interactive visualizations, and scorecards similar to functionality found in SAP BusinessObjects and IBM Cognos Analytics. Advanced analytics capabilities include predictive modeling aligned with libraries from R Project, Python (programming language), and integrations with Apache Mahout and SAS. Dashboarding supports role-based views for stakeholders at organizations like General Electric and Siemens AG. Mobile BI clients, REST APIs, and Web services enable connectivity to platforms such as Salesforce and ServiceNow, while spatial analytics interoperate with Esri products.

Deployment and Integration

Deployments range from on-premises installations on servers sold by Dell Technologies and Hewlett Packard Enterprise to cloud-based implementations on infrastructure from Oracle Cloud Infrastructure and competitors like Amazon Web Services. Integration practices reference governance frameworks from ISACA and architecture patterns influenced by TOGAF Standard and ITIL. Data governance and lineage are managed in concert with tools from Collibra and Alation, and security is often integrated with Okta and Ping Identity for single sign-on and multifactor authentication. High-availability deployments reference clustering technologies from Red Hat and virtualization from VMware, Inc..

Licensing and Editions

Oracle Corporation markets editions for enterprise-scale customers, departmental deployments, and cloud subscribers, with licensing tied to processor-based and named-user metrics similar to models used by Microsoft Licensing and IBM Licensing. Subscription offerings align with procurement processes used by institutions such as United States Department of Defense and European Commission, while term licenses and perpetual licenses follow commercial practices seen at Accenture and Capgemini. Third-party resellers and system integrators, including Deloitte, KPMG, and Ernst & Young, provide implementation services and managed licensing.

Criticism and Limitations

Critics and analysts have noted complexity and total cost of ownership issues comparable to critiques leveled at SAP SE and IBM enterprise stacks, with long deployment cycles similar to large projects at General Motors and British Airways. Integration challenges can arise when connecting to emerging data platforms like Snowflake (company) and real-time systems such as Kafka (software), and there are concerns about vendor lock-in common to major suppliers like Oracle Corporation and Microsoft Corporation. Performance tuning often requires database expertise analogous to skills used for Oracle Database and Teradata, and licensing disputes have been highlighted in litigation contexts involving corporate customers and procurement bodies.

Category:Business intelligence software