Informatica Intelligent Data Management Cloud (IDMC) Reviews

The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations.

The designer allows for the creation of mappings to be leveraged as templates. Within the templates, parameters can be set up that serve as variables for deployment to mapping configuration tasks.

Mapping Configuration Tasks, MCTs, are specific uses of a mapping to fit a situation or set of circumstances.

With my firm, our use of Informatica Cloud is primarily to implement a set of financial integrations from various accounting systems into a Salesforce environment.

By leveraging Informatica Cloud Mapping Designer, we were able to create sets of reusable templates that were source agnostic. This made supporting the integration for hundreds of customers feasible with just a small team of integration specialists.

There are a small number of UI bugs that occur on occasion.

In several browsers, such as Chrome, elements of the UI can disappear when navigating through steps in any of the integration tasks' wizards. Additionally, on data synchronization tasks, the source fields in a mapping can disappear altogether as well.

Also, the product is so new, that any points not covered in the documentation prove difficult to research online.

I have been using Informatica Cloud for two years.

There is currently no active failover for Informatica Cloud Secure Agents. This is the service used to process source information in client environments.

Therefore if a Secure Agent running a job goes down, the job will not wait or failover to another agent. It will fail as well.

We have not had any scalability issues so far.

Technical support is stellar. The time zone can prove an issue, as their support is all in Pacific Standard Time (PST).

We did not have a previous solution.

The installation and configuration of the Secure Agent is a breeze.

Jitterbit, SnapLogic, and MuleSoft were evaluated.

Informatica is likely to make this their flagship product. It is a solid investment to move to this ETL now. There will continue to be a slew of new features and product improvements in the near future that may increase the cost of the license.

• Data Replication Tasks: Easy to configure, for the most part reliable, and also what my system deals with the most.
• REST API: Excellent for scripting control and reporting mechanisms

Ease of use, configurability, maintainability, and good aesthetics make for a more fluid functional process.

User/group administration could use improvement.

I have been using this solution for 15 months.

No stability issues as of yet.

The REST API could have the ability to generate tasks, and certain manual functions like updating/deleting data replication tasks could come with a bulk update option somehow.

I would give technical support a rating of 10/10. They are just incredible.

I inherited this solution in its infancy, but I don't have the details.

The setup was straightforward.

Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful.

I did not evaluate any alternative solutions.

Pose any and every question/doubt/concern to the team, especially with respect to licensing. They are excellent in their communication.

I particularly value data replication and data sync jobs. Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job.

I also appreciate the flexibility of the reset target option to reflect the source object structural changes to be implemented on the target database table side. This is awesome.

It helped the organization to always have the backup of SFDC data in-house for data warehousing purposes.

• Stable connectivity: No matter what, our business requires steady, stable, and consistent connectivity. Regardless of how many columns in an SFDC object or how many rows in an SFDC object, we must have steady connectivity.
• Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations.

I have used this product for five years.

There are stability issues, especially when connecting to SFDC. At times, we do see connection time-out errors, though we have changed the properties in Informatica secure agent properties. We have also noticed that sometimes it does not cooperate well with SFDC read and write operations.

We did not encounter any scalability issues.

Technical support can be described as average.

The client was using data loader, but as the demand increased to replicate the data and frequency of data replication, they moved on to Informatica Cloud.

The initial setup was pretty straightforward. You just have to login to the server where you want to download, install, and run the Informatica secure agent

The pricing structure is good, but having to pay for extra drivers to be used in an ICS environment makes me a little nervous.

The client had already purchased this solution and it was up and running in all of their different environments

It’s a great product which allows the connection to a number of cloud based technologies such as Workday and Salesforce.

It is quite easy to use and flexible.

With recent versions of cloud-based products in use for all applications, it provides flexibility in integrating the different applications. With AWS S3 and Informatica, integration is flexible and loosely coupled.

The vendor should have more training resources: online classes, free tutorial videos, etc.

I have used this product for six months.

We have not yet had any issues with stability, as we are just beginning our journey.

Yet to be determined.

So far, so good.

We recently started migrating and using SaaS-based application solutions. On-premises, there are multiple integration platforms being used, such as BizTalk and SAP PI.

Since it is SaaS based, no setup was required, except for the installation on a secure agent.

I was not involved in pricing and licensing.

I was not involved in the selection process.

It is quite useful and flexible compared to other vendors in terms of cost of implementation and use case.

It is a cloud-based solution. This means it has no complex software nor does the startup need to be installed. However, a cloud agent is required.

Like most cloud-based solutions, it is easy to share with others. For example, let's say I am working on a site and decide to hand-off to another team member. He can essentially pick up where I left off, provided that he has the same set of files.

Informatica goes down for maintenance quite a lot due to the upgrades. They also need to improve their security. As an administrator, I could very easily make connections to other people's machines through their agent without their knowledge.

I have used this solution for two years.

There were no stability issues.

There is a slowdown when using the mapping feature. This may be due to the processor's speed or may be a result of the complexity of the browser.

I would give the technical support a rating of 9/10. They are very good, once they are aware of the issues. However, sometimes we need to fill out multiple help desk tickets and give them reminders in order to get an active response.

We are partners with a number of different companies. This is the first cloud-based solution. It serves the client's needs well, as the solution is not overly complex, such as during replication between different databases or systems.

The setup was very straightforward. Once the agent is installed, you can then be up and running.

We work with Informatica to establish the pricing and licensing fees. I personally have not sold this product to clients, but I have been involved with presales and demos.

We chose to be Informatica partners, so we just ended up with this version.

Understand the needs of your organization. I strongly advise an understanding of the Informatica PowerCenter, so as to achieve the full effectiveness of this tool.

For simple replication, it works well. However, there are some other free tools that can also do the trick of replication just as nicely.

The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic.

• Provides the basic functionalities to implement ETL logic
• Can be accessed from a web browser or from any device with internet connectivity.
• We need not be in the office to perform tasks
• We use it to run jobs, even at midnight, based on the requests of the business users.

It needs lot of improvement from the admin to the development side. There are many known issues while mapping. The error information provided is not informative, as compared to Power Center.

I have used this solution for around six months.

There used to be performance issues. Throughput is slow when we do not have the Informatica Secure Agent running on the DB instance.

It has not yet been identified.

I would give the technical support a rating of 2/5. Informatica doesn't provide on-call or technical support for AWS instances. We need to rely on responses from the forums if we raise any queries.

I have used Power Center. I switched to the Informatica Cloud (IC), as it is cheaper compared to Power Center. It gave us a chance to explore a new tool and technology.

The setup is straightforward

It is cost effective and an easily accessible tool.

It totally depends on the business requirements and the budget. I have been working on Informatica for more than nine years, and I recommend using their products.

New ProductBusiness user-friendly web user interface, dashboards and graphs, flexible task-based workflow, ability to use library of out-of-box data quality rules or define custom DQ business rules, channel specific exports, fully customizable BPM workflow engine for task management and notifications, enterprise scalable performance, flexible data model and hierarchy management.

Our Implementation Delivery team is able to design and implement robust business solutions for PIM and Product MDM for our many large, global Retail, Manufacturing and Distribution clients.

Additional pre-built, "plug and play" out of the box functionality should continue to be built.  Additional pre-built capabilities and connectors to better integrate with social product data for ratings/reviews, additional Ecomm and external DAM solutions.

Approximately 4 years.

Some technical issues have been encountered and resolved during migrations and cutovers. 

We have seen stability issues with older versions, particularly 6.x and below. Newer versions have proven stable.

Scalability is on par or better than any other solution on the market. One of our customers has over 21 million SKUs in PIM, and others have 100's of international users.

Excel-like, so adoption is easy with users. The exporting and importing of information makes data management easier.

We have been able to assimilate our vendor products enhance the data for our web sites and other internal systems and then sync the data out to our customer facing systems with updated prices and product information. It is helping our purchase orders to be more accurate to our vendors.

The job scheduler needs improvement.

3 years

The deployment went very well. We contracted with a smart partner who specializes in product information data implementations. This made all the difference.

Excellent

Excellent

This was new for us to move our product data to this system.

Our data was complex so our implementation was. Our contractor who had worked with this tool as an implementer really helped us to configure the data.

Vendor team.

We reduced product data setup time from 1.5 hours to 30 minutes.