Anirban BhattacharyaPractice Head, Data & Analytics at a computer software company
Abhijit Arun GujareSr. Oracle DBA at a comms service provider
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The data transformation is the solution's most valuable feature."
"The most valuable feature is connectivity to data sources."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"Mainstream integration and real-time integration are the best features."
"The user interface and user experience are perfectly all right."
"This product is easy to install and it can be done in a few hours."
"Provides a significant amount of control over the landscape and overall implementation."
"The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent."
"There are some capabilities within SharePlex where you can see how the data is migrating and if it still maintains good data integrity. For example, if there are some tables that get out of sync, there are ways to find them and fix the problem on the spot. Since these are very common issues, we can easily fix these types of problems using utilities, like compare and repair. So, if you find something is out of sync, then you can just repair that table. It basically syncs that table from source to target to see if there are any differences. It will then replicate those differences to the target."
"Because of the volume of the transactions, we heavily use a feature that allows SharePlex to replicate thousands of transactions. It's called PEP, Post Enhancement Performance, and that has helped us scale tremendously."
"The solution needs better integration with other tools."
"Technical support can be improved with respect to delays in ticket response time."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"Integration with the largest number of databases and other systems would be important."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"I would like to have easier integration with cloud platforms."
"Should diversify more, maybe with a reporting and visualization utility,"
"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication."
"I don't know how easy it would be to change the architecture in an already implemented replication. For example, if we have a certain way of architecting for a particular database migration and want to change that during a period of time, is that an easy or difficult change? There was a need for us to change the architecture in-between the migration, but we didn't do it. We thought, "This is possibly complicated. Let's not change it in the middle because we were approaching our cutover date." That was one thing that we should have checked with support about for training."
"I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us."
"It is not as expensive as Oracle GoldenGate and has worked really well within our budgets."
"It's really good value for the money. There are some things they could improve on, but in terms of the pricing, features, and support, as a holistic package, we are not thinking of anything else at this point in time."
Earn 20 points
Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.
SharePlex database replication empowers your organization to achieve its database goals now and into the future. Make use of built-in monitoring, conflict resolution, data comparison and synchronization capabilities backed by award-winning support.
Informatica PowerExchange is ranked 14th in Data Integration Tools with 8 reviews while Quest SharePlex is ranked 18th in Data Integration Tools with 3 reviews. Informatica PowerExchange is rated 8.2, while Quest SharePlex is rated 9.4. The top reviewer of Informatica PowerExchange writes "Offers data in real-time using CDC concepts but it should be more flexible ". On the other hand, the top reviewer of Quest SharePlex writes "Real-time replication means our data is available almost instantaneously if an issue occurs in one of our data centers". Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Qlik Replicate, SSIS and SAP Process Orchestration, whereas Quest SharePlex is most compared with Oracle GoldenGate, HVR Software, Qlik Replicate, AWS Database Migration Service and SSIS. See our Informatica PowerExchange vs. Quest SharePlex report.
We monitor all Data Integration Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.