Oracle ETL & Data Integration

Below we give a comprehensive overview of our independent ETL & Data Integration survey of the software vendor Oracle and its portfolio of products (such as Oracle Goldengate, Oracle Data Integrator and Oracle Warehouse Builder). Oracle ETL & Data Integration scores better in our study than IBM but slightly worse than SAP. Oracle is the most developed in data management and comes out the least strong in the category master data management. We have been able to establish this objectively. Within the context of ETL & Data Integration, we have researched the pros and cons of Oracle Data Integration, and arranged them by topic (DI, extract transform load, data replication and data quality). We also display the key functionalities of the software products like Oracle Goldengate, Oracle Data Integrator and Oracle Warehouse Builder et cetera.

• Completely unbiased reviews
• Oracle ETL compared on 250+ criteria
• Used in more than 100 countries

to the ETL guide

100% independent advice on Oracle ETL. Click here to view our ETL & Data Integration study

Overall customer rating

9,3

100,0% recommends us.

Based on 33 reviews 100,0% recommends us.

Think Data, Think Passionned™

Open Table of Contents

Gather objective knowledge about Oracle Goldengate, Oracle Data Integrator and Oracle Warehouse Builder

How does Oracle ETL & Data Integration perform on certain components?

Figure 1: The pros and cons of the software vendor Oracle ETL & Data Integration. A vendor can score a maximum of 100%. Reference: the ETL & Data Integration Guide 2023. Do you need more clarification about the survey structure? Check out our buyers guide for ETL & Data Integration.

In our study we also inspected all relevant products of Oracle ETL & Data Integration software. We examined no less than 290 aspects. The image below shows compared to other ETL & Data Integration tools what the strengths and weaknesses are of Oracle Data Integration. Please note that Passionned Group is 100% independent of the software vendors in the study. We do not sell software licenses, we do not make deals or have any legal ties to the vendor. Among other things, we help and advise organizations in selecting the right ETL & Data Integration platform.

The Oracle analysis was made possible by collecting large amounts of publicly accessible data and from there it was exhaustively analyzed. More than 1,715 documents have been analyzed from Oracle since it was included in our research. In this process both algorithms as the critical eye of an experienced and independent specialist played an important role in drawing conclusions.

Oracle in our ETL & Data Integration Guide 2023

In our 100% vendor-neutral ETL & Data Integration Guide we have researched all the ins and outs of Oracle ETL & Data Integration for you. You will get access to many (short) courses, tutorials, tech talks, lectures, demos, and so on and always have the latest ETL & Data Integration news at your fingertips. In addition, this guide helps you in deepening your expertise in ETL & Data Integration. Download now.

Download now

Oracle and their complete ETL & Data Integration product portfolio

The vendor Oracle has (a minimum of) 17 products in the field of ETL & Data Integration. Based on relevance we list the products of Oracle below:

What is Oracle Data Integration?

In this part, we describe Oracle Data Integration, including some of its features and any related products. This product group consists of Oracle Goldengate, Oracle Data Integrator, Oracle Warehouse Builder, Oracle Streams, Oracle Data Integration Platform Cloud, Oracle Autonomous Data Warehouse, Oracle Data Quality, Oracle Datalens Server, Oracle Data Profiling, Oracle Metadata Management, Oracle Data Catalog, Oracle Database Replication and Oracle Data Fabric. This product can be best defined by the following functionalities:

• data infrastructure > cloud platforms
• data integration > ETL > bulk processing > bulk data
• data integration > data integration platform
• data integration > data warehouse
• data management > data sources
• data management > real time
• data quality management > data quality

Are you curious about all elements (100+) of Oracle Data Integration? Then download our ETL & Data Integration Guide™ 2023 here.

Lacking capacity and want to hire an experienced Oracle Data Integration consultant?

Do you want to hire an interim Oracle Data Integration consultant who can do a mountain of work for you and can help you to implement an Oracle Data Integration application? Or do you want to develop an application for one of the related products like Oracle Data Integrator, ODI, Goldengate and DIPC? You can do so using our interim services. Indeed, hiring Oracle Data Integration developers is not always necessary and sometimes even inconvenient. Drop a message here and we will be happy to work for you.

Figure 2, 3 and 4: Several images show the operation of Oracle Data Integration. Click on the image to magnify.

What is Oracle Goldengate?

This product is also known as: Goldengate

In this section, we describe Oracle Goldengate, including some of its features and any related products. This product / group of products can be defined by the following features:

• data infrastructure > microservice > microservices architecture
• data infrastructure > security
• data integration
• data management > CDC
• data management > big data management > big data
• data management > real time
• data management > real-time > real-time data integration
• data replication

Do you want to know everything about all characteristics (100+) of Oracle Goldengate? Then download our ETL & Data Integration Guide™ 2023 here.

Figure 5, 6 and 7: Several images show the operation of Oracle Goldengate. Click on the image to enlarge it.

What is Oracle Data Integrator?

This product is also known as: ODI

In this section, we portrait Oracle Data Integrator, including some of its features and any related products. This product / group of products can be characterized by the following features:

• data connectivity > JAR
• data infrastructure > SOA
• data infrastructure > operating system > windows
• data integration > ETL
• data integration > data warehouse
• data management > big data management > big data
• data management > real time
• data quality management > data quality

Are you now curious about all the functionalities (100+) of Oracle Data Integrator? Then download our ETL & Data Integration Guide™ 2023 here.

Figure 8, 9 and 10: Several images show the operation of Oracle Data Integrator. Click on the image to enlarge it.

What is Oracle Warehouse Builder?

This product is also known as: OWB

Under this heading, we provide a description of Oracle Warehouse Builder, including some of its features and any related products. This product / group of products can be best defined by the following features:

• data connectivity > JDBC
• data connectivity > ibm db2
• data infrastructure > operating system > windows
• data infrastructure > security
• data integration > ETL
• data integration > data warehouse
• data quality management > data quality
• metadata management > metadata

Are you curious about all the functionalities (100+) of Oracle Warehouse Builder? In that case open the ETL & Data Integration Guide™ 2023 here.

Figure 11, 12 and 13: Several images show the operation of Oracle Warehouse Builder. Click on the image to magnify.

What is Oracle Streams?

In this paragraph, we describe Oracle Streams, including some of its features and any related products. This product group consists of Oracle Streams Replication. This product / group of products can be best characterized by the following features:

• data connectivity > JAR
• data connectivity > XML
• data management > big data management > big data
• data management > real time
• data replication > database replication

Are you now curious about all the functionalities (100+) of Oracle Streams? Download the ETL & Data Integration Guide™ 2023 here.

Figure 14, 15 and 16: Overlying images illustrate the functionality of Oracle Streams. Click on the image to enlarge it.

What is Oracle Streams Replication?

In this section, we give you insight in the key behaviors of Oracle Streams Replication, including some of its features and any related products. The product Oracle Streams Replication can be best defined by the following properties:

• data connectivity > PDF
• data integration > ETL > SQL
• data integration > data integrity
• data replication > database replication

Do you want to know everything about all elements (100+) of Oracle Streams Replication? Then order the ETL & Data Integration Guide™ 2023 here.

Figure 17, 18 and 19: Several images show the operation of Oracle Streams Replication. Click on an image to enlarge it.

What is Oracle Data Integration Platform Cloud?

This product is also known as: DIPC

We do not display here all the features but, in this paragraph, we provide a description of Oracle Data Integration Platform Cloud, including some of its features and any related products. This product / group of products can be defined by the following functionalities:

• data connectivity > PDF
• data integration > ETL
• data integration > data integration platform
• data integration > data warehouse > automated data warehousing > autonomous data warehouse
• data management > big data management > data lakes
• data management > data sources
• data management > real time
• data quality management > data quality

Are you curious about all the functions (100+) of Oracle Data Integration Platform Cloud? Download the ETL & Data Integration Guide™ 2023 here.

Figure 20, 21 and 22: Various figures show the operation of Oracle Data Integration Platform Cloud. Click on the image to make it bigger.

What is Oracle Autonomous Data Warehouse?

In this paragraph, we provide a description of Oracle Autonomous Data Warehouse, including some of its features and any related products. This product / group of products can be defined by the following characteristics:

• business intelligence
• data infrastructure > security > authentication
• data integration > ETL > SQL
• data integration > data lakehouses
• data integration > data warehouse > automated data warehousing > autonomous data warehouse
• data management > big data management > big data
• data management > real time

Are you curious about all features (100+) of Oracle Autonomous Data Warehouse? Open the ETL & Data Integration Guide™ 2023 here.

Figure 23, 24 and 25: These three images give a first impression of Oracle Autonomous Data Warehouse. Click on an image to enlarge it.

What is Oracle Data Quality?

In this paragraph, we provide a description of Oracle Data Quality, including some of its features and any related products. This product group consists of Oracle Enterprise Data Quality and Oracle Product Data Quality. This product / group of products can be best characterized by the following properties:

• data connectivity > siebel
• data infrastructure > security
• data integration
• data management > data migration
• data quality management > address verification
• data quality management > data profiling
• data quality management > data quality rules
• master data management > master data

Do you want to know everything about all properties (100+) of Oracle Data Quality? Then download our ETL & Data Integration Guide™ 2023 here.

Figure 26, 27 and 28: Overlying images illustrate the functionality of Oracle Data Quality. Click on the image to make it bigger.

What is Oracle Enterprise Data Quality?

In this paragraph, we provide a description of Oracle Enterprise Data Quality, including some of its features and any related products. This product / group of products can be best defined by the following features:

• data connectivity > FTPS
• data connectivity > siebel
• data governance
• data integration
• data management > data migration
• data quality management > address verification
• data quality management > data quality
• master data management > master data

Are you curious about all the functions (100+) of Oracle Enterprise Data Quality? Open the ETL & Data Integration Guide™ 2023 here.

Figure 29, 30 and 31: Overlying images illustrate the functionality of Oracle Enterprise Data Quality. Click on an image to enlarge it.

What is Oracle Product Data Quality?

In this paragraph, we describe Oracle Product Data Quality, including some of its features and any related products. This product can be defined by the following properties:

• data infrastructure > API
• data infrastructure > operating system > solaris
• data infrastructure > operating system > windows
• data integration > data integration hub
• data quality management > data quality
• metadata management > metadata

Are you curious about all the functionalities (100+) of Oracle Product Data Quality? Download the ETL & Data Integration Guide™ 2023 here.

Figure 32, 33 and 34: Overlying images illustrate the functionality of Oracle Product Data Quality. Click on an image to magnify.

What is Oracle Datalens Server?

In this section, we provide a description of Oracle Datalens Server, including some of its features and any related products. This product / group of products can be best characterized by the following properties:

• data connectivity > XML
• data governance
• data infrastructure > API
• data infrastructure > operating system > linux
• data infrastructure > operating system > windows > windows server
• data infrastructure > security > authentication > LDAP authentication
• data quality management > data quality

Are you curious about all the functions (100+) of Oracle Datalens Server? Then order the ETL & Data Integration Guide™ 2023 here.

Figure 35, 36 and 37: Several images show the operation of Oracle Datalens Server. Click on the image to make it bigger.

What is Oracle Data Profiling?

In this paragraph, we provide a description of Oracle Data Profiling, including some of its features and any related products. The product Oracle Data Profiling can be best characterized by the following functionalities:

• data connectivity > JAR
• data infrastructure > operating system > UNIX
• data infrastructure > operating system > linux
• data infrastructure > operating system > windows
• data integration
• data quality management > data profiling
• data quality management > data quality issues
• metadata management > metadata

Are you curious about all the functions (100+) of Oracle Data Profiling? Then download our ETL & Data Integration Guide™ 2023 here.

Figure 38, 39 and 40: Overlying figures show the operation of Oracle Data Profiling. Click on an image to enlarge it.

What is Oracle Metadata Management?

In this paragraph, we provide a description of Oracle Metadata Management, including some of its features and any related products. Oracle Metadata Management can be characterized by the following features:

• business intelligence
• data connectivity > XML
• data infrastructure > SDK
• data infrastructure > operating system > windows
• data management > big data management > big data
• data management > data sources
• data quality management > data quality
• metadata management > metadata

Do you want to know the intricacies of all features (100+) of Oracle Metadata Management? Download the ETL & Data Integration Guide™ 2023 here.

Figure 41, 42 and 43: Overlying figures show the operation of Oracle Metadata Management. Click on the image to make it bigger.

What is Oracle Data Catalog?

In this paragraph, we provide a description of Oracle Data Catalog, including some of its features and any related products. This product can be characterized by the following characteristics:

• data infrastructure > API
• data integration > data warehouse > automated data warehousing > autonomous data warehouse
• data management > big data management > big data
• data management > big data management > data lakes
• data management > data sources
• metadata management > business glossary
• metadata management > data catalog
• metadata management > metadata

Are you now curious about all the functionalities (100+) of Oracle Data Catalog? Then download our ETL & Data Integration Guide™ 2023 here.

Figure 44, 45 and 46: Various figures show the operation of Oracle Data Catalog. Click on an image to enlarge it.

What is Oracle Database Replication?

In this paragraph, we describe the key elements of Oracle Database Replication, including some of its features and any related products. This product can be characterized by the following features:

• data connectivity > mysql
• data integration > ETL > SQL
• data management > real time
• data management > real-time > real-time data integration
• data replication > database replication
• data replication > replication model
• metadata management > metadata

Are you curious about all properties (100+) of Oracle Database Replication? Then download our ETL & Data Integration Guide™ 2023 here.

What is Oracle Data Fabric?

We do not display here all the features but, in this paragraph, we provide a description of Oracle Data Fabric, including some of its features and any related products. This product can be characterized by the following features:

• data connectivity > AWS
• data connectivity > JSON
• data infrastructure > API
• data infrastructure > cloud platforms
• data infrastructure > data virtualization
• data integration > data warehouse
• data integration > enterprise data fabric
• data management > real time

Do you want to know everything about all the functionalities (100+) of Oracle Data Fabric? Then download our ETL & Data Integration Guide™ 2023 here.

Three recent innovations of Oracle Data Integration-tools and the version history

Over time, Oracle has seen a negative evolution in terms of ETL & Data Integration functionality and support for operating systems, cloud platforms and connectivity. The latest added ‘gadgets’ are in the areas of data integration > ETL > bulk processing > bulk loading, data infrastructure > data transfer > file transfer > FTP file transfer and metadata management > business glossary.

We investigated Oracle’s latest updates of its product portfolio. Below you can see the structure of the various releases of the various ETL & Data Integration products of Oracle:

• Oracle Data Integrator

  :

  12.2.1.4

  12.2.1.3

• Oracle Enterprise Data Quality:

  12.2.1.4

  12.2.1.3

  12.2.1

• Oracle Goldengate

  :

  2015

  2011

• Oracle Metadata Management:

  12

• Oracle Warehouse Builder

  :

  11.2.0.4

  11.2.0.1

  11.2

  10.2

Behind each product are the version numbers, the most recent versions are mentioned first.

Can you easily determine the licensing costs of Oracle Goldengate, Oracle Data Integrator and Oracle Warehouse Builder?

It is difficult to determine exactly how much a license of Oracle Goldengate, Oracle Data Integrator and Oracle Warehouse Builder costs because it depends on the country, the number of users (also consider the amount of CPUs for server versions), the connectors to data sources, and at what point in the year you request a quote. If you do this a few weeks before the end of Oracle’s fiscal quarter, you may be in for a decent discount. As part of a cloud-first strategy, it makes sense running the software in the cloud, for the most part, you only pay for your consumption then. The purchase cost of Oracle Goldengate, Oracle Data Integrator and Oracle Warehouse Builder may not be the most important costs, but maintenance and support do return each year.

What makes Oracle ETL & Data Integration innovative

In our study, we see that Oracle in the field of ETL & Data Integration software has several specific features and thus differentiates itself from the competition. This makes Oracle Data Integration more or less unique: financial data quality, customer master data, incremental ETL, autonomous data warehouse and data matching.

The advantages and disadvantages of Oracle Data Integration

Figure 50: Tag cloud of the developed and less developed aspects of Oracle ETL & Data Integration

In the following paragraphs, we name all the pros and cons of Oracle ETL & Data Integration, Oracle Goldengate, Oracle Data Integrator and Oracle Warehouse Builder, et cetera. The listing in the following paragraphs is subject to change, because: Oracle can currently work on developing new capabilities. In addition, documentation may lag behind current events.

Your opinion matters

Leave a review about Oracle ETL & Data Integration here. Your opinion may then come into consideration in an even more sophisticated assessment of the ratings of Oracle Data Integration.

1. Oracle Data Management

93%

Oracle has an excellent score in our independent ETL & Data Integration survey of the theme ‘Data Management’ with a score of 93%, relative to other vendors. We used the following selection criteria: data sources, scheduling, real time, source table, data pipelines, streaming data and data extraction. In doing so, we analyzed the following three products: Oracle Data Integrator, Oracle Data Integration and Oracle Metadata Management. In total, we examined 71 criteria in this category. Would you like to learn more about the subject ‘Data Management’? Then download here our ETL & Data Integration Guide 2023.

2. Oracle Data Quality Management

90%

The company has an excellent score in our independent ETL & Data Integration survey on the section ‘Data Quality Management’. The company scores 90% on this topic, compared to other vendors. We looked at the following criteria, among others: business rules, data cleansing, data quality rules, address verification, data quality issues, address cleansing and data quality assessment. In doing so, we looked at the following two products: Oracle Enterprise Data Quality and Oracle Data Quality. In total, we examined 29 criteria in this category. Would you like to learn more about the subject ‘Data Quality Management’? Then download here our ETL & Data Integration Guide 2023. Or learn more about the following topics:

• The 12 biggest growing pains in becoming a mature BI organization

3. Oracle Data Connectivity

87%

Oracle has an excellent score in our objective ETL & Data Integration survey on the subject ‘Data Connectivity’ with a score of 87%, compared to other vendors. We looked at the following criteria, among others: salesforce, ODBC and apache. In total, we examined 49 criteria in this category. Would you like to go into more depth with the subject ‘Data Connectivity’? Then download here our ETL & Data Integration Guide.

5. Oracle Data Infrastructure

80%

Oracle has an excellent performance in our study on the subject ‘Data Infrastructure’ with a score of 80%, compared to other vendors. We looked at the following criteria, among others: security and open source. In total, we examined 91 criteria within this section. Would you like to go into more depth with the subject ‘Data Infrastructure’? Then download here our ETL & Data Integration Guide 2023.

6. Oracle Metadata Management

77%

Oracle has a good rating in our 100% vendor-independent ETL & Data Integration survey on the section ‘Metadata Management’ with a score of 77%, compared to other vendors. We considered the following factors: data catalog and enterprise data catalog. In doing so, we investigated the following two products: Oracle Metadata Management and Oracle Data Catalog. In total, we examined 7 features within this discipline. Would you like to learn more about the subject ‘Metadata Management’? Then download here our ETL & Data Integration Guide 2023.

7. Oracle Data Replication

69%

Oracle has a good score in our objective ETL & Data Integration survey on the subject ‘Data Replication’, given that they score 69% on this, compared to other vendors. We considered the following factors: data synchronization and database replication. In doing so, we analyzed the following two products: Oracle Goldengate and Oracle Database Replication. In total, we examined 32 criteria in this category. Would you like to go into more depth with the subject ‘Data Replication’? Then download here our ETL & Data Integration Guide.

8. Oracle Data Governance

67%

The vendor Oracle has a good score in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Governance’, given that they score 67% on this, relative to other vendors. We considered the following factors: dataops, data protection, data privacy and test data. In total, we examined 12 features within this discipline. Are you excited about the subject ‘Data Governance’? Then download here our ETL & Data Integration Study 2023.

9. Oracle Self-service Integration

42%

The vendor Oracle has a moderate score in our independent ETL & Data Integration survey of the theme ‘Self-service Integration’, given that they score 42% on this, compared to other vendors. We looked at the following criteria, among others: self-service data preparation, self-service data integration, self-service data warehouse and self-service data management. In total, we examined 8 criteria within this section. Would you like to learn more about the subject ‘Self-service Integration’? Then download here our ETL & Data Integration Guide.

10. Oracle Master Data Management

36%

The company has a moderate rating in our independent ETL & Data Integration survey on the subject ‘Master Data Management’ with a score of 36%, relative to other vendors. We looked at the following criteria, among others: location data and master data replication. In total, we examined 17 criteria in this category. Would you like to become more proficient in the subject ‘Master Data Management’? Then download here our ETL & Data Integration Guide 2023. Or learn more about the following topics:

• The top 7 BI trends, big data trends & AI trends of 2023

The footprint of Oracle ETL & Data Integration in different sectors

In our vendor-neutral ETL study, we also looked at which industries a supplier operates in. These are the industries where Oracle has the largest footprint: airlines, banking, energy, financial services, health care, health insurance, insurance, public sector and retail.

Hire Oracle consultant

Training and courses Oracle ETL & Data Integration

The specialists of Passionned Group organize various classes in the area of ETL & Data Integration but can also provide specific Oracle training, for example as incompany. Then think about the following software: Oracle Goldengate, Oracle Data Integrator and Oracle Warehouse Builder. Of course we frame the training with the ideas of the intelligent, data-driven organization.

Final assessment: Oracle Data Integration scores high

Oracle has a extensive product portfolio with which it scores high in our ETL & Data Integration survey. Oracle ETL & Data Integration innovates (approximately) at an average rate of less than 5 features per year, is active (for now) in many different sectors, and has developed best in data management.

About Passionned Group

Passionned Group specializes in 100% independent ETL & Data Integration consulting and the implementation of ETL & Data Integration solutions. Our driven and passionate consultants help large and small governments and businesses to advance as a smart, data-driven business.

Get in touch with us