Oracle Database

back to top

Oracle Database is the only secure object-relational data management system for multimedia-rich Internet applications, high-traffic OLTP environments, and query-intensive data warehouses. The Oracle Database includes the broadest array of the most valuable services in one COTS product. It significantly enhances IT operations via automation,clustering, and high availability.

DATA WAREHOUSING

Oracle Data Mining - Data Mining sifts massive sets of data to discover hidden patterns and insights without moving data. After identification of the best data mining models to use and data preparation, it uses machine-learning algorithms within anomaly detection and decision trees to predict outcomes, attribute importance and association to find relationships, and classification and clustering to automatically group records.

Oracle OLAP - OLAP extends SQL’s analytical capability by embedding a multi-dimensional database and a high performance calculation engine. Without moving data out of the database, users analyze data along dimensions such as location and time, as well as perform what-if analysis, forecasting, and over 100 OLAP functions.

Oracle Partitioning - Partitioning segments large tables by range, hash, or list to increase performance, simplify maintenance, and improve availability. DBAs manage, move, or archive partitions independently while executing operations in parallel across online partitions. In addition, partition elimination improves query performance by minimizing table scans.

Oracle Warehouse Builder - Warehouse Builder designs sophisticated datawarehouses, offers automated ETL processes, and configures end user access layers.

EMBEDDED DATABASES

Oracle Berkeley DB (formerly Sleepycat) - Berkeley DB is a family of open source, embeddable databases that includes a high performance, transactional database, an XML database with XQuery support, and a pure Java database optimized for the Java environment. They provide developers with fast, reliable, local persistence while requiring no administration. Berkeley DBlinks its library directly into applications, stores data locally and in a native format, and eliminates the overhead of SQL query processing.

Oracle Lite - Oracle Lite is a small footprint database optimized for mobile devices and embedded applications. Oracle Lite’s Mobile Server provisions applications, synchronizes data with Oracle Database, and manages users. Oracle Lite’s tools accelerate mobile application development.

Oracle TimesTen In-Memory - DatabaseTimesTen is a memory-optimized database that enables real-time applications with very high throughput, zero administration, and instant responsiveness. Deployed in the application tier as a cache for Oracle Database or a standalone database, TimesTen uses standard SQL interfaces and runs entirely in memory. Options include:

CONTENT MANAGEMENT

Oracle Content Database (formerly Content Services) - Content Database evolves legacy file management systems into a consolidated, database-centric content management solution. It offers users a comprehensive platform for file and document lifecycle management. Organizations consolidate their scattered file servers into the most secure and scalable database repository while providing all their users access through multiple channels: AFP, NFS, SMB,FTP, HTTP, or WebDAV. These channels enable Content Database to be seamlessly employed in familiar environments, when and where users need it, without changing the way they work. Features include role-based security, file and folder-level access controls, check-in/out, attribution, versioning, virus checking, offline management/ synchronization, and workflows for document approval and routing.

Oracle interMedia - Oracle interMedia manages multimedia like imagery, audio, and video. It offers extensible functions to process media and extract metadata for over 100 file formats.

Oracle Records Database (formerly Records Management) - Records Database provides comprehensive lifecycle management capabilities such as declaration, classification, storage, retrieval, and disposition control for electronic records. It enables organizations to enforce compliance with corporate and government regulations by specifying policies that control the retention of documents. Records Database is in evaluation for DoD 5015.2 certification.

Oracle Secure Enterprise - Search Secure Enterprise Search is the highest quality, easiest-to-use solution that queries all information assets securely. Key features: 1) search public and access controlled content inside file servers, email servers, document management systems, databases, and portals; 2) enforce access control lists to secure sources and filter search results so each user sees only what he/she is allowed to access; 3) leverage Oracle Text’s advanced features such as superior relevance ranking and automatic document categorization.

Oracle Spatial and Locator - Spatial and Locator support a wide range of geospatial solutions from wireless location-aware e-business services to geographic information systems. Locator, included free, provides the primary location functionality such as proximity and distance queries. Spatial provides next generation features such as linear referencing, network path analysis, location correlation, topology, and georaster images. They both eliminate the cost of separate proprietary systems and are supported by leading GIS vendors.

Oracle Text - Oracle Text extends SQL to index, search, and analyze documents and text. It also performs linguistic analysis to cluster documents, generate gists and themes, and visualize document relationships. Other features include keyword highlighting, relevance ranking, and document-to-HTML conversion.

SECURITY

Oracle Advanced Security - Advanced Security, in evaluation for FIPS 140-2 certification, fulfills emerging security requirements by protecting sensitive data stored in the database and traveling over the network.

Oracle Audit Vault (coming soon) - Audit Vault provides enterprise data surveillance which protects against internal espionage and maintains oversight of system administration. It collects and analyzes audit data from various systems in an enterprise to detect improper access and use. Providing over 250 other auditing functions, Audit Vault sends alerts, generates user activity reports, and protects audit data from tampering via self-auditing.

Oracle Database Vault - Database Vault is state-of-the-art access control that provides a highly configurable and multi-factored approach to database security. Rules restrict data access by using a variety of system variables such as time of day, client application, or network. Realms strictly enforce separation of duties by dividing and limiting the responsibilities and permissions granted to database and security administrators. With Database Vault, Oracle’s Cross Domain Security Solution facilitates DCID 6/3 Protection Level 4 accreditation.

Oracle Label Security (OLS) - OLS meets regulatory compliance challenges by protecting access to sensitive data such as personal identity information, medical records, and national security data. OLS stores data of multiple levels of sensitivity in a single table. It filters access to the data via sophisticated row level security controls and data sensitivity labels such as “Top Secret:US:A” and “Confidential:NOFORN:C.” Enforcing mandatory access controls ( MAC), it has successfully achieved ISO 15408 Common Criteria EAL4+ evaluation.

Oracle Secure Backup - Secure Backup provides high performance centralized tape backup management for any size data center with heterogeneous environments. It protects file systems and Oracle Databases, supports direct and network-attached tape drives, as well as provides a fully secure backup platform with policies, rules, access control, secured transmission, and encrypted database backups.

HIGH AVAILABILITY:

Oracle Automatic Storage Management (ASM) - ASM radically simplifies administration of the disk subsystem by integrating a volume manager and file system expressly designed for Oracle databases. Data is optimally mirrored for protection and striped for performance. Storage modifications are made easily online and files are rebalanced automatically. Thus ASM provides the performance of raw I/O and ease of use of a file system.

Oracle Clusterware - Clusterware ensures availability for all applications by restarting or failing them over to other servers when there is a process or node failure. This complete integrated clusterware management solution, available on all platforms, includes cluster connectivity, messaging and locking, cluster control and recovery, and service provisioning.

Oracle Data Guard - Data Guard protects databases from disasters, corruptions, and errors. It provides zero-data-loss synchronization of standby databases while off-loading query and back up activities to the standby. Further, DBAs can also minimize downtime via rolling upgrades.

Oracle Real Application Clusters ( RAC ) - RAC ’s shared everything architecture is the cornerstone of the Grid that harnesses the processing power of multiple, interconnected servers for a single database. The patented clusterware and cache fusion solution enable unlimited scalability and availability for any application without modification. In a database cluster, performance scales linearly when a server is added; and the system remains 100% available when a server is removed. Thus RAC enables database servers to be dynamically allocated for optimal usage.

DATA INTEGRATION

Oracle Generic Connectivity and Transparent Gateways - Gateways are connectivity solutions for heterogeneous data sources. They seamlessly access non-Oracle systems by empowering the Oracle SQL engine with data type, SQL, and data dictionary translators, as well as heterogeneous transaction coordination. Generic Connectivity is a basic solution for ODBC or OLEDB systems. Transparent Gateways are specifically tailored to communicate using the non-Oracle system’s native interface. They provide an optimized solution with better performance and more features. Oracle provides mainframe and open system gateways for databases such as Teradata, DB2, and SQL Server; enterprise integration gateways for data sources such as APPC and IBM DRDA; and a transparent gateway for iWAY.

Oracle Streams - Streams is a comprehensive framework for capturing, routing, transforming, and disseminating events, transactions, and data between systems. This comprehensive solution features message queuing, replication, event notification, and publish/subscribe.

APPLICATION DEVELOPMENT

Oracle Objects - Oracle Objects allows developers to create domain-specific data types and user-defined objects in the database that interface seamlessly with Java and C++ applications. Object-oriented features include inheritance, substitution, and multi-level collections.

Oracle XML DB - XML DB is a high-performance, native XML storage and retrieval solution. While adding HTTP/S, WebDAV, and FTP protocol support to the database, it also provides additional access methods for navigating and querying XML such as fragment extraction and update, XML Schema validation, SQL and XML interoperability, XPath evaluation, XQuery, and XSL transformation. The XML Repository embeds the W3C XML data model and manages XML document hierarchies, foldering, access control, and versioning.

ORACLE FUSION MIDDLEWARE

back to top

Oracle Fusion Middleware is a comprehensive and unified middleware platform that includes products such as Oracle Application Server, Business Intelligence, Collaboration Suite and Developer Tools. It powers many solutions such as integration, J2EE, identity management, the Service Oriented Architecture, and enterprise portals. These hot-pluggable services and solutions share a common Grid infrastructure enabling them to be deployed independently, integrated, or distributed in a cluster of servers for industry-leading performance, scalability, and reliability.

IDENTITY MANAGEMENT

Oracle Access Manager(formerlyOblixCOREid Access & Identity) - Access Manager administers user profiles and controls user privileges to Web resources. It enforces fine-grained authorization policies and enables single sign-on to Web applications on a variety of mid-tier servers. It also controls the process for creating and deleting users and groups and provides delegated and self-administration of profiles. Further, Access Manager audits and reports who has/had access and what has been accessed. In evaluation for ISO 15408 Common Criteria EAL4, Access Manager improves application security, regulatory compliance, and end user experience.

Oracle Certificate Authority - Certificate Authority provisions and manages X.509 PKI digital certificates to enable digital signatures, data/message security, and strong user authentication.

Oracle Enterprise Single Sign-On Suite (developed with Passlogix) - Oracle eSSO Suite easily and securely enables users to logon once to access all web-based, client-server, and legacy applications. It interfaces with user repositories, automates password management tasks, supports strong authentication, and is FIPS 140-2 compliant.

Oracle Identity Federation (formerly Oblix COREid Federation) - Identity Federation is a cross-domain single sign-on solution that enables partner organizations to securely link their enterprises’ applications and portals. Federation allows each organization to operate independently while cooperating for business purposes and increasing compliance with security and privacy regulations.

Oracle Identity Manager (formerly Thor Xellerate) - Identity Manager administers users from creation to expiration. It builds provisioning workflows and policies that police, automate, and audit how user accounts and privileges are granted/revoked across an enterprise’s heterogeneous systems. Identity Manager Connectors facilitate rapid integration to packaged and custom systems.

Oracle Internet Directory - Internet Directory is an LDAP directory that leverages the high reliability and performance of the Oracle Database. It centrally manages user accounts and privileges across systems. It also provides hierarchical delegation of administration, single sign-on for Oracle, and synchronization with SunONE and Microsoft Active Directory.

Oracle Security Developer Tools - Security Developer Tools protect service-oriented and PKI-based architectures via Java, XML, and Web service security mechanisms and cryptographic building blocks. This SDK supports cryptography algorithms as well as standards such as S/MIME, X.509, XKMS, XML and WS-Security, SAML, and Liberty Alliance.

Oracle Virtual Directory (formerly OctetString) - Virtual Directory presents a consolidated view of identity information without synchronizing or moving data from the native user repositories. It also provides industry standard Web service and LDAP interfaces for applications, as well as pre-built adapters to connect to user directories, databases, and other identity services.

INTEGRATION

Oracle Data Hubs - Data Hubs synchronize, de-duplicate, enrich, and unify enterprises’ heterogeneous applications without replacing or disrupting them. Data Hubs provide a real-time, consistent, single source of truth that ensures the highest data quality across all enterprise applications and functional departments. Oracle is providing many Data Hubs: Customer Data Hub, Financial Services Accounting Hub, Product Information Management Data Hub, Financial Consolidation Hub, Universal Customer Master, Healthcare Transaction Base, and Citizen Data Hub.

Oracle Fusion Middleware for Oracle Applications - Fusion Middleware for Oracle Applications is a special package of Oracle Middleware technology components certified for Oracle E-Business Suite, PeopleSoft, and JD Edwards. It includes integration, business process management, portal, business activity monitoring, business intelligence, single sign-on, and web caching capabilities to get the most out of organizations' application investments. For enterprises that have one or more of Oracle applications, unifying the technology foundation across these applications with Fusion Middleware means streamlined support, simplified administration, and minimized maintenance that will lead to improved total cost of ownership.

Oracle Fusion Middleware for SAP - Fusion Middleware for SAP is a special package of Oracle Middleware technology for SAP customers. To bring value to SAP installations, this package SOA-enables SAP via Oracle Enterprise Service Bus, BPEL Process Manager, Web Services Manager, and Business Activity Monitoring. In addition, a bundled SAP integration adapter as well as SAP-specific integration utilities such as Oracle Portlet Factory, SAP R/3 Data Warehouse Accelerator, and enterprise-wide identity management facilitate integration of SAP R/3 and mySAP applications with other custom and packaged applications in an organization.

Oracle Integration B2B - Integration B2B extends an enterprise’s business processes to its partners via an industry-approved architecture that is standard, secure, and scalable. Integration B2B orchestrates and monitors the electronic exchange of data between partners. Its multi-protocol gateway enables inter-enterprise connectivity via CIDX, ebXML, EDI, RosettaNet, UCCnet, PIDX, VICS, and UBL.

Oracle Integration InterConnect - InterConnect is a framework that seamlessly links packaged and custom applications. InterConnect’s iStudio elevates the integration problem from a technical coding exercise to a functional modeling exercise. Oracle’s Advanced Queuing (AQ), the messaging backbone for InterConnect, provides a standard JMS interface and configurable message retention. InterConnect leverages the hub-and-spoke model of AQ to provide publish/subscribe, content-based routing, and message transformation between applications

SERVICE ORIENTED ARCHITECTURE (SOA)

Oracle Business Activity Monitoring (BAM) - BAM empowers business executives with real-time monitoring and proactive alerting of business processes. They can track key performance indicators and service levels and take corrective actions from a dashboard. Users enjoy rich and interactive dashboards built with the latest Web technology to receive real-time data and personalized reports. Optionally, configurable alerts can be sent to users via other channels such as email, fax, or phone. BAM’s architecture utilizes advanced analytics monitoring, data caching, messaging, and data integration technology to deliver requested critical information within seconds of an event.

Oracle Business Rules - Business Rules enable users to easily define flexible workflows and policies that govern business processes and application logistics without coding. It effectively reduces application modification costs and improves a system’s agility. The rule-authoring tool presents an English-like paradigm and a Web-based console for adding rules executed by a JSR-94 compliant RETE-based engine.

Oracle Enterprise Service Bus (ESB) - ESB is the heterogeneous, message-oriented common backbone for Service-Oriented and Event-Driven Architectures. It wraps any application into a service and enables standards-based binding and communication between these applications. The multi-protocol bus supports JMS, SOAP, JCA, JSR-227, WSIF, JDBC, HTTP, and FTP. It fully supports data transformation and document enrichment via XSLT or XQuery, flexible business rules, system cross referencing, and domain value mapping. ESB also supports content-based routing and content filtering.

Oracle Service Registry (developed with Systinet) - Oracle Service Registry provides a UDDI v3 compliant catalog for publishing, discovering, describing, and categorizing Web services across enterprises. It enables providers to present and advertise services; and it allows consumers to search and use them. The registry also provides enterprise-wide SOA governance and lifecycle services such as user subscription, change notification, workflows for approving published services, and quality control. The Service Registry is the system of record for all SOA information.

Oracle BPEL Process Manager (BPEL PM) - BPEL PM provides a standards-based and easy-to-use solution for integrating services and legacy systems, building loosely coupled net-centric applications, automating business processes, and orchestrating cross-application workflows. The core BPEL engine runs on any J2EE server and natively executes BPEL. The user-friendly BPEL designer, available as a plug-in to JDeveloper or Eclipse, provides wizards that simplify tasks such as connecting systems and graphically designing flows. A Web-based console allows administrators to manage, debug, and audit processes. Human workflow services provide task, notification, and worklist management. Integration services provide XSLT and XQuery transformation as well as bindings to hundreds of systems.

Oracle Enterprise Messaging Service - Enterprise Messaging Service provides a messaging architecture with maximum scalability, reliability, and performance. It integrates distributed applications via a robust standards-based solution built on JMS and J2CA. It offers in-memory, file system, or database-backed message persistence and recovery. This service also provides seamless interfaces to non-Oracle messaging solutions such as WebSphere MQ, Tibco, JMS, and SonicMQ.

Oracle Integration Adapters - Integration Adapters are specialized WSIF/JCA-based connectors that enable fast, bi-directional connectivity between the Oracle Fusion Middleware components and any data source inside the enterprise. Adapters are available for more than 300 packaged applications and databases, for technologies and protocols such as FTP and JMS, for legacy and mainframe data sources such as Tuxedo, VSAM, and CICS.

Oracle Web Services Manager (formerly Oblix COREsv) - Web Services Manager centrally defines best practice policies that govern all Web services operations such as authorization, logging, encryption, authentication, and load balancing across enterprises. It then wraps these policies around Web services without requiring modification to those services. In addition, it collects statistics and generates reports to ensure quality of service and security.

APPLICATION DEVELOPMENT

Oracle Application Development Framework (ADF) - ADF is an end-to-end J2EE framework that simplifies development and minimizes coding. With infrastructure services and design patterns designed by Oracle’s best, developers focus on the high level functionality and user experience, rather than the service implementation and business logic separation details.

Oracle HTTP Server (OHS) - OHS provides the HTTP protocol service for the Oracle Application Server. Based on the proven, open source technology of Apache, Oracle has incorporated IPv6 and application firewall capability and enhanced dynamic content generation for many languages such as Java, C/C++, Perl, PHP, and PL/SQL.

Oracle TopLink - TopLink is the #1 object-to-relational persistence architecture for productively developing Java objects with relational databases and translating between Java and XML objects. Working with any development toolset, application server, J2EE framework, and database, TopLink offers the best performance and choice.

Oracle Forms Services - Forms Services ensure that Forms applications automatically scale and perform on any network. Forms Services manage the run-time environment, provide load balancing, and handle globalization.

Oracle Containers for J2EE (OC4J) - OC4J, the heart of the Oracle Application Server, is the clusterable J2EE server. It supports all the containers, APIs, and services mandated by the latest J2EE specifications as well as advanced Web service and SOAP functionality. OC4J is easy to use and highly productive yet offers outstanding performance and reliability.

Oracle Portal - Portal provides a complete out-of-the-box solution for building and managing enterprise portals. Using Portal, end users leverage a rich, declarative environment to simplify the process of creating a customized, personalized portal web interface and publishing and managing enterprise content. Support for open standards such as JSR 168 and WSRP enables seamless, secure access to heterogeneous applications and services, through a unified, intuitive user interface.

ADDITIONAL FUSION MIDDLEWARE COMPONENTS

OracleAS Guard - OracleAS Guard leverages Oracle Data Guard for protecting the infrastructure database and OracleAS Recovery Manager for protecting middle tier configuration files. It guarantees a totally consistent and reliable standby application server for the production system. OracleAS Guard copies OracleAS binaries and configuration files, instantiates (a) symmetrical standby sites, synchronizes and verifies configuration changes, and performs switchover and failover operations with a single command.

OracleAS Java Object Cache - Java Object Cache is a powerful and flexible set of Java classes that significantly improve server performance by managing local copies of Java objects within or across processes, in memory or on local disk. It also automates object invalidation and updates.

OracleAS MapViewer - MapViewer is a Java-based visualization tool that renders maps with geospatial and location data. It provides services in OracleAS and extensions to JDeveloper that hide the complexity of spatial data queries and cartographic rendering. Developers build maps that show geographic features such as roads, display themes such as state boundaries, and visualize business data to explore relationships geographically.

OracleAS Personalization - Personalization serves content and recommendations dynamically tailored for the interests of each user. It generates behavior reports and intelligence on each user by data mining user profiles, audited transactions, queries, and hyperlink navigation.

OracleAS Web Cache - Web Cache is a state-of-the-art server acceleration, compression, and reverse proxy solution for dynamic and static Web content. It shortens response times, minimizes network bandwidth requirements, and boosts throughput rates up to 1,000s of requests/second on low cost hardware. Built-in workload management features ensure application reliability and maintain quality of service under heavy loads by balancing requests across the Grid. End-user performance monitoring features provide incredible insight into the quality of service the end user is experiencing.

OracleAS Wireless - OracleAS Wireless renders and personalizes content from sources such as email, databases, and Web sites for wireless devices like cell phones and PDAs. It develops and manages messaging applications (SMS, MMS, IM, email, voice alerts), location-based services (mobile positioning, mapping, routing), interactive voice access (VoiceXML), and mobile browser applications (WML, XHTML MP). It also provides data synchronization; transcoding and reuse of existing Internet and WAP content; application provisioning and download; and various messaging and voice gateways.

Oracle Sensor Edge - Server Sensor Edge Server offers a complete sensor-based computing infrastructure that links the physical world to enterprise systems via RFID readers and sensor devices at the edge of the infrastructure. The Sensor Edge Server manages and monitors sensors that capture temperature, pressure, status, location, etc. It also processes and relays this data to enterprise systems, and dispatches instructions to response devices such as light stacks, printers and other material handling equipment. The Sensor Edge Server also includes a sensor driver toolkit for plugging in a variety of sensors, an extensible filter framework for event processing, and a standards-based data dispatcher for guaranteed message delivery.

Oracle Service Delivery Platform (SDP) - SDP enables communications service providers and enterprises to rapidly deploy new revenue-generating voice, data and multimedia services using open standards, IP-based platform. SDP combines the market leading Oracle Fusion Middleware, Oracle Database, and new telecommunications functionality (e.g., SIP for session-based connections between nodes on an IP network; Parlay/OSA for connectivity to legacy networks) to enable new VOIP and IMS services. SDP helps communications service providers evolve legacy network investments into a modern Service Oriented Architecture and reduce the time and cost to deploy new services. SDP furthers the convergence of IT and network systems by providing a standards-based platform with carrier-grade scalability and availability, real-time performance, and connectivity to both legacy and next-generation networks.

Oracle XML Publisher - XML Publisher allows users to design their own report formats utilizing Adobe Acrobat or Microsoft Word, and XML data extracts from various sources. XML Publisher converts these report formats to XSL-FO formatted templates. At run-time, it merges the templates with the report data to create a variety of outputs that meet a variety of business needs such as HTML reports optimized for online viewing, text files formatted for EDI transmission, or PDF forms filled in with the appropriate XML data.

ORACLE BUSINESS INTELLIGENCE

Oracle Fusion Middleware’s Business Intelligence provides the complete spectrum of intelligent query and analysis capabilities. It includes interactive dashboards, proactive intelligence and alerts, enterprise reporting, real-time predictive intelligence, and mobile analytics. Insight comes from any Oracle and non-Oracle data source and extends to a broad range of executive and technical users. Oracle Business Intelligence empowers business users by delivering accurate and relevant information to the right people at the right time in the right format so they can make informed decisions and take immediate action. All of the Business Intelligence Enterprise Edition components integrate and share common metadata, security, calculation, caching, and intelligent request generation services.

BUSINESS INTELLIGENCE (BI) ENTERPRISE EDITION (Formerly Siebel Analytics)

Oracle BI Answers - BI Answers empowers users to quickly and easily author, format, and share rich, interactive, and drillable reports, charts, pivot tables, and dashboards via its self-service ad hoc capabilities. Along with a Web interface, Answers provides a logical view of information, designed with the Oracle BI Server Administrator, that simplifies the complexity of underlying relational, multi-dimensional, and XML data structures.

Oracle BI Dashboard - BI Dashboard provides knowledge workers with intuitive and interactive access to information that is actionable and dynamically personalized based on their roles and identities. Users work with live reports, charts, pivot tables, graphics, and tickers and can drill, navigate, modify, and fully interact with the results via a Web browser. BI Dashboard also aggregates content from other sources, such as the Internet and document repositories. The Briefing Book reader allows users to snapshot dashboard pages to be shared, viewed offline, or archived.

Oracle BI Delivers - BI Delivers disseminates proactive intelligence to users via email, dashboards, and mobile devices. It includes a Web-based self-service alert creation and intelligence subscription portal. It also provides monitoring and analytic workflow. BI Delivers dynamically personalizes the right content for the right users in the right way.

Oracle BI Disconnected Analytics - Mobile Analytics enables fully interactive dashboards and ad hocanalysis for mobile users. With advanced data synchronization and compression, it offers the same personalized interface and role-based security for connected and disconnected users.

Oracle BI Office Plug-In - BI Office Plug-In integrates reports from the BI Server with the Microsoft Office environment, embedding up-to-the-minute data in Microsoft Word, Excel, and PowerPoint documents.

Oracle BI Reporting and Publishing - BI Reporting and Publishing precisely controls report formatting--enabling the creation and distribution of "pixel-perfect" reports, regardless of graphical complexity. It's scalable reporting server generates and delivers reports from multiple data sources, in multiple file formats, via multiple delivery channels. Utilizing familiar tools such as Adobe Acrobat and Microsoft Office users can create their own report formats based on data extracts from various sources.

Oracle BI Server - BI Analytics Server provides sophisticated data access and processing capabilities such as caching, calculation, and aggregation that is leveraged in dashboards, ad hoc queries, intelligent interaction, and data mining.

BUSINESS INTELLIGENCE (BI) STANDARD EDITION

Oracle BI Beans - BI Beans are the sophisticated JavaBean building blocks used within Discoverer that developers can use for building custom business intelligence applications and for leveraging the rich OLAP functionality in the Oracle Database. They include presentation beans, graph and crosstab data beans, query and calculation builders, and persistence services.

Oracle BI Discoverer - Discoverer is an intuitive ad-hoc query, reporting, analysis, and Web publishing tool. It empowers users without any SQL expertise by providing a business view—designed with Discoverer Administrator—that simplifies the complexity of the underlying relational and multi-dimensional data structures. The Application Server also provides Web-based versions of Discoverer’s award-winning, easy-to-use interface—Discoverer Plus, Viewer, and Portlet Provider—that allow users to share and drill through reports.

Oracle Reports Services - Reports Services is a high fidelity, enterprise-reporting engine with unrivaled scalability and security. It provides middle-tier report scheduling and caching, as well as the ability to render reports in various types of formats and disseminate them to various types of destinations.

Oracle BI Spreadsheet Add-In - BI Spreadsheet Add-In combines the analytic power and scalability of Oracle OLAP with the familiarity of Microsoft Excel by seamlessly linking them together. End users display, drill, pivot, and analyze live Oracle data from within Microsoft Excel. Wizards guide users through the process of creating advanced queries and powerful calculations on potentially terabytes of data stored in an Oracle database.

COLLABORATION SUITE

Oracle Fusion Middleware’s Collaboration Suite is a set of messaging and teamwork applications and SDKs. They enable organizations to consolidate information, enhance communication, and teamwork-enable applications while improving service levels and total cost of ownership. The Collaboration Suite leverages the power of the Oracle database for secure, reliable, and cost effective communication between users anywhere in real-time using any device or any application.

UNIFIED MESSAGING

Unified Messaging is an enterprise-wide communications system that evolves the inbox to a new level. It delivers email, voicemail, and fax over a common network running on Collaboration Suite’s highly scalable and secure infrastructure. Delivering communications in the context of how users work, Oracle Unified Messaging provides powerful anywhere access through the Web, on the desktop, via Outlook, and to any mobile device.

Oracle Calendar - Oracle Calendar is an advanced enterprise-wide personnel and resource scheduling solution. It features contextual information: who (people, teams), what (projects), when (availability, priority),where (remote, face-to-face), why (purpose, requirement), and how (resources, tasks). Users get up-to-date calendar information and schedule conflict checking anytime and anywhere via an interactive Web portal, an easy-to-use desktop client, PDA calendar synchronization, or Microsoft Outlook.

Oracle Discussions - Oracle Discussions is an intuitive Web-based application that enables users from a Web portal or email client to participate in a running communication log. Users can post questions and responses within the structure of categories and forums. Oracle Voicemail & FaxOracle Voice Mail & Fax enables unified messaging with a single inbox for email, voicemail, and fax messages. Features include ECTF standards support, integration with a variety of PBX systems, and storage of all messages in a repository that leverages Oracle’s core strengths in scalability and reliability.

Oracle Voicemail & Fax - Oracle Voice Mail & Fax enables unified messaging with a single inbox for email, voicemail, and fax messages. Features include ECTF standards support, integration with a variety of PBX systems, and storage of all messages in a repository that leverages Oracle’s core strengths in scalability and reliability.

Oracle Mail - Oracle Mail uses the highly scalable and reliable Oracle Database to deliver and store email. Capabilities include server side filters, integration with Oracle Text, virus scanning, domain blocking, and much more. Users choose any IMAP4 or POP3 messaging client such as Netscape Messenger, Microsoft Outlook, or Mozilla Thunderbird. Oracle Mail also features the Oracle Web Access client that offers a feature rich desktop-like experience in a browser-based solution using advanced Dynamic-HTML.

Oracle Mobile Access - Oracle Mobile Access provides anytime-anywhere use of email, voicemail, calendar, address book, tasks, document repositories, and corporate directories from any device. Users listen to their email, synchronize information, browse and fax files, and perform many other functions. Users interact with Collaboration Suite via a mobile Web browser, telephone voice or DTMF touchtone commands, and SMS or instant messages. Plus, presence management allows users to determine how and when they receive notifications.

CONTENT MANAGEMENT

Oracle Workspaces - Workspaces delivers a consolidated view of all of a team or project’s collaboration. It provides easy organization and management of documents, meetings, tasks, schedules, and discussions within the scope of a project.

REAL-TIME COLLABORATION

Oracle Messenger- Messenger is a secure, standards-based instant messaging solution for the enterprise. Built on the standard eXtensible Messaging and Presence Protocol, Oracle Messenger integrates user information from an organization’s LDAP directory and enables users to find people or groups, view their availability, collaborate using message or voice chat, and exchange files instantly.

Oracle Web Conferencing - Web Conferencing enables individuals or groups to meet, interact, present, and collaborate with others via a Web browser. It provides real-time performance, efficient network bandwidth utilization, and 128-bit SSL encryption. Additional features include conference record/playback, whiteboard, desktop sharing, polling, chat, and voice streaming.

DEVELOPER TOOLS

back to top

Oracle Fusion Middleware’s Developer Tools are the most comprehensive arsenal of tools for application development and business intelligence. They support several programming languages, the latest open standards, a variety of development methodologies, and all phases of the development life cycle. For example, applications can be built using visual modeling, Java and PL/SQL coding, component or services-based development, and 4GL rapid application development. With a tool for every task and each tool rated best in class, there is no better tool suite.

PROFESSIONAL DEVELOPMENT TOOLS

Oracle Designer - Designer is a system, database, and application modeling and generation tool for architects and developers. It reverse-engineers systems, models processes, documents entire projects, generates complete applications, and provides change impact analysis.

Oracle Forms Developer - Forms Developer is Oracle’s long-established, RAD tool for building sophisticated Java client applications and UIs. Forms also provides developers with native widgets, PJC-extensible UIs, and default controls. In one step, OracleAS Forms Services configure and optimize Forms applications for the Internet without any coding.

Oracle Programmer - Programmer provides embedded SQL-style interfaces: precompilers, SQL*Module, and SQLJ. It also includes utilities, such as OTT and JPub, to generate host-language bindings from database schemas.

Oracle Reports Developer - Reports Developer’s wizard-driven approach and drag-and-drop layout editor enable users to query many types of data sources and publish intricate, high quality reports in many types of formats.

Oracle Software Configuration Manager ( SCM) - SCM is a development management system. It manages all software files and database objects for multiple projects of any size. SCM enables developers to work in virtual teams and to use any tool. It provides version and release administration, change notification and impact analysis, access control, dependency management, and object diff/merge throughout the entire development life cycle.

JAVA DEVELOPMENT TOOLS

Oracle Application Development Framework (ADF) - ADF is an end-to-end J2EE framework that simplifies development and minimizes coding. With infrastructure services and design patterns designed by Oracle’s best, developers focus on the high level functionality and user experience, rather than the service implementation and business logic separation details.

Oracle BI Beans - BI Beans are the sophisticated JavaBean building blocks used within Discoverer that developers can use for building custom business intelligence applications and for leveraging the rich OLAP functionality in the Oracle Database. They include presentation beans, graph and crosstab data beans, query and calculation builders, and persistence services.

Oracle JDeveloper - JDeveloper is a free integrated and extensible development environment with end-to-end support for modeling, developing, debugging, and optimizing Java components, database objects, Web services, and XML-based applications. JDeveloper provides assisted programming via advanced code editors and insight, and RAD development via wizards and modelers. With choices in deployment technologies and platforms, it also includes Java reverse-engineering capabilities, many third party plug-ins, and built-in links to open source tools like Struts, Ant, JUNit, and CVS.

Oracle JHeadstart for ADF - JHeadstart is a declarative, metadata-driven development tool kit, fully integrated within JDeveloper and based on Application Development Framework (ADF). Oracle Consulting collected and embedded the Model-View-Controller design pattern and ADF best practices into JHeadstart. Thus it provides phenomenal 4GL-like productivity without sacrificing the openness of J2EE. It generates complete applications with configured page flows and UIs built on ADF Faces. Further, it provides Oracle Designer with J2EE generation and migrates Oracle Forms to J2EE.

WEB TECHNOLOGY DEVELOPMENT TOOLS

Oracle Application Express (formerly HTML DB) - Application Express is a rapid Web-based application development tool. Through a hosted environment, it enables anyone with only a Web browser and limited programming experience to quickly create sophisticated, secure, and scalable Web applications that can be instantly deployed to tens or thousands of users. Built-in features such as pre-built UI templates, time saving wizards, graphical query builder, navigational controls, session state security, and Microsoft Excel spreadsheet uploading make development fast and easy.

Oracle Developer Tools for Visual Studio .NET - Developer Tools for Visual Studio . NET is a powerful add-in for Visual Studio . NET that enables . NET developers to build Oracle applications easily. Available as a free download, it includes powerful features such as designers, a schema browser, automatic code generation, a PL/SQL editor and debugger. It also provides a . NET deployment wizard to easily deploy . NET stored procedures into the Oracle Database.

Oracle Portlet Factory - Portlet Factory is an Eclipse plug-in that provides an easy-to-use portlet creation environment for Oracle Portal. Portlet Factory generates Oracle JPDK portlets and standard JSR-168/WSRP portlets that interact with SAP, PeopleSoft, and JD Edwards application data and can dynamically present themselves as stand-alone Web applications, Web services, or portlets.

Oracle XML Developer’s Kit (XDK) - XML Developer’s Kit is a set of Oracle supported parsers, processors, renderers, and utilities in Java and C/C++ for building XML-enabled applications.

Zend Core for Oracle(developed with Zend Technologies) - Zend Core delivers a stable, high performance, and supported PHP environment fully integrated with the Oracle Database and well fitted for XML and Web services.

DATABASE TOOLS

Oracle Migration Workbench - Oracle Migration Workbench is a Java-based database migration tool. With an intuitive user interface and wizards, Migration Workbench dexterously transforms non-Oracle databases, data and schema, as well as stored procedures, to Oracle.

Oracle SQL Developer(formerly Project Raptor) - SQL Developer is a new graphical tool for database development. Users browse and manage database objects, run SQL statements and scripts, and edit and debug PL/SQL. Beyond supporting all the latest features in the Oracle Database, SQL Developer offers many advanced capabilities like graphical explain plan, CSV and XML data export, code completion, and user/pre-defined reports.

ORACLE ENTERPRISE MANAGER

Oracle Enterprise Manager is the complete solution for managing Oracle environments. It provides a broad set of capabilities. Oracle Enterprise Manager is the complete solution for managing Oracle environments. It provides a broad set of capabilities to reduce the cost and complexity of managing grid computing and SOA environments. Oracle Enterprise Manager can be extended and customized for each customer’s operation environment and functional priorities with the installation of one or more Management Packs, Plug-ins, and Connectors that extend Oracle Enterprise Manager’s visibility into Oracle and non-Oracle systems and services.

DATABASE MANAGEMENT

Oracle Change Management Pack - Change Management provides database schema configuration management. It manages database evolution as changes propagate from development to production. Change Management analyzes database object dependencies and change impacts; and then, via a graphical interface and wizards, safely makes the changes. It also baselines, synchronizes, compares, and versions schemas.

Oracle Configuration Management Pack - Configuration Management centrally collects system settings and details from hosts, databases, and application servers across the enterprise. It manages a hardware and software inventory, tracks change histories for all of the systems, and monitors database feature usage. Sync/Diff utilities compare systems and allow administrators to quickly pinpoint differences and keep them synchronized. Policy management enforces enterprise-wide compliance with security and performance best practices.

Oracle Diagnostics Pack - Diagnostics Pack embeds the Automatic Database Diagnostic Monitor into the database. It deftly monitors health, automatically identifies performance bottlenecks, proactively provides alerts and event notification, and intelligently recommends corrective actions.

Oracle Tuning Pack - Tuning Pack dramatically boosts the performance of an Oracle system. It analyzes workloads and collects statistics. It optimizes storage, index, and schema configurations. At run-time, it automatically tunes and rewrites profiled SQL statements sent by any application without requiring any modification of the application.

SYSTEMS MANAGEMENT

Oracle Service Level Management Pack - Service Level Management summarizes collected metrics on the availability and performance of applications, sites, and infrastructure components across the organization. Using synthetic transactions executed from remote user locations, administrators examine services from the end users’ perspective and drill down through all the layers of the underlying IT infrastructure such as J2EE containers, Webcaches, HTTP servers, and databases. This pack enables administrators to do end-to-end system monitoring, transaction tracing, detailed service level reporting, and root cause analysis.

Oracle Provisioning Pack - Provisioning Pack simplifies software deployments. It performs tasks such as bare metal provisioning of Linux operating systems and cloning of Oracle software and databases. This pack configures tested and approved gold images from reference hosts or software libraries. With direct notifications and downloads from Oracle MetaLink, patching and updating Linux and Oracle software across the enterprise is dramatically simplified.

Oracle Configuration Management Pack for non-Oracle Systems - Configuration Management for non-Oracle Systems centrally collects system settings and details for non-Oracle components. This pack provides sync/diff utilities and policy management that baseline systems and enforce enterprise-wide compliance with security and performance best practices.

Oracle System Monitoring Plug-ins for Hosts, Network Devices, Storage, non-Oracle Databases, and non-Oracle Middleware - System Monitoring Plug-ins comprehensively collect performance and availability metrics, manage events and thresholds, and generate system reports and notifications for nearly all the hardware andsoftware components within an enterprise such as BEA WebLogic, IBM DB2, Microsoft Active Directory, and Check Point Firewall. The plug-ins extend the benefits of Oracle Enterprise Manager’s monitoring capabilities to non-Oracle components. Further, administrators can now correlate and troubleshoot problems across multiple vendors’ products.

Oracle Management Connectors - Management Connectors provide a framework based on open industry standards to enable easy integration of Oracle Enterprise Manager with third party management products such as Remedy, PeopleSoft IT Helpdesk, Microsoft Operations Manager, Hitachi JP1, and others. The integration enables collaborative management and bi-directional information exchange of deployment and run-time events.

APPLICATION SERVER MANAGEMENT

OracleAS Configuration Management Pack - Configuration Management centrally collects system settings and details from all application servers across the enterprise. It manages a hardware and software inventory and tracks change histories for all of the systems. Policy management enforces enterprise-wide compliance with security and performance best practices. Sync/Diff utilities compare middleware installations, J2EE application deployments, and application server settings.

OracleAS Diagnostics Pack - Diagnostics Pack provides performance management for Fusion Middleware. It manages events, proactively detects bottlenecks, and summarizes metrics. In addition, this pack provides transaction tracing and guided problem resolution. Using synthetic transactions executed from remote user locations, administrators examine services from the end users’ perspective and drill down through all the layers of the underlying IT infrastructure such as J2EE containers, Webcaches, and HTTP servers, as well as all of the application layers such as EJBs, servlets, JDBC, and SQL.

APPLICATIONS

Oracle Applications offer a choice of the best-in-class application modules that streamline and modernize all business operations while reducing the expense of front and back office functions. Based on a wealth of industry-specific experience and functional best practices, Oracle tailors its applications to the unique challenges and goals that drive each organization. Agile enterprises achieve better results with Oracle Applications, which offer optimal flexibility, excellent business insight, and a superior ownership experience. The Oracle Superior Ownership Experience is designed to enhance all aspects of the enterprise application ownership lifecycle—from the initial implementation and through future upgrades.

PRODUCT LINES

Oracle E-Business Suite - E-Business Suite is a fully integrated and comprehensive set of applications for large enterprises. Whether organizations implement one module at a time or the complete suite, the E-Business Suite provides the best business information for effective decision-making. The E-Business Suite is expressly built on Oracle’s Fusion Middleware and the #1 database in the market. Along with Daily Business Intelligence, the suite leverages the Global Single Database computing model to provide a complete view of the entire business across functional departments.

Oracle JD Edwards EnterpriseOne - JD Edwards EnterpriseOne is a suite of modular yet integrated, industry-specific business applications designed for rapid implementation. It is ideally suited for organizations that build, distribute, or service products or assets. Because the architecture is based on business specifications, EnterpriseOne Tools enable businesses to comfortably adjust to changing business conditions. Oracle JD Edwards WorldJD Edwards World, optimally built for the IBM iSeries platform, is a comprehensive yet low maintenance solution for small businesses. It provides a functionality-rich, Web-enabled environment for the superior management of plants, inventories, equipment, finances, and people. The applications are tightly integrated and pre-bundled on a single database to reduce implementation cost and complexity.

Oracle PeopleSoft Enterprise - PeopleSoft applications are intelligently designed for the most complex business requirements and easily configured for each customer’s unique needs. They integrate with third party and custom applications and support a choice of technology infrastructures. The user-friendly PeopleSoft Enterprise Tools innovatively transform the way organizations implement, use, and maintain enterprise software.

Oracle Retail - Oracle Retail performs and enhances all store operations—from the warehouse to the cash register—by coordinating products, processes, and people for maximum profitability. Oracle Retail’s analytics empower decision makers to know which products to sell at which location and at which price. Via intelligent personalization, Oracle also creates excellent customer experiences on all sales channels.

Oracle|Siebel - Siebel provides comprehensive customer-facing solutions that create superior customer experiences. Siebel enables organizations to optimize their people, processes, and technology around their customers to deliver outstanding business results. With Siebel, organizations intelligently interact with customers while effectively managing products, pricing, and promotions.

APPLICATION CATEGORIES

Corporate Performance Management (CPM) - CPM enables organizations to achieve outstanding performance by aligning operations and resources with strategic objectives. CPM helps executives formulate actionable plans for profitable growth, drive accountability for business results, and mitigate risk proactively by monitoring daily functions across the organization.

Customer Relationship Management (CRM) - CRM gives organizations information-driven sales, service, and marketing. With CRM, users possess the single best tool for customer success—accurate information. From precisely measuring marketing campaigns to automatically dispatching field technicians, Oracle has more than 50 CRM modules that connect consumers to providers via many interactive and effective channels for commerce and service.

Human Capital Management ( HCM) - HCM drastically enhances the entire recruit-to-retire process while ensuring each employee’s satisfaction and empowerment. HCM extensively implements all four core HR processes that maximize the value of the workforce: assess-train-develop, plan-recruit-onboard, optimize-track-monitor, and plan-incent-reward.

Financial Management - Financial Management dramatically improves the presentation, accuracy, and timeliness of business performance information and financial reports by streamlining and enforcing discipline and best practices across all financial processes.

Procurement - Procurement automates and controls employee purchasing while reducing supplier errors, lag time, and costs. It builds an efficient and flexible supply chain by enforcing policies, providing superior budget control, and building strategic relationships with suppliers.

Project Management - Project Management proactively keeps projects on budget and on time by coordinating and monitoring all projects from conception through delivery. Summarized views of projects offer drill down access to tasks and details. It also provides planning tools to streamline project execution and change-order processes as well as analytics to optimize the allocation of the right resources and funding.

Supply Chain Management ( SCM) - SCM is the core of demand-driven manufacturing and distribution that integrates and automates all supply chain functions such as order management, manufacturing, fulfillment, maintenance, and logistics. Building strategic relationships and extending supply chain business processes to suppliers, customers, and partners, SCM models sophisticated supply chain scenarios that factor in all supply/demand constraints. Then it leverages analytics to optimize supply chain performance, reduce costs of goods, and improve productivity.