Leader in ETL tools
Pros
- Bulk API is very fast
- Smart lookup to relate reference records
Cons
- More descriptive errors
Return on Investment
- Seamless integration
Alternatives Considered
Dell Boomi
Other Software Used
Quip
What is Informatica Intelligent Data Management Cloud?
The Informatica® Intelligent Data Management Cloud™ (IDMC) is designed to help businesses efficiently handle the complex challenges of dispersed and fragmented data to innovate with their data on virtually any platform, any cloud, multi-cloud and multi-hybrid.
Categories & Use Cases
ETL tool at its best
Pros
- Transfer data between system, volumes are not the issue
- Keeps different system in sync to support sales
Cons
- Fredlier front end, with more click and drag functionalities
Return on Investment
- Keeps data up to date, which provides accurate data to sales reps which in return help in sales
Alternatives Considered
Cloudingo and Informatica B2B Data Exchange
Other Software Used
Microsoft Access, Devart ODBC Driver for Oracle, Devart ODBC Driver for Salesforce
Informatica Cloud is a must for any organization that uses Salesforce
Pros
- First and foremost is its capability of integration
- Secondly, the transformation is just so simple
- It has everything which you need to start from scratch and deploy in the cloud.
Cons
- Incremental jobs can run very slowly on large table updates. Incremental jobs do not work at all for Salesforce.com history tables.
- No real ability to report on what jobs you have set up or the performance of those jobs (failures, number of records copied, etc.).
- It is only available within the user interface and you basically have to copy paste it from the browser if you want the information.
Return on Investment
- 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.
Other Software Used
Dell Boomi
Professional ETL Tool to handle large data
Pros
- It provides near real time data replication.
- All the transformations are simple and easy to implement.
- It serves the purpose of eliminating the duplicate data and saving a lot of time in batch processes.
Cons
- 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.
Return on Investment
- Handling large volume of data quickly is saving a lot of time.
- Outcomes of the processes have been tremendously improved.
- Decision Making has also been improved to some extent.
Other Software Used
AWS CloudHSM, Informatica Data Quality, Tableau Desktop
Fantastic platform to handle large volumes of data
Pros
- Fairly easy to use multiple databases.
- User Interface is very easy to understand even for a person with non-developer background.
- Seamless updates provided by the company.
- Debugging, scheduling, and monitoring the jobs is very easy in this tool.
Cons
- The new features come with limited documentation.
- Implementing a new API is bit complex.
- Sometimes the application freezes.
Return on Investment
- Created internal process efficiencies.
- Improved the outcomes of business process[es].
- Handling the real time data opens up the opportunity to reduce the time to market
Other Software Used
AWS Chatbot, Google Cloud SQL, Informatica Data Quality
