Informatica Intelligent Data Management Cloud vs. Oracle Data Integrator (ODI)

Informatica Cloud is an excellent tool for freeing up trapped data in your internal systems and exporting it into a cloud data warehouse or SQL container. Especially if you have any internal SQL query generators that allow you to copy and paste into the Source setup. For example, we use Business Objects internally, and you can build out the query you need inside the firewall with that, then paste it into the query within Informatica Cloud while establishing the Source connection. This way you are not writing all your source parameters by hand, cutting new jobs setup time by 50%. Where Cloud will not suit you well is if you need significant visibility to the health of the system from a tracking, monitoring or error handling standpoint. Cloud will tell you it failed, maybe give you an example error, but has no further troubleshooting or diagnostic assistance to offer.

Incentivized

I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator. 1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc. 2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools. 3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations. 4. Speeds up the development and maintenance by reducing the code that developers need to write

Incentivized

• Informatica Cloud is a great tool for automating data imports. Raw data files can be scheduled to run at designated times, and using pre-built mappings ensures that the data goes into the system accurately each time.
• It is also a great tool for converting raw data into specific formatting. For example, configuring the mapping so that the first letter of a first, middle or last name is always capitalized.
• Additionally, Informatica Cloud has a built-in field-matching tool so that records that already exist are updated rather than having duplicates created.

Incentivized

• Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
• Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
• Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.

Incentivized

• The User Interface can be a bit difficult to get in initial stages.
• Error messages are hard to understand which sometimes takes a lot of time for the resolution
• Cannot Implement complex SQL queries which should be fixed in future release.

Incentivized

• Oracle support is not the best when needing help with the system
• The documentation is also very poor and takes very long to generate
• Some parts of it are not intuitive to use and get hard to troubleshoot
• Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
• Like all Oracle products, cost is high

Incentivized

It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.

I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.

Incentivized

Having used SQL Server Integration Services (SSIS) in the past, Informatica Cloud was a huge-step up in functionality, usability and performance. Hands-down, Informatica Cloud is a much more robust product overall. While SSIS is well-suited for specific instances (i.e. SQL Server-specific implementations), Informatica Cloud is a much better product as an overall integration/transformation tool.

Incentivized

Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software.

Incentivized

• A positive impact is bringing more projects.
• Getting data out of various systems such as Salesforce.com or FTP and consolidating it into tables in one central database.
• Having the ability to run data transformation tasks (the equivalent of batch jobs in SF or stored procedures in SQL) on a schedule without consuming those resources on the target or source systems.

Incentivized

• Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes.
• Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment.
• Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money.

Incentivized