Informatica Intelligent Data Management Cloud Reviews & Insights

Score7 out of 10

44 Reviews and Ratings

Community insights

TrustRadius Insights for Informatica Intelligent Data Management Cloud are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Business Problems Solved

Informatica Cloud Data Integration Suite has been highly valued by clients for its seamless integration between various systems and platforms. One key use case involves integrating data between Infor ERP and Salesforce CRM, solving the common business problem of connecting a legacy system with a modern CRM platform. It has successfully facilitated the asynchronous transfer of data, ensuring that both systems are synchronized and meeting the organization's requirements effectively. Another use case involves using Informatica Cloud to process large volumes of data, such as 100K records daily, enabling teams to solve customer problems by transferring and updating data from SAP to Salesforce. This integration has proven instrumental in supporting reporting and analytics, allowing for better decision-making based on accurate and up-to-date information.

Additionally, Informatica Cloud has been utilized to integrate data between Oracle financial systems, Salesforce.com, and internal transaction processing systems. By eliminating the need for maintaining server infrastructure, this solution has streamlined the data integration process while supporting internal gateways for data movement and extraction. Moreover, Informatica Cloud has enabled efficient extraction of data from internal systems as well as external CRM tools like Salesforce. This capability allows organizations to leverage the power of business intelligence tools and personalize their websites based on valuable insights gained from integrated data sources.

Furthermore, Informatica Cloud has been successfully integrated with various platforms such as TargetX SRM and SalesForce.com, enabling departments like the Office of Admission to import crucial data into their CRM through built-in data mappings. Similarly, it has played a vital role in extracting, transforming, and loading data for analyzing insights from digital transformation efforts specifically catering to small to mid-sized firms. In terms of enhancing overall data integrity and improving tracking capabilities within Salesforce, Informatica Cloud is used daily by organizations to import new contacts and leads. This facilitates better management of customer relationships by eliminating duplicates and ensuring consistent and reliable data across the system.

For departments dealing with large volumes of data, Informatica Intelligent Cloud has proven to be a valuable tool. Its user-friendly interface and ability to make data actionable for non-technical users have made it an effective solution, particularly in supporting Salesforce integration. Furthermore, Informatica Cloud Services has been widely adopted by multiple departments for ETL processes. This service ensures the easy extraction, transformation, and loading of a significant amount of data, including real-time transaction data.

Overall, Informatica Cloud has been well-received due to its ability to fetch data from multiple sources and store it in a single destination datalake. This feature has greatly simplified the data integration process, making it more efficient and enabling organizations to centralize their data for better accessibility and analysis. The scalability, cost-effectiveness, and availability of talent have also been key factors in the adoption of Informatica Cloud. Many departments have found it to be a scalable solution that can handle their growing data needs without compromising performance. Its cloud-based nature eliminates the need for extensive server infrastructure, resulting in cost savings for organizations. Additionally, with a wide range of resources and expertise available in the market, teams have found it easier to find skilled professionals who can effectively use and leverage Informatica Cloud.

One notable use case involves the Technology department, which utilizes Informatica Cloud to connect multiple Cloud SaaS solutions to both internal and cloud-based data platforms. This integration has provided seamless data flow between various systems, enabling better collaboration within the organization and enhancing overall operational efficiency.

In conclusion, Informatica Cloud Data Integration Suite offers a range of valuable use cases across different industries and business functions. From integrating legacy systems with modern CRM platforms to facilitating efficient data transfers between multiple applications, it has proven itself as a reliable solution for streamlining data integration processes. With its ability to handle large volumes of data, support real-time transactions, and provide centralized data storage options, Informatica Cloud empowers organizations to make informed decisions based on accurate and up-to-date information from disparate sources.

Informatica Intelligent Data Management Cloud Reviews

13 Reviews

Good Cloud ETL solution Tool helps in Building Complex Data Pipeline (real time and batch processing both)

Rating: 8 out of 10

Incentivized

May 27, 2021

Use Cases and Deployment Scope

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.

Pros

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

Cons

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

Likelihood to Recommend

If your company does not have a scalable ETL solution, the current data pipeline is just data migration using my SQL or python API, you should switch to a good ETL solution - you can achieve [this with] Informatica Intelligent Cloud Services.
[Well suited] if you want to use good data warehousing concepts in your practical warehouse, no hardcore developer is required. Ease in debugging.

In the future (next 5 Years) most process will be setup on cloud base solution. Reason of cloud solution is [it's] flexible resources, pay for what you use, no in-house storage processing required, and the availability of talented people in [the job] market [who know] Informatica.

Verified User

Analyst in Information Technology (5001-10,000 employees)

Vetted Review

2 years of experience

Professional ETL Tool to handle large data

Rating: 8 out of 10

Incentivized

May 20, 2021

Use Cases and Deployment Scope

Informatica Intelligent Cloud is an awesome tool that is being used in specific departments of the organization where the data volume is huge. This helps a lot in making the data actionable by the non technical users. Also, this supports Salesforce integration which was the main business purpose and is very cost effective.

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.

Likelihood to Recommend

This tool is very well suited for mid and large sized organizations to handle large volume of data especially if you want to migrate your data to Salesforce. This is one of the most cost effective tool available in the market.

Verified User

Analyst in Information Technology (5001-10,000 employees)

Vetted Review

2 years of experience

Fantastic platform to handle large volumes of data

Rating: 9 out of 10

Incentivized

May 8, 2021

Use Cases and Deployment Scope

Informatica Cloud Services tool is being used in certain departments of the organization. This product has the immense capability to ETL (Extract, Transform, and Load) a huge amount of data very easily and also is really helpful for real-time transaction data. We can easily fetch data from multiple sources and store them in a single destination datalake.

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.

Likelihood to Recommend

Informatica Intelligent Cloud tool is very well suited to handle large volumes of data and it supports a great variety of data connections for the purpose of fetching and loading the data. Also, handling the real-time data is fairly simple in this tool along with lots of transformation options available.

Verified User

Employee in Information Technology (10,001+ employees)

Vetted Review

3 years of experience

Leader in ETL tools

Rating: 9 out of 10

Incentivized

January 18, 2020

Use Cases and Deployment Scope

Informatica Integration Cloud is being used by my department, which currently processes 100K of data each day. Data is sent to our employees, which helps us to solve customer problems.

Pros

Bulk API is very fast
Smart lookup to relate reference records

Cons

More descriptive errors

Likelihood to Recommend

I would rate Informatica Integration Cloud highly because they have been serving us well for the last three years. Data are scheduled on time and without any delays.

Manish Sharma

Product Manager - Technical in Information Technology at Amazon (10,001+ employees)

Vetted Review

4 years of experience

View profile

Great analytics and data extract transform load solution

Rating: 8 out of 10

Incentivized

November 5, 2019

Use Cases and Deployment Scope

Informatica Cloud is being used as the primary data extract transform and loading software so we can pull data and analyze insights from our digital transformation efforts serving small to mid-sized firms in bringing the power of digital platforms to their businesses. It is helping solve the problem of getting data and making it actionable by non-technical users.

Pros

Extract transform load
Data processing
Data pipeline formation

Cons

Integrations

Likelihood to Recommend

Informatica Cloud is relatively older software but it works well for mid to large-sized enterprise scenarios well for where the requirements are solidly defined. I think we wouldn't use this for an earlier stage company as there are other solutions out there.

Verified User

Consultant in Information Technology (51-200 employees)

Vetted Review

1 year of experience

ETL tool at its best

Rating: 9 out of 10

Incentivized

October 24, 2019

Use Cases and Deployment Scope

Its being used to transfer data & keep it up to date from SAP to Salesforce for our Sales Reps to make and maintain sales.

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

Likelihood to Recommend

Inserting updating new data, keeping data in sync.

Oleg Kuchkin

Sales Force Data Specialist in Marketing at Wolters Kluwer (10,001+ employees)

Vetted Review

4 years of experience

Informatica Cloud is a must for any organization that uses Salesforce

Rating: 8 out of 10

Incentivized

March 6, 2019

Use Cases and Deployment Scope

It is being used by our Integration team. Basically, it is used to solve business problems where integration needs to be done between a legacy system and 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.

Likelihood to Recommend

The ability to replicate tables from one target to another. It takes care of all of the field type creation and adapts to new fields being created on the fly without having to alter the target. It has a very easy learning curve with a point-and-click interface. It's good for regular business analysts who are not very technical.

Vaibhav Khanna ☁⚡

Salesforce Consultant in Information Technology at Appirio (1001-5000 employees)

Vetted Review

1 year of experience

View profile

Informatica Cloud is an amazing resource for data import automation and duplicate checking

Rating: 9 out of 10

Incentivized

February 21, 2019

Use Cases and Deployment Scope

We use Informatica Cloud to help leverage data and reporting in our instance of Salesforce. It is used daily to import new contacts and leads to our instance of Salesforce to allow for better tracking and elimination of duplicates and other data integrity issues. We originally used native Salesforce support for importing but found that Informatica Cloud provided so much more depth and insights.

Pros

Data importing
Duplicate checking
Duplicate elimination
Data tracking
Data import automation

Cons

The UI can be somewhat difficult to get used to. This recently changed and was made somewhat better, but it is still somewhat difficult for new users to work.
Some of the duplicate management is hidden or hard to find initially.
The single Sign-on integration at first can be tricky to navigate if you aren't a Salesforce Admin.

Likelihood to Recommend

If you are wanting to run any kind of data importing automation, Informatica Cloud is essential for your day to day business operations. We don't know of another tool that does all that Informatica Cloud can do. Manual imports with Informatica are also great because there is so much more you can do with it than native Salesforce import tools leverage. It is a great tool. It might be seen as overly complicated if you are just doing it for small, one-off manual imports, but if they are going to be at any kind of regularity, it is a great tool.

Verified User

Manager in Marketing (501-1000 employees)

Vetted Review

4 years of experience

Informatica Cloud -- a professional level product for professional organizations

Rating: 8 out of 10

Incentivized

February 20, 2019

Use Cases and Deployment Scope

We currently use Informatica Cloud to integrate data between our Oracle financial system, Salesforce.com and our internal transactiton processing system. Being cloud-based, we do not have the added overhead of maintaining our own server infrastructure to implement this solution. Informatica Cloud is a critical part of allowing us to meet both our technical and business requirements.

Pros

Informatica Cloud has a relatively easpy learning curve for new users and developers
Multiple database sources and targets are easily defined
Extensive built-in features and functions allow us to define the required mapping for our data needs

Cons

Some of the error messages are cryptic and difficult to discern the meaning and cause of the error
The ability to use sophisticted and complex SQL is somewhat limited
Some of the syntax for the built-in data formatting is a little difficult to understand

Likelihood to Recommend

Informatica Cloud is a great tool for use when data must be formatted consistently. Once configured, it is very robust and reliable. It is also well-suited for an organization without a robust IT staff to maintain a full server infrastructure. It offers a cost-effective approach to high-quality data integration for even the largest organizations. Organizations without staff experienced in data analytics may find it challenging to take advantage of the more complex results of this tool.

Verified User

Engineer in Information Technology (10,001+ employees)

Vetted Review

2 years of experience

Great for agile BI teams, complementary to PowerCenter

Rating: 8 out of 10

Incentivized

February 20, 2019

Use Cases and Deployment Scope

We use both Informatica Cloud and Informatica Power Center enterprise-wide as our primary ETL tool. It helps manage our internal gateways moving around data from our ERP systems into containers and other tools for extracting into reporting or analytics. Our primary use of the cloud product is to extract data from both our internal systems and our external CRM tools (i.e. Salesforce) into Azure Data Warehouse instances for us to leverage with BI tools and Website personalization tools.

Pros

Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects.
The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed.
The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office.

Cons

Price is a factor, the charges for each and every connector to various systems can add up, and seem to be annual expenses to account for in budget each year. We switched to just using Cloud between 2 systems so we only have to pay for 2 connectors because the price is pretty high. For other sources we’ve begun building out in Mulesoft to keep the budget in check.
Access to customer service is not the greatest. When running into problems the first line of defense for cloud is that it is not a Cloud issue and they cannot help. They are correct, of course, but could at least offer some support services to help us track back through permissions and secure agent setup to help identify and fix our issues, not just brush us off.
Updates to the Cloud product seem to hit without too much communication or follow through. While some of this could be prevented by our internal Administrator, I do think the level of communications from Informatica to the Admin are very thin as well. New features should be broadcast when you log in, and changes should be communicated within the app, and that does not happen with Informatica Cloud.

Likelihood to Recommend

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.

Verified User

Manager in Finance and Accounting (10,001+ employees)

Vetted Review

2 years of experience