Oracle Data Integrator

ODI is a complete product in terms of data transformation tools.

주석: Mainly performance.
Reliability and robustness
An endorsement of a brand.
flexibility
Ability to integrate with other tools

장점:

Some benefits of the product are the capacity of integration with multiple sources of data, using connectors. It supports a wide variety of data sources and destinations. It has robust qualities such as programming of transformation tasks, as well as the tracking of said processes. ODI has precedents in terms of performance, that is, if the priority of an organization is the processing of information volumes, having at hand a robust but flexible tool then ODI is a great option. The way in which ODI is built in its architecture, allows changes to be made quickly, with ease from a technical perspective but with a great impact for business areas. ODI offers a really competitive tool to integrate with 3rd parties sources such: IBM DB2, Teradata, Sybase IQ and another protocols like plain text files, ERP, LDAP and XML.

단점:

Access to documentation, but is rewarded by the wide range of courses offered by Oracle to specialists in the area

Best data integration platform

주석: We are one of the largest telecommunication services provider in Asia. We have a multi-million customer base. So the Big data team wanted an ETL tool which can manipulate the high volume of data with high performance. After long research, we chose ODI. We have installed the ODI in a clustered environment. Basically it runs on top of the Oracle Weblogic Server. However, install installation was quite hard. But we were able to manage that. We could able to interface ODI with hundreds of supported data sources. Finally, I can say this the best and most advanced ETL tool I have ever worked.

장점:

+Support thousands of data sources. +Deployment time could be cut down +Can be interface with many 3rd party tools. +High performance and flexibility.

단점:

+Implentation is hard. +Not supported on Solaris OS. + Lack of community support. +High license cost.

It's very heavy product to use, implementation and troubleshooting makes cumber-sum for the users.

장점:

In latest version it comes up with integrating with Oracle Service Oriented Architecture services, and vice versa and it enables users to automate end to end business functionality across the products.

단점:

Not easy to use, requires proper understanding on the tool how it works and also requires more resources

Oracle Data Integrator - My Choice

주석: My over all experiences about the product is a great. It's complete on my quality.

장점:

Yes, It's amazing data integration tool for new customers. It's easily connect to many database like MySql, SQL Server etc. It's completely user friendly. We can easily manage to packages, ETL and Procedures. Over all very good data mearging tool.

단점:

We can easily create the ETL and schedules. We can check logs on daily basis.

A complete ETL for DWH and EPM tools

장점:

ODI allows to choose where collocate the trasformation area (Source, Target or other). ODI has so many connectors for the main data sources / destinations. ODI allow to customize the behavior the own connectors

단점:

Very few update for connectors. Very high pricing if not in bundle with other products. SAP connectors very expensive and hard to use

Best World class solution for integrating data from many sources

주석: In general, my experience was great. I created Knowledges Modules based in templates, interfaces, scenarios, etc. and the data integration from may source was possible thanks to ODI.

장점:

Flexibility with the Knowledge Modules, besides the available tools in Designer for building my interfaces; the experience was really great.

단점:

I worked in version 11g, the audit module wasn't too clear sometimes. It was a little hard for debugging failed instances

Oracle Data Integrator 11g

장점:

Its capacity to store,maipulate and processing the data, It is helpful to process huge amounts of data.

단점:

It is a bit slow, I would rather recommend a newer version ODI 12 c which is much easier to use.

A great tool for moving and transforming data

장점:

This product is very robust and has so many features to move and transform data. Once set up, it is very easy to grab data from many different sources. Allows us to group data ETL processes by project and automate the transfers

단점:

The product is quite confusing to use. lots of small parts that need to be set up in the right order. I found added Oracle packages to the mappings wasn't as straight forward as I would have liked.

Define and Integrate

장점:

Trainings and tutorials of Oracle Data Integrator can be found easily and doesn't need an IT expert to do the work. All can be tested in a virtual environment too. Recommended for small or medium businesses but for big projects like defining what data you have and understanding the process of integration. The results are easy for the management to have the helicopter view.

단점:

Oracle Data Integrator can be used for spesific tasks and projects. No free or trial versions are available.

An excellent ETL tool, deeply integrated with Oracle solutions

주석: I will definitely use it again

장점:

It is a very powerful tool, deeply integrated with the Oracle world. Very often it is inserted in solutions such as BI

단점:

the price is not very low so its adoption must be carefully evaluated

Scalabile e flessibile

주석: In diverse realtà con la necessità di integrare dati complessi da varie fonti e destinazione abbiamo proposto e settato l’uso di Oracle Data Integrator. Una volta installato e settato il tutto, operazione non banale, gli utenti hanno potuto accedere velocemente a tutte le loro informazioni, con gran soddisfazione.

장점:

Oracle Data Integrator è una piattaforma di integrazione dati che offre un’architettura flessibile e scalabile e che permette di eseguire processi ETL su vari sistemi distribuiti, riducendo il carico di lavoro e migliorando l’efficienza. Data Integrator utilizza un approccio di elaborazione “set-based” per ottimizzare le prestazioni e questo consente di elaborare una grande quantità di dati in modo veloce e ridurre il processo di esecuzione del ETL. Io software, inoltre, integra una buona funzione di gestione degli errori che permette agli utenti di identificare e risolvere velocemente i problemi.

단점:

Il processo di installazione e configurazione iniziale richiede molto tempo ed il software, per utenti poco esperti, può risultare complesso da usare.

Ottimo strumento, facile da usare e funziona sul cloud

주석: Sono soddisfatta dell’esperienza con ODI. Li sto usando principalmente per traferire i dati dalla piattaforma big data al data-warehouse dell’azienda.

장점:

Oracle Data Integrator è uno strumento user-friendly con molte possibilità per sviluppatori e analisti di dati. È semplice da usare per l'integrazione e la migrazione dei dati tra diverse fonti.

단점:

Vorrei che ci fosse un modo più semplice per migrare gli scenari di ODI 11g alle nuove versioni di ODI 12c.

We use ODI to for our data warehouse.

주석: ODI is much better and faster tha OWB and it can connect to any RDBMS and we can use any programming language to communicate with ODI

장점:

We converted our datwarehouse from OWB to ODI. ODI is faster than OWB. Learning curve was easier and lots of resources available online and the Oracle team was really helpful .

단점:

cloud Services were down without informing us. Uploading binary files to ODI was not easy and we had to raise a service request and use the sqlplus for loading the binary file. SCD's are handles differently in ODI than OWB.

Good

장점:

Easy to load the data including text, CSV or XML file

단점:

Too much effort to implement the code in higher environment, It can be made user friendly

Oracle data intigrator

주석: Over all it’s a bit of a hassle to use as it has many approval processes

장점:

The bulk upload by the admin and the capability of users to be given specific admin rights to update their own changes

단점:

Intigrating issues some after approval has not changed in the system

It's complicated but it gets the work done

주석: It's amazing when you have the power to aggregate data and make decisions from the aggregated data. This software truly is amazing, once you get past the learning curve.

장점:

It's not as intuitive as I would like, but it gets the work done

단점:

It's not as intuitive, but it's extremely powerful

Oracle Data integrator

주석: It's good tool

장점:

It's good ETL tool and easy to define mapping and fetch the data.

단점:

Need some drag and drop features for objects and qualifier we use in comparison to other ETL tools.

Excelent Software

장점:

Flexible, easy to use, learn and work in it, I like the way you get to customize it, it has out of the box connectors that make your life easier

단점:

The use of the ODI studio, because it is slow and you end up without RAM and it force you to restart the program and that makes your work slow

Standard Data Integration

주석: Decent entry into the data integration landscape

장점:

It provided the basic levels of functionality associated with data integration. The functionality is best associated with Oracle-related data sources.

단점:

The product is somewhat too tightly aligned with the Oracle platform

Oracle service is lacking

주석: I have used the Data Integrator on a regular basis, and have had nothing but issues with the service team. Rumor has it that in 2017 service will be a premium, paid feature. No thanks!

장점:

Integration with Oracle products

단점:

Lack of support from Oracle.