Oracle Data Integrator Reviews & Product Details

Oracle Data Integrator Overview

What is Oracle Data Integrator?

Oracle Data Integrator (on-premises & Cloud Service) - a high-Performance Bulk Data Movement and Data Transformation. Delivers unique next-generation, extract load and transform (ELT) technology that improves performance and reduces data integration costs—even across heterogeneous systems. o ELT architecture for improved performance and lower TCO o Heterogeneous platform support for enterprise data integration o Knowledge modules for optimized developer productivity and extensibility o Service-oriented data integration and management for SOA environments Link - https://www.oracle.com/middleware/data-integration/enterprise-edition/ Datasheet – http://www.oracle.com/us/products/middleware/data-integration/odi-ee-ds-2030747.pdf Documentation https://www.oracle.com/technetwork/middleware/data-integrator/documentation/index.html#11.1.1.5 Webcast Supercharge your data integration DIPC https://event.on24.com/eventRegistration/EventLobbyServlet?target=reg20.jsp&referrer=https%3A%2F%2Fwww.oracle.com%2Fmiddleware%2Fdata-integration%2Fenterprise-edition%2Fresources.html&eventid=1545759&sessionid=1&key=E89B634077F2FF8700223E6E1A49A54E&regTag=&sourcepage=register

Oracle Data Integrator Details
Languages Supported
English
Product Description

Oracle Data Integrator Cloud Service provides pushdown data processing; high performance ETL with less data movement which is best for the Cloud. Oracle Data Integrator Cloud Service executes data transformations where the data lies without having to copy data unnecessarily to remote locations.


Seller Details
Seller
Oracle
Ownership
NYSE:ORCL
Company Website
Phone
+1 (650) 506-7000
Year Founded
1977
HQ Location
Redwood Shores, CA
Total Revenue (USD mm)
$39,506
Twitter
@Oracle
778,474 Twitter followers
LinkedIn® Page
www.linkedin.com
186,456 employees on LinkedIn®
Description

Oracle Corporation develops, manufactures, markets, hosts, and supports database and middleware software, applications software, and hardware systems.

Show More
Answer a few questions to help the Oracle Data Integrator community
Have you used Oracle Data Integrator before?
Yes

Oracle Data Integrator Reviews

Write a Review
Filter reviews
LinkedIn®
Connections
Popular Mentions
Showing 17 Oracle Data Integrator reviews
Popular Mentions
Showing 17 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
For Category
All Industries
Region
Already have Oracle Data Integrator?
Write a Review
Project Engineer
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Code development and administration is easy. It is powerful and can connect to most databases and systems. Easy access and easy load for complex data based in xml for web service-based integrations. Review collected by and hosted on G2.com.

What do you dislike?

It might be possible to improve user experience. Code services migration and version control can also be improved and streamlined for individual components due to numerous development items. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Is a good and powerful data integration tool because we can write in procedures jython code. The software is resuctable and easy to use. Version control approach in multiple environments should be properly defined. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Has comprehensive data integration capabilities for real-time and batch designs. The ability to write code for jython and to manage code is excellent. If the user experience for the tool is improved, it would be great. It would be easier for developers to work if the tool itself was faster. Review collected by and hosted on G2.com.

Show More
Show Less
Business Operations Manager
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Oracle is incredibly easy to use and integrates perfectly with so many software programs. It's the perfect go between to connect and simplify programs. Review collected by and hosted on G2.com.

What do you dislike?

Oracle definitely requires a certain skill level to understand and manipulate. It could be made more intuitive. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Oracle helps me connect multiple apps and keeps data seamless across them. Review collected by and hosted on G2.com.

Show More
Show Less
Instructor
Information Technology and Services
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Oracle Data Integrator (ODI)is a good ETL tool for integrating data from Oracle and SQL Server. Review collected by and hosted on G2.com.

What do you dislike?

It's not for novice users. Reporting requests have to go through IT support. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

No major problems. Review collected by and hosted on G2.com.

Show More
Show Less
UE
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

This is an easy system to use and or integrate with other third parties! Easy to navigate after set up as well. Review collected by and hosted on G2.com.

What do you dislike?

The initial time it took to set up and go live was much too longer. Need more info to start off with and better guidance from the reps. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We load all of our data as well as customer information into Oracle. Review collected by and hosted on G2.com.

Show More
Show Less
IA
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Easy to use. Works with the cloud services. I like the data integration. I like that it can be monitored from a single solution along with other Oracle technologies and applications. Review collected by and hosted on G2.com.

What do you dislike?

Nothing really. I am still new to the product. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

All problems are being solved Review collected by and hosted on G2.com.

Show More
Show Less
UF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Odi is user friendly tool with lot of possibilities for developers and data analysts. It is simple for data integration and migration between different sources. Review collected by and hosted on G2.com.

What do you dislike?

I would like that there is a easy way to migrate odi11g scenarios to new versions of odi12c. Everything else is ok :) Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I am using ODI for etl and for data transfer from Big data platform to datawarehouse. Review collected by and hosted on G2.com.

Show More
Show Less
EB
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

It is ability to create native code for the underlying data management technology. Flexibility of adding new technology stack by writing custom knowledge modules. Review collected by and hosted on G2.com.

What do you dislike?

In 11g it was difficult to create multi step transformation logic. 12c is addressing this gap. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are using ODI 12c to integrate data from disparate sources and populate both our new newly developed data warehouse and data lake environments. Review collected by and hosted on G2.com.

Show More
Show Less
UF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

I best like about it is that it is ELT ( moving transformation to Source instead of Middleware.

Supporting many technologies Review collected by and hosted on G2.com.

What do you dislike?

It is only SQL based language . Very difficult to code procedural.

Create $ tables for every run which slows down the data base Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Loading data from source to target and doing heavy transformation Review collected by and hosted on G2.com.

Show More
Show Less
EB
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

easy to use and in our market there are many developers so easy to maintain Review collected by and hosted on G2.com.

What do you dislike?

it first loads and needs the database to transform Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

it is the backbone for our datawarehouse Review collected by and hosted on G2.com.

Show More
Show Less
AM
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
What do you like best?

Oracle data integrator offers a graphical environment to build, manage and maintain data integration processes easily. Review collected by and hosted on G2.com.

What do you dislike?

Little hard to debug connector issues and nice to have better documentation. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

ODI has wide Varity of connectors which helps business Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Oracle data integrator provides wide variety of connectors for various data sources and it helps with extract, load and transform easily across the business Review collected by and hosted on G2.com.

Show More
Show Less
CF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

easy integrate with many sources and give flexbility Review collected by and hosted on G2.com.

What do you dislike?

performance very slow when dealing with files loads.especially xml files Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

more with big data Review collected by and hosted on G2.com.

Show More
Show Less
Especialista de base de datos y Middleware
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

ODI has been used lately in our company to develop some ETL's needed for data consolidation from diferentes rdbms. It works very well with sqlserver, mysql and of course with Oracle. It is a very powerfull tool with tons of options. en Review collected by and hosted on G2.com.

What do you dislike?

It's too hard to learn, trainning is definitly needed and is very expensive and long. Deploying then nfrastructure is not an easy ask either. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data consolidation for reporting purposes. Review collected by and hosted on G2.com.

Show More
Show Less
AW
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Changed information from DB2, SQL Server and other Oracle databases into level records and afterward utilized ETL occupations to stack into Oracle DB target. Review collected by and hosted on G2.com.

What do you dislike?

Still unpredictable item to use for ETL designers. Required parcel of preparing and testing before it could be executed underway information transformation. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Microsoft SQL Server Integration Services (SSIS) Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Oracle to SQL Server & Others remote database Data integration. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Integrates well with Oracle database

Integrates well with all Oracle set of tools including Hyperion applications Review collected by and hosted on G2.com.

What do you dislike?

There are better ETL tools in market e.g. Informatica

If you are working with multiple databases I would recommend to go with Informatica Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you are working with only Oracle databases this would be the good fit Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

ETL Review collected by and hosted on G2.com.

Show More
Show Less
Responsable DataWarehouse
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Definición gráfica de procesos ETL y control de ejecuciones Review collected by and hosted on G2.com.

What do you dislike?

Las operaciones de transformación complicadas son difíciles de desarrollar Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Buen producto visual de ETL Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Realizamos una prueba de concepto para sobre todo el control de errores en las cargas Review collected by and hosted on G2.com.

Show More
Show Less
AI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Easy to learn and use. As an administrator it very easy to customize. It can transform and load large amoyof data. Review collected by and hosted on G2.com.

What do you dislike?

Data Security is not very user friendly . Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We use it to transform data from legecy system to the new system. Review collected by and hosted on G2.com.

Show More
Show Less
IG
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

It's easy to use, with drag and drop to build out the package and ELT flow. For staff who knows PLSQL, it's not hard for them to pick up ODI. Our enterprise project has been using ODI for nearly 3 years now. Review collected by and hosted on G2.com.

What do you dislike?

It doesn't provide the near real time data replication function similar to OGG (oracle golden gate), but the scheduled jobs in ODI is still pretty neat. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Doing ELT and ETL process to bring data from MS server database into Oracle databases. Review collected by and hosted on G2.com.

Show More
Show Less