I work as an Information Architect at a Government company with 5000+ employees.
I need a solution to manage client data across multiple systems:
Federal Government regulatory agency
How does Microsoft Master Data Services (MDS) compare to Informatica MDM (or even Profisee) for integration with Azure?
Enterprise MDM Architect / Solution Arch at a energy/utilities company with 10,001+ employees
14 January 22
Hi @Richard Tibbetts,
There's no short answer to your question. Nearly all existing MDM solutions on the market offer a broad range of patterns to ingest master data from various sources and distribute cleanse and consolidated information, also to the Azure stack. Many vendors offer prebuilt connectors for the most common sources (databases, various file types, storages, business applications including MS Dynamics, Salesforce, etc.), but also support a generic way of ingesting/exposing data via Rest APIs, file drops, etc.
MS MDS is an extension of the MS SQL server 2016. I don't know Microsoft plans to extend it, but I know that Profisee and CluedIn are very active in promoting their solutions as-built having Azure in mind and being a part of the stack.
Informatica MDM has three types of offerings these days: on-prem, hosted MDM, and cloud-native option - they differ in the functionality and integration options.
Obviously, there are many more MDM tools on the market particularly good in various data domains (products, customers/suppliers - so yours, multi-domain, etc).
I think that you should start your MDM journey by answering which current challenges you try to solve or what new capabilities you need to enable to the organisation. Once these questions are answered and based on your organization's Enterprise Architecture principles, look for the best fitting tool. It may (or may not) be the one that fits the best into the Azure Reference Architecture.
I hope this helped.
I agree with @InitZero...
I would add that there's no future roadmap for MDS and they don't have an Azure solution for it. Since it's a free product with an SQL license, don't expect Microsoft to invest in it.
Even though we are highly dependent upon it currently I'm starting to look towards the future where we need to find a replacement - hopefully, a PaaS solution. It would be great if Microsoft came out with something in Azure but I'm not hopeful at this point.
I'm an Integration Developer and starting with a company that hasn't adopted SOA or a decopled tiered approach to the integration architecture. I would describe the current architecture as mainly as one-off custom "point-to-point" and tightly coupled integrations, mainly done with custom coding embedded in our ERP system and our ERP system's integration broker. We may be moving away from this ...
I can help out. We at best can use a conference call to discuss this if you agree. My contact details are:
- +31 6 28 570 870
I am lcoated in the Netherlands and the CET timezone.
I have over 5 years'of experience and knowledge in detail on iPaaS, API Management, API Gateways and ESBs and are currently advising and implementing it at top 5 global brands and local Dutch market leaders.
Talend platform can help with this.
since integration is key in this aspect, you need to be able to a) connect with ease and without limitation and b) scale your platform as the requirements grows without being limited by costs and excessive systems requirements, and finally C) improving productivity through the reuse of what you've already created.
Talend offers a modular approach to their platform, you scale this depending on your requirement so you only pay for what you need.
The modules available are form open source to enterprise Data integration, data quality, ESB, MDM, real time big data, metadata manager, API manager RESTLET, self service applications: Data preparation and data stewardship.
connectivity is a major point since 900+ connectors are available out of the box and more are available from the open source community, alongside API and JDBC type approach.
ease of use:
Visual UI that uses a drag and drop approach, Source systems on the left, target systems on the right- from there you practically draw your integration job.
Talend admin Console:
a single console to govern all talend modules, allows for scheduling, automation, access to shared repository, monitoring and managing deployments etc. developer cooperations, code reusability, impact analysis, governance rules, etc
Code Reusability: Talend offers a native code generator, where development can start off in (eg. Java and when required can later be generated in Spark, Mapreduce, or storm or any other code.
this element is also available with regards to the repository since you can access code already created( as long as governance rules permit)
commercial factor: talend price is based on the number of talend developers: so in your case, you'll only need to think about one or two developer licenses.
in fact with less than 25k , you can have an annual subscription of a hybrid talend cloud integration platform, giving access to Data Integration, Data quality, Bigdata with multiple remote and cloud engines included.
There is no charge for the amount of data you use, and all connectors and support is out of the box.
Infact, if you wanted, you can actually start integrating your systems using the open source tool: Talend Open studio for data integration and when you're ready, you can upgrade and migrate to enterprise without losing any of the work you've done on the open source tool.