What is our primary use case?
We are simply service providers; I don't think our relationship with Informatica is that strong. We have a financial client that has a very good relationship with Informatica. They were recently using PowerCenter and IDQ, but a couple of years ago, they purchased DIH. Recently they have been doing some POC using Informatica, Enterprise Data Catalog. They have a great relationship with Informatica.
What is most valuable?
We don't use Informatica Data Integration Hub extensively. I enjoy using it to create multiple publishing models.
What needs improvement?
The solution is good but recently, we have stopped using this product because we were not using it extensively. If you are using Data Integration Hub, it should be as a centralized repository, where it can communicate with many systems. For our current client, we are only using it for two source systems, which are not driving big revenue. For this reason, we stopped using Data Integration Hub and started publishing the news directly.
At present, I am not sure how many sources it can communicate with (how many multiple connectors are available). Nowadays, they're coming up with many connectors. It can communicate with all of the Cloud connectors and Cloud databases. If they could leverage social media connectors, I think that would be great a great asset. If they added this feature, it would be much more scalable.
For how long have I used the solution?
I have been using this solution for almost two years.
What do I think about the stability of the solution?
We encountered a few bugs in the coding page, but we faced bigger issues with Informatica PowerCenter. The data was not loading correctly for certain multi-regional datasets; when we analyzed the data, we tracked it to the same code page from the starting point to the end. Other than that, we never faced any difficult situations.
How are customer service and technical support?
We never had to use their technical support. We resolved any issues ourselves and thankfully, we never experienced any problems that we could not handle.
How was the initial setup?
The initial setup was not very straightforward. Not complex, but not very simple either.
What about the implementation team?
Deployment took roughly one week — 40 hours max from start to finish.
We have a team of 30 to 40 people who handle all maintenance-related issues.
What's my experience with pricing, setup cost, and licensing?
Informatica products are always increasing in price. Nowadays, many of their customers are leaving and seeking other data integration tools. That's the only drawback with Informatica. Performance and flexibility-wise, they're very user-friendly, but comparatively, their prices are a little bit too high.
What other advice do I have?
Presently, everything is moving to the cloud, and moreover, many people are moving to Snowflake Data Warehouse, as it provides more scalability. I feel the usage of DIH is very limited compared to Snowflake because Snowflake holds and stores highly compressed data and allows you to use different cloud-based tools, including AWS services, DCP, and other services. Snowflake also comes with Matillion, which is a very good ETL tool.
The use of DIH is very limited. Anything that we do with DIH, can be done with Snowflake, regardless of the subscription you may have. There are plenty of use cases — you can use it to build tables and consume it from the downstream. For these reasons, I believe that DIH is currently not doing as well as Snowflake in the market.
On a scale from one to ten, I would give this solution a rating of seven. Performance-wise, it could be better. The performance-related Issues could be due to low infrastructure, but for whatever reason, sometimes the performance is slow.
Which deployment model are you using for this solution?