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.

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.

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

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

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

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

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

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

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.

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.

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.

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.

Integrates well with Oracle database

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

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.

Graphical definition of ETL processes and execution control Review collected by and hosted on G2.com.

Complicated transformation operations are difficult to develop Review collected by and hosted on G2.com.

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.

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

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.

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.