Good Cloud ETL solution Tool helps in Building Complex Data Pipeline (real time and batch processing both)
May 27, 2021
Good Cloud ETL solution Tool helps in Building Complex Data Pipeline (real time and batch processing both)
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Informatica Intelligent Cloud Services
Informatica Cloud Service is used in several departments. In upcoming months we will start using it in more departments. We already had datapipeline setup using Python spark and other paid tool. But most department are migrating the data pipeline and creating good ETL model following SCD type 1,2 Load.
We are migrating most of our complex data pipeline to informatica one.
Reason to migrate is for cloud solution ETL. [The] main advantage of cloud ETL [is that] it can be more scalable and cost-effective solution: when we require more storage and more resource we can pay more, so now we can just pay for what we need.
Informatica also has wide user base so even getting the right talent is not an issue for our organization, if someone used Informatica he/she can easily start with Informatica Cloud service. In the future, the Cloud will be excellent solution for resource and cost optimization.
We are migrating most of our complex data pipeline to informatica one.
Reason to migrate is for cloud solution ETL. [The] main advantage of cloud ETL [is that] it can be more scalable and cost-effective solution: when we require more storage and more resource we can pay more, so now we can just pay for what we need.
Informatica also has wide user base so even getting the right talent is not an issue for our organization, if someone used Informatica he/she can easily start with Informatica Cloud service. In the future, the Cloud will be excellent solution for resource and cost optimization.
- Building Data pipeline in very easy (mapping and workflow section is highly configurable and mostly with all option)
- Easy debugging mode, you can backtrack and check which transformation has issue
- Easy workflow trigger using shell script, python or control-M
- Cloud base solution is future which will be very helpful for scalable solution
- Our previous solution is pure in house development, which is based on free [solutions]. So Informatica is costly w.r.t freeware.
- Sometimes team architecture is based on AWS so they are not going to switch on Informatica solution
- CONS: Not Freeware solution
- PRO: Good cost effective cloud solution
- PRO : Informatica has huge user base
Below are my comment based on 2+ year of experience in Informatica Cloud
PROS:
1. Scalable Data Pipeline
2. Easy to use Heterogeneous Databases (Multiple type of sources in Single Mapping)
3. Multiple options to configure your mapping (I have created SCD type 1,2 and 3 on multiple projects)
4. Easy to debug your mapping, debug mode simulation is there in the product.
CONS:
1. Less Documentation of any new feature (Which I faced during my initial usage)
2. No Demo video for new data source (More use documentation need to be provided)
3. In Case of new API integration faces multiple issues every time only hit and trial works.
Do you think Informatica Intelligent Cloud Integration Services delivers good value for the price?
Yes
Are you happy with Informatica Intelligent Cloud Integration Services's feature set?
Yes
Did Informatica Intelligent Cloud Integration Services live up to sales and marketing promises?
Yes
Did implementation of Informatica Intelligent Cloud Integration Services go as expected?
Yes
Would you buy Informatica Intelligent Cloud Integration Services again?
Yes
Informatica Intelligent Cloud Integration Services Feature Ratings
Using Informatica Intelligent Cloud Services
Datawarehosuing people and Analytics Team uses this
For support we have few people once product is developed there is only one team for monitoring
- Complex Data Piepline
- Easy debugging
- GUI interface
- Support of all kind of datasources
- It may scale to company level, currently it is focused on Analytics Team.