Master Data Management Specifications

Specifications: Master Data Management

Talend Master Data Management (MDM) supports the following third party components, products and operating systems. Support varies across Talend products.

Master Data Repository

Master data may be stored in one of the supported RDMS systems, including Apache H2, IBM DB2, Microsoft SQL Server, MySQL, PostgreSQL and Oracle

Support for Web Services

  • Bindings: SOAP, REST/HTTP
  • Data bindings: Aegis, JAXB 2.2, SDO, XMLBeans, JIBX
  • Formats: XML, JSON
  • Transports/Protocols: HTTP, Servlet, JMS, MQTT, AMQP, UDP, Apache Kafka and many others via the Camel transport for CXF such as SMTP/IMAP/POP3, TCP and Jabber or using a Talend ESB Route in between. Extensibility API allows additional bindings for CXF, enabling additional message format support such as CSV and fixed record length.
  • Web protocols: CometD, WebSocket

Address Validation, Standardization and Enrichment

Through a combination of components and services, Talend supports the following address validation partners: Google, Loqate, Melissa Data, and QAS.

Matching Algorithms

Exact Match, SoundEx, Soundex FR, Metaphone, Double Metaphone, Levenshtein, Jaro, Jaro-Winkler, Q-gram, Custom/User-Defined, Hamming, Swoosh, VSR

Supported Database and Storage Connectivity

Amazon Aurora, Amazon RDS, Amazon Redshift, Amazon S3, AS400,  DB2, Derby DB, EXASOL, eXist-db, Firebird, Google Storage, Greenplum, H2, HSQLDB, Informix, Ingres, InterBase, JavaDB, JDBC, MariaDB, MaxDB, Microsoft OLE-DB, Microsoft SQL Server, MySQL, Netezza, Oracle, ParAccel, PostgresSQL, PostgresPlus, SAP Business Warehouse, SAS, SQLite, Sybase, Sybase IQ, Teradata, VectorWise, Vertica, Windows Azure Blob Storage

Connectors to SaaS, Enterprise, and More

  • SaaS Connectors: Marketo, ServiceNow, Salesforce.com and Salesforce Wave, NetSuite, Microsoft CRM & AX
  • Packaged Application Connectors: SAP (table extract, BAPI, IDOC), Sugar CRM, Microsoft, Sage X3, CentricCRM, Vtiger CRM, Open Bravo
  • Technical Connectors: Amazon S3, Amazon SQS, Bonita, Box, Dropbox, ElasticSearch, GoogleDrive, JIRA, Email (SMTP), FTP/SFTP, LDAP, REST, Splunk

Supported Big Data Hadoop Distributions and NoSQL Connectivity

Amazon Redshift, Amazon DynamoDB, Amazon EMR (including Apache Spark), Apache Hadoop (HBase, HDFS, Hive), Apache Spark, Cassandra, Couchbase, CouchDB, Cloudera Enterprise, Google BigQuery, Hortonworks Data Platform, Microsoft HDInsight, IBM PureData System for Hadoop, MapR, MapR-DB, MarkLogic, MongoDB, Neo4J, Pivotal HD, Riak, SAP HANA, Teradata, THD, Vertica

Supported Operating Systems

  • CentOS Linux
  • OS X
  • Redhat Enterprise Linux
  • Solaris
  • SUSE Linux
  • Ubuntu Linux
  • Microsoft Windows

Additional Details

Supported Systems and Databases
Talend Open Studio for MDM
Talend MDM Platform

All Components & Connectors
Component List

Product Documentation
help.talend.com

PRODUCT CERTIFICATIONS

SAP Certification