Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Senior IT Application Specialist at a tech company with 10,001+ employees
Real User
We started with Firstlogic then switched to Informatica for it's ease of use.

What is most valuable?

Data cleansing and address validation are the most valuable features. Also the web services which can be called on the fly. Data Duplication plays a very important role.

How has it helped my organization?

It has improved the customer data management where we had the incorrect addresses and data cleansing. Also in finding the duplicates so as to ensure the customer data is not duplicated.

What needs improvement?

Asia pacific region address validation needs to be improved.

For how long have I used the solution?

3 years
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
September 2024
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: September 2024.
802,829 professionals have used our research since 2012.

What was my experience with deployment of the solution?

None

What do I think about the stability of the solution?

None

What do I think about the scalability of the solution?

None

How are customer service and support?

Customer Service: 4 out of 5Technical Support: 4 out of 5

Which solution did I use previously and why did I switch?

We previously used Firstlogic as a data quality tool. We found that Informatica is more feasible and user friendly than Firstlogic.

What about the implementation team?

In-house.

Which other solutions did I evaluate?

Yes. Trillium.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user845028 - PeerSpot reviewer
it_user845028Staff Software Engineer at a tech services company with 10,001+ employees
Real User

Hi There,

You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.

Thank you for your helpful sugestions Informatica IDQ training USA.
I tried the option IS_EXPR_VAR and it is treating the string as a expression.
But my requirement is that I have this expression logic changing for each record.
so I need to lookup for each record, fetch the logic and set this to mapping variable.
But when i try to set it , it gives me below error.

Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.

Best Regards,
Kevin

See all 5 comments
Data Analyst at a tech services company with 201-500 employees
MSP
Stable with a straightforward initial setup and a good user interface
Pros and Cons
  • "The solution's initial setup is quite straightforward."
  • "There may be some types of limitations with the performance."

What is most valuable?

The user interface is good.

The solution's initial setup is quite straightforward.

What needs improvement?

I haven't had too much time with the solution. There may be much to be improved. However, I still need time with it.

There may be some types of limitations with the performance.

For how long have I used the solution?

I've been using the solution for a couple of weeks. It hasn't been too long.

What do I think about the stability of the solution?

The solution is quite stable. We do not have any issues with it crashing and there are not bugs or glitches.

What do I think about the scalability of the solution?

The solution is very scalable. If a company needs to expand it, it should not face any issues doing so.

I am not sure how many users are actually on the solution in our organization.

We will be continuing to use the solution.

How are customer service and technical support?

We have dealt with technical support and they are very good. We are quite satisfied with their level of service.

Which solution did I use previously and why did I switch?

We did previously use another solution.

How was the initial setup?

The initial setup is not complex. The implementation is quite straightforward, actually.

As a cloud solution, the deployment doesn't take too long.

What about the implementation team?

I handled the implementation and deployment myself.

What's my experience with pricing, setup cost, and licensing?

I'm not sure what the licensing is for the solution.

What other advice do I have?

We're just a customer. We don't have a business relationship with Informatica.

We're using the latest version of the solution.

I'd recommend the solution to others. Overall, I'd rate the solution eight out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
September 2024
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: September 2024.
802,829 professionals have used our research since 2012.
PeerSpot user
MDM Lead at a tech vendor with 10,001+ employees
Real User
The Match-and-Merge feature helps us to address customers' issues, although setup is complex as it requires understanding of PAM documents.

What is most valuable?

The Match-and-Merge feature is valuable.

How has it helped my organization?

We are now more equipped to address the customers' issues.

What needs improvement?

  • Performance issues can be looked at
  • Improved release documentation is expected because I feel that the current release document doesn't give you the clear picture of what has been fixed and what has not been fixed from previous versions.

For how long have I used the solution?

3 Years

What was my experience with deployment of the solution?

We faced issues with User Exits post deployment, but those were addressed by Informatica.

What do I think about the scalability of the solution?

If the guides are followed then the instructions are very well documented about issues that may crop up during up-scaling/upgrading.

How is customer service and technical support?

Customer Service:

Excellent. Informatica has one of the best customer services with an excellent turn around time.

Technical Support:

Very good, a couple of technical support team members are excellent and they handle the case very professionally.

How was the initial setup?

Complex, it is not just a NEXT NEXT NEXT button click setup, it requires understanding of PAM document provided by the vendor and mapping it with your hardware and then carefully setting up each of the elements - database, application server and then the software itself.

What about the implementation team?

In-House along with some help from third parties. Understanding the business and collecting the initial requirement is the most important aspect and moreover verifying the collected requirement should be done so that there are no disconnects or gaps in understanding how the eventual implementation will look like.

What other advice do I have?

The product is the best in the industry (as it is multidomain) and the vendor support is excellent.

Disclosure: My company has a business relationship with this vendor other than being a customer: We're a partner.
PeerSpot user
it_user624771 - PeerSpot reviewer
Tech Lead at a tech company
Vendor
Provides the basic functionalities to implement ETL logic. The error information provided is not informative.
Pros and Cons
  • "The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."
  • "The error information provided is not informative, as compared to Power Center."

What is most valuable?

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

How has it helped my organization?

  • 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.

What needs improvement?

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.

For how long have I used the solution?

I have used this solution for around six months.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

It has not yet been identified.

How are customer service and technical support?

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.

Which solution did I use previously and why did I switch?

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.

How was the initial setup?

The setup is straightforward

What's my experience with pricing, setup cost, and licensing?

It is cost effective and an easily accessible tool.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user157974 - PeerSpot reviewer
Software Engineering Team Lead with 1,001-5,000 employees
Real User
Simple to use and results are always correct but data source need to be increased to support new markets.

What is most valuable?

I use AddressDoctor to validate address on a e-commerce site (based on WebSphere Commerce) for a company lead on food production. It is simple to use and results are always correct. Options used to configure validation request and details provided in result, such as which field is changed and why.

How has it helped my organization?

I'm not involved in this aspect, but reports underline delivery failure decreased.

What needs improvement?

Nothing, according to me only data source need to be increased to support new market, like eastern Europe.

For how long have I used the solution?

Since 2012, when new site version was released. 2011 if you consider also build time.

What was my experience with deployment of the solution?

No problem during deployment; only some issue during development to fit AddressDoctor model whit OOB one.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

No.

How are customer service and technical support?

Good, response is fast and detailed.

Which solution did I use previously and why did I switch?

Yes, switch was decided by client because previous system is not reliable like AddressDoctor and it doesn't support market where client is.

How was the initial setup?

Complex to adapt data model provided using web service and e-commerce one. Furthermore, I developed two different result management (for customer service and for end user) to fit business requirement.

What about the implementation team?

I implemented it.

Which other solutions did I evaluate?

Yes, previous versions of address validation (QAS).

What other advice do I have?

Pay attention to configuration. Correct configuration can help implementation and reduce integration time.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Raja ShahnawazSoni - PeerSpot reviewer
Data Architect at a retailer with 10,001+ employees
Real User
Top 10
Flexible licensing, good connectors, and timely upgrades and patches
Pros and Cons
  • "Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."
  • "The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions."

What is most valuable?

Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors.

What needs improvement?

The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions.

For how long have I used the solution?

I have been using this solution for roughly three or four years, but overall, I have around 12 or 13 years of experience in data integration. It is a cloud solution, and it is managed by Informatica. We are always on its latest version.

What do I think about the stability of the solution?

It has been stable for us. I haven't seen any issues. They provide the upgrades and patches in a timely manner. We don't even realize that the patch has been applied. 

What do I think about the scalability of the solution?

This is not a traditional cloud like AWS and Azure, which offer virtual machines, data storage, and compute power. With Informatica cloud, this is not the offering. You need to understand the offering. They are offering a data integration service. The scalability context here would be from the services aspect. If you want to have more data integration, you can do it instantly the way you want. You will be charged if it is beyond your subscription. They also have data quality and all the data management tools.

How was the initial setup?

Its initial setup is pretty straightforward and not at all time-consuming. They just offer one simple software that communicates on your local system. You have to enter the org IDs, etc. It also doesn't require a lot of hardware.

What other advice do I have?

I would definitely recommend this solution. It is definitely worth a try, and you will definitely benefit from it and see the value of implementing it in your organization. They are a leader in the Gartner Quadrants. The offerings that these guys are giving with the new licensing model, such as IPUs consumption, are excellent. You don't need to worry about what do you want to purchase. You just need to worry about the number of IPUs that you need to purchase. You can shuffle around all types of services under the same umbrella.

I would rate Informatica Cloud Data Integration an eight out of ten. It loses two points because of the region limitations.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Technical Consultant at a tech services company with 51-200 employees
Consultant
Good for building mockups and tasks
Pros and Cons
  • "The most valuable feature is the building of mockups and tasks."
  • "I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter."

What is our primary use case?

We are using this solution for integration and development.

What is most valuable?

The most valuable feature is the building of mockups and tasks.

The user interface is fine.

What needs improvement?

I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter.

Having a better dashboard would be an improvement.

For how long have I used the solution?

I have been using this solution for four or five months.

What do I think about the stability of the solution?

This solution is stable, and we haven't had any issues.

What do I think about the scalability of the solution?

This is a scalable solution.

How are customer service and technical support?

I have not had to contact Informatica. Any issue that I have had, I've been able to solve it by looking for something online.

How was the initial setup?

The initial setup of this solution is relatively straightforward. It usually takes about an hour to deploy.

We have six or seven people in our team, which is enough to support this solution. 

What about the implementation team?

We perform the deployment ourselves.

What other advice do I have?

For anybody who is implementing this solution, I would say that as long as they've got some kind of experience with ETL, or other Informatic products, then it should be absolutely fine.

This is a solution that I recommend.

I would rate this solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user674064 - PeerSpot reviewer
Business Analyst/Data Engineer with 51-200 employees
Vendor
You can find almost any product connection that you need.
Pros and Cons
  • "I like the fact that you can find almost any product connection that you need and the list is always expanding."
  • "It needs to be a little more intuitive but it’s really not bad."

What is most valuable?

I like the fact that you can find almost any product connection that you need and the list is always expanding.

How has it helped my organization?

Basically, it just allows connections with Amazon AWS/S3/Redshift.

What needs improvement?

It needs to be a little more intuitive but it’s really not bad. There are plenty of examples as how to use the product from Informatica and YouTube.

For how long have I used the solution?

I have used this solution for less than a year.

What do I think about the stability of the solution?

After the initial setup, the tool seems pretty stable.

What do I think about the scalability of the solution?

There is plenty of online support available from Informatica.

Which solution did I use previously and why did I switch?

In the past, we have used Informatica PowerCenter.

What about the implementation team?

We implemented this product in-house and my advice is just read all the available online support documentation that you can find.

What other advice do I have?

Read through the online documentation that is available.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.
Updated: September 2024
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.