Oracle has long been the largest RDBMS vendor and is today a global provider of enterprise cloud computing, offering software as a service, platform as a service, infrastructure as a service and data as a service capabilities. The company employs more than 138,000 people worldwide. With over 430,000 customers and deployments, Oracle offers a comprehensive stack of cloud applications, platform services and engineered systems.
Oracle’s data management strategy is based on meeting its customers’ requirements in five areas: access to any source of data, location independence (on premise or in the Cloud), maximum availability and reliability, real-time data access and data quality.
The data integration offering consists of several included products, called Oracle Data Integrator. Today Oracle Data Integrator is the strategic product and Oracle Warehouse Builder is not supported any longer. The platform includes three major components: Oracle Data Integrator Enterprise Edition for ELT on any database, Oracle GoldenGate for real-/near time integration and replication and Oracle Enterprise Data Quality. The components are integrated on shared services implemented on a SOA layer including a business process engine and enterprise service bus, also functionality for data federation.
The Data Integration product itself produces native SQL code that can be adapted by the developer. Oracle has added market-leading components from Datanomics (for Data Quality) and GoldenGate (for real-/near-time replication) to their product. They have tight integration with Oracle applications and Business Intelligence products . Oracle provides an interesting concept for building ELT jobs: Knowledge Modules (KMs), which are defined as SQL snippets that include processing or connectivity logic, can be used. The developer can choose these KM modules and adapt them very easily by simply customizing the SQL code.
In the development support area, we see less functionality than is offered by Oracle’s direct competitors in the market. The Metadata Management functionality is very developer-centric and limited. With regard to licensing, we see that the user has to license the CPUs of the target databases, which could be a limitation in the flexibility and customization of the pricing. Virtual machines are currently not supported.
The Oracle Database is widely known for its robust capabilities and stability but also for its broad optimization options.
User & Use Cases
Besides data integration (75 percent), customers mainly use Oracle Database for enterprise data warehousing (59 percent) and data marts (59 percent). 47 percent of respondents use it for data warehouse automation, 44 percent for master data management and 41 percent for data preparation. Oracle database targets mid-sized companies and large corporations across all industries. 56 percent of our sample come from large companies (more than 2,500 employees) with a median of 300 users, but the mean of 2144 users indicates there are also some significantly larger implementations.
Respondents point out that a quarter of the employees is using the Oracle Database. This is a high number and shows its wide usage in companies. Indeed, not only specialists in the IT work with the database but also tech-savvy power users in business units perform SQL queries for data analysis purposes.
Percentage of employees using Oracle Database
Number of users using Oracle Database
Company size (number of employees)