Informatica MDM & 360

Avantages

WE are using Informatica MDM since the inception of our project and I can tell you from my experience It is one of the best MDM tool out there in market. It not only store your master data which comes from different sources but also we can perform data cleansing also on out inconsistent data. Ans one of the most highlighted feature is it core component that is Hub Console , not only useful for developers but for data stewards also. With an easy to use UI and feature leveraged functionalities.

Inconvénients

There are many features you will love about this software I will highlight few of them here.
1) The data insertion feature, you can not only load data in batches or real-time there is a feature called data manager which is very useful if you want to insert or modify small numbers of records you dont have to follow all the steps just select the base object and insert/update the records.
2)We can not only task manual one task at a time like stage and load but also you can automate the many task from Batch group.
3)SIF API most useful feature when it comes to connect with middleware software's or external applications.

Alternatives envisagées 

Pourquoi passer à Informatica MDM & 360

Avantages

Integration to their EDC data catalog, great Team to Support the effort. Informatica are a professional organization throughout.

Inconvénients

A bit hard to Use initially. From an end User perspective their needs to be Training and it needs to be taken seriously as this can be a complex system.

Avantages

Powerful product, it can do many things.

Inconvénients

Not the right solution for us, we were using ~10% of its capability.

Avantages

The tool is very user friendly. The best thing is when you work on it and try to save a mapping or something you can easily check whether the process is correct up to that step or not and according to that you can proceed further.

Inconvénients

The visualization might be improved, I mean the interface of that software. They can work on the visualization part to make it more user friendly. One more aspect I want to include that when I work on it sometimes data might be lost for some time due to synchronization issues which may be resolved.

Avantages

It exposes API in both SOAP and REST which makes the consumer to use it very easily from any application.

API is used for writing the data in the table , as well as look up the data.

All the master data is easily maintained in the database with appropriate structure . all the transaction data is maintained in the History table which we can make use for track back the data.

Application Interface is very fast with all POST,PUT, DELETE and GET operation.

We can schedule some daily run job easily.

Inconvénients

it requires some initial hard work in understanding the architecture and data pattern though we have very good documentation in online.

Initial installation and setup take some time.

Avantages

The ability to master data, implement rules, make changes to the system to suit the end user. Customer service was great

Inconvénients

The complexity of the system (tweaking it to suit the business needs.

Avantages

You can save all the data at one place (centralize) and use it for various applications
Customer support is good.
Data Connectors: It is quite flexible in connecting to different sources.

Inconvénients

UI can be improved. Apart from that everything is fine.

Avantages

Informatica's suite of tools all operate very efficiently and are easy to pick up. This was actually my first experience in this kind of tool and I was up and running very quickly.

Inconvénients

Informatica tools can be on the pricier side. But there is good reason for that and I'd say it is still way worth it.

Avantages

This wonderful app because it is an integration platform that allows to extract, transform and load the data. This app is user friendly! We can drag and drop source, transformation, and target. We can manage the source data from multiple language such as oracle, sql, and import/export file. We can schedule the job

Inconvénients

Sometimes while running the workflow, status in monitor is not update. So sad because not support Bigdata.

Avantages

The best thing is that it can be easily integrated with Salesforce.We an create scheduled jobs to upload data.

Inconvénients

It is a bit costly.Also we cannot run a job on user demand.It utilized a lot of RAM.This often makes the computer slow.

Avantages

Provides centralized data across the business entity with robust features and with latest architecture

Inconvénients

Integration of the systems must be done for all the downstream and upstream applications which needs a upgrade

Avantages

It's great tool to draw lineage between systems.

Inconvénients

Overall great tool but if you have to draw lineage between two different system .You have to create enumerated links ,which is time consuming.

Avantages

I like that it is easy drag and drop, it is very user friendly

Inconvénients

I feel as if it is outdated compared to other tools. It takes longer for enhancements and features to come out

Avantages

The best part is that you can have 360 degree view of the relationships and a single view of the data.