The user interface is good.
The solution's initial setup is quite straightforward.
The user interface is good.
The solution's initial setup is quite straightforward.
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.
I've been using the solution for a couple of weeks. It hasn't been too long.
The solution is quite stable. We do not have any issues with it crashing and there are not bugs or glitches.
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.
We have dealt with technical support and they are very good. We are quite satisfied with their level of service.
We did previously use another solution.
The initial setup is not complex. The implementation is quite straightforward, actually.
As a cloud solution, the deployment doesn't take too long.
I handled the implementation and deployment myself.
I'm not sure what the licensing is for the solution.
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.
Our primary use case of this solution is to improve issues of security, quality and accuracy.
We are partners of Informatica and I'm an architect.
In terms of Data Quality, the feature most valuable to me is that the solution is applicable for both technical and business users. I like that instead of using on-premises processing power, you can now use your on-cloud platform processing power to process the data and get a faster turnaround time. From a product perspective, everything is well done.
I think improvements can be made regarding the ability of the product to leverage the power of big data. It would also help if we could get the software as a services product so that we feed in the requirements and it's a more customized solution. I think that would increase the adoption by customers.
I've been using this solution for three years.
Informatica is a very stable product, I haven't had any issues with it.
It's a very scalable solution and it has all the other big data components.
We have a business partnership with Informatica and they are very responsive.
I've had a lot of experience with this solution so I don't have any issues with implementation. Perhaps someone from a different background or different circumstance, may face challenges but it is user friendly so it shouldn't be a problem. Implementation generally takes about six months depending on the dimensions required. This solution cannot be implemented in a day or a week.
The pricing of this solution is definitely at the higher end and they don't provide the option of a trial version. If you look at Talend, for example, they provide a free version, so the cost of IBM and Informatica is a little high.
The cost of the product is high, but feature wise, it provides a whole lot of features that can easily solve your problems. I would recommend this product.
I would rate this solution an eight out of 10.
We use the solution for cloud-to-cloud migration so our clients have all applications and data on their Oracle solutions, and we move it from there to AWS cloud and then to Salesforce. We're an implementation partner with Informatica and I'm the senior technical architect in the company.
The connectivity and their whole suite are valuable features. Whether we need data cleansing or data mastering, we get it all in one platform. There's no need to test different cloud vendors and then integrate with one solution. Informatica is a one-stop shop.
The one thing that I think could be improved is connectivity with the Salesforce because if you're loading a huge amount of data, whatever optimization is carried out, takes some time and it could be a little faster.
I've been using this solution for a year.
We had some very minor issues initially, but the product is stable. We haven't experienced any down time.
We've just completed the first part of the implementation. In the upcoming months we plan to carry out multiple implementations and then we might see some challenges in the scalability. I think it will be fine. I have about 35 users in my team - around 40% are developers, 30% are testers and QAs and then a few are designers, data modelers, and architects.
The way we carried out our transformation was throwing some junk value as an output and that meant we had to reach out to Informatica to see what kind of configuration changes might be required. They were pretty quick to respond and knowledgeable about the issue, and dealt with it very well.
The initial setup was very simple and took a couple of days. AWS provided everything for us.
We initially wanted to build the programming language in Python but the client's needs made us realize that Informatica was the way to go. Our initial design was something different and it was the cost that put us off going with Informatica as a first choice. If we had worked with something like Python, it could possibly have been more scalable and the cost reduced.
If cost is not a issue then I would recommend Informatica as the tool of choice.
I would rate this product an eight out of 10.
Our primary use case is connecting to the AWS S3 buckets and AWS instances in the cloud, extracting data from on-premises, and pushing it to the cloud. I think that's a perfect use case for Informatica Cloud.
I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful. Very few tools outside of Informatica have the ability to do that.
I would like to see support for more data sources. At this point in time, I'm not sure if they are supporting Microsoft Azure or Google Cloud, but continually adding new data sources is one area that they can improve on.
The deployment could be somewhat simplified. One drawback is that you need a separate server for it. However, from an enterprise point of view, it is worth it because the product is good.
I have been using Information Cloud Data Integration for about one year.
I have had no trouble in terms of stability.
The scalability is quite good.
Informatica has a strong support team and they are very good.
The initial setup is complex. It isn't easy because it needs a separate server of its own.
My understanding is that Informatica is quite expensive compare to other tools that are available in the market.
I am a fan of Informatica and it is definitely a product that I recommend because of its inbuilt capabilities. At the same time, I would like to see more data sources added. Inclusion of support for Azure and Google Cloud would be a game-changer, wherein companies can move their analytics capabilities to the cloud instead of being on-premises.
If you have the money then you should implement it. Otherwise, there are many open-source tools in the market, although you will still have to invest quite a lot in terms of resources because the individual transformations still need to be built.
I would rate this solution an eight out of ten.
The primary use case of this solution is centralizing and mastering the data. It is also used for centralizing the data between your administrator and customer.
The most important features are the mastering of the data and the UI intuitiveness.
I find this solution to be the most efficient, immersive, and robust.
Also, they have a feature map that is flexible and robust.
They need more feature flexibility, as it is not fully developed.
I have been using this solution for approximately 11 to 13 months.
I have not contacted technical support. We have a team in our company for support and maintenance.
My advice for anybody who is implementing this solution is to see the business needs and the requirements.
I would rate this solution a seven out of ten.
We have a lot of applications with different functionality. We use Informatica mainly for sensitivity tests.
The most valuable features are the structure masking and platform masking.
I also like that for Salesforce integration we can use Informatica Cloud. For on-premise, normally we do the SQL server database.
I don't see where it has much room for improvement.
I have been working with this solution for the last two years.
We have a team of 10 users on-premise. Their roles are doing the initial analysis for identification.
We don't currently have plans to increase usage.
I would rate it a seven out of ten.
It's not a perfect ten because the data discovery isn't that good yet for Salesforce. We have another tool that we use for this. It may be a problem because Salesforce on the cloud.
We provide services mostly to banks.
I am currently working at a bank where they are using Data Masking and Data Transformation at the same time. They are an old core banking system, which is COBOL, and it's unstructured data. We are using Data Transformation to transform and structure the data into a relational format.
We use the test data management to create test data from the relational data. To create the test data, we mask using different techniques for the discovery. After that, we re-transform the relational data into unstructured data to be fed into the core banking system.
The most valuable feature is data discovery. This is the most exciting feature for all of the banks.
I have encountered some issues using the substitution, which is one of the techniques of data masking. I used the substitution and software. I had issues in both when using the field, and specifying the field. Each one will have the same data for the same person, and they will have realistic data each time. This issue was raised with technical support and it was flagged as an issue that had no solution. They have indicated that it is a bug that would be resolved in the next release.
In the next release, I would l like to see the bug with the substitution resolved.
I have two years of experience with Informatica Data Masking.
This solution is stable and we have not had any issues.
Informatica Data Masking is scalable.
The technical support is good, although sometimes they don't respond quickly. Overall, they are good.
I raised the case where I was having some issues with the substitution, and it took two months. Finally, the answer was that they have no solution for this, but said they will flag it as a bug to be resolved for the next release.
As I was not able to stop the project because of the bug, I created a workaround using PowerCenter to make it work. The data was not unique. I used PowerCenter and added an ID to all of the columns, then I concatenated the ID with the columns. As an example of why this was complete is if my name is Donna, it will show as Donna123. That way, any other person named Dana in the same database or table would show as Donna246 and they would no longer be the same. With this, I would then offer a substitute.
Previously, we did not use another solution.
The initial setup is straightforward.
The length of deployment depends on the solution. For example, I find security was very easy, but the data integration was more complex. This is because it has many features and you can do many things. Setting up the data quality was also very easy.
We have deployed both on-premises and on the cloud. Mostly, I work in Lebanon and some Arab countries also. There have been some issues with the Cloud, so they prefer on-premises software. We implemented some iPaas on the Cloud for Data integration.
It's good as a solution.
I would rate this solution a nine out of ten.
We use this solution for data quality management.
We have matured as an organization with regards to better quality management, and we have evolved over time. This solution has had a positive impact on our efficiency, especially with regard to finance officers. They rely on the quality of data for customers and vendors so that they can invoice properly.
From a sales point of view, there are also improvements.
The most valuable feature of this solution is data profiling. We are able to set rules, establish a data quality management platform, and monitor the quality. These features are excellent.
I would like to see better visuals for business users, such as a dashboard where they can precisely track where problems are. You should be able to better visualize data quality.
This solution is stable.
The technical support for this solution is good. They have a good mechanism for support and I haven't experienced any problem with it.
Prior to using this solution, we did not use a dedicated product for data quality. Rather, we used a combination of other products. One of these was CranSoft, by BackOffice Associates.
We switched because this product was quite immature, not covering the governance part of it. It was more for data quality, only.
The initial setup of this solution is pretty much straightforward.
The deployment should not be complex, although there are other factors that influence the time it takes to complete.
The suitability of this solution depends on your environment. If you need large scale data quality and rely heavily on different connections to ge the data, then you really need a good powerhouse and this is the best. But, for example, if you already have SAP in your organization then you may not need IDQ on top of it. There are different factors to consider.
This is a good solution, but I can't say that you can solve all of the problems using it. Informatica is focusing only on master data quality. In this regard, there is room for improvement, but it depends upon the use case.
I would rate this solution an eight out of ten.
We are using data discovery for on prem databases (Oracle, Microsoft sql, and DB2) and it is working really fine.
I guess the secret is in tuning and adjusting the data and metadata patterns.