IBM InfoSphere Information Server vs. Matillion vs. SharePlex

Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

Great: Need to query simpler APIs, or utilize well known services such as GSheets etc.? Matillion has got some of the best and easiest to use connectors out there. Not so great: Do you need have a competent CI/CD flow that you will be able to update / compare from Matillion as well as other sources at the same time? Good luck, you will need to be extra careful, as you might have to have a deeper dive into your servers Terminal each time you have a git conflict.

Incentivized

SharePlex really shines when set alongside GoldenGate. The licensing costs of the two products would appear to place them in entirely different ballparks yet they perform nearly identically in practice. SharePlex is suitable for heterogenous replication of one database to another. The list of targets is ever increasing, with support for all major RDBMS vendors as well as support for popular NoSQL and JSON replication. SharePlex is effective when replicating from on-premise to cloud. Whether that's migrating data, creating a high-availability presence in a public or private cloud, or populating a data mart, it does the job quite well.

Incentivized

• IIS best for ETL ,not ELT , and many and diffrent source systems.
• It also can process big data , unstuctured data
• It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems

Incentivized

• The user interface of your data pipelines makes it easier for people who aren’t as techy as data engineers to observe what's going on.
• Customer support is quick, not always as efficient as you would want it to be, but still.
• Nice documentation available.

Incentivized

• SharePlex is highly configurable and versatile. It can handle virtually any kind of data replication needs.
• SharePlex is very robust. Its message queuing mechanism provides fast data transfer from the source to the target.
• SharePlex software is very stable and mature, and it is highly scalable and reliable.
• SharePlex support is exceptionally good. We are very satisfied with its support engineers.

Incentivized

• I would be nice to have a new web development environment for DataStage.
• Connectivity Packs such as Pack for SAP Application are a little pricey.
• It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.

Incentivized

• Matillion is brilliant at importing data -- it would be amazing to have more ways to export data, from emailed exports to API pushes.
• Any Python that takes more than a few lines of code requires an external server to run it. It would be great to have more integration (perhaps in a connected virtual environment) to easily integrate customized code.
• Troubleshooting server logs requires quite a bit of technical expertise. More human readable detailed error handling would be greatly appreciated.

Incentivized

• When first introduced the Change Data Capture process was awkward. Each subsequent release has improved the process.
• Sometimes the Shareplex monitoring service in Foglight gets overly aggressive in sending out error notifications and can end up spamming the admins with email alerts for one problem. We have had to tone that down.

Incentivized

• Scale of implementation
• IBM techsupport

Incentivized

With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.

Incentivized

We depend on it to supply data to our various OLTP and Data Warehouse environments

Incentivized

We are able to bring on new resources and teach them how to use Matillion without having to invest a significant amount of time. We prefer looking for resources with any type of ETL skill-set and feel that they can learn Matillion without problem. In addition, the prebuilt objects cover more than 95% of our use cases and we do not have to build much from scratch.

It is very usable once you get over the initial setup.

Incentivized

Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.

Incentivized

Support is very responsive. They take ownership of the problems and see them through to the finish. When a bug is found they work towards developing testing and making the fix available to us to solve the problem.

Incentivized

We were able to control on access and built various enviroment for implementation

Incentivized

DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS

Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum is essential to deciding which tool fits better. For the transformation part, dbt is purely (SQL-) code-based. So, it is mainly whether your developers prefer a GUI or code-based approach.

Incentivized

SharePlex support is an award-winning team, which is available for 24 hours, and any time they have solutions with perfect expertise. Besides, SharePlex has supported data migration, with multiple reporting features that ensure there are comprehensive database evaluations. The simplicity of SharePlex installation also gives it a higher mark, is very efficient, and allows companies to understand it easily.

Incentivized

We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.

Incentivized

• Productivity of the development of integration processes.
• Better documentation and governance.
• Reduce training costs of various technologies.

• Matillion has been the backbone of my company's analytical functionalities for 10+ years, so it has a good ROI.
• The price is ok for what our company built with it, but it starts to be less competitive if the tool is not used at its fullest.

Incentivized

• Postive: easy to replicate data for non-prod use
• Negative: we spent a lot time due to data out of sync

Incentivized