
Explore master data and MDM concepts, including a single version of the truth, operational and analytical use cases, data cleansing and enrichment, and the four styles: registry, consolidation, coexistence, centralized.
Cover prerequisites: Oracle database, SQL Developer, Java, and the Semarchy pre-configured package; set Java home and prepare an on premise Semarchy environment.
Configures Semarchy xDM for Oracle by creating repository, discovery read-only, and data location schemas; sets environment and startup tokens, then launches the design repository and accesses the Semarchy portal.
Complete post-installation steps by connecting to the repository and granting profiling table permissions, then manage licensing to keep the instance active beyond six days.
Explore the free Semarchy xDM documentation on the official site to learn about installation, data hub design and management, integration rules, plugins, discovery, dashboards, and data governance features.
Create your first data model in Semarchy xDM by defining data types, building entities (basic, ID matching, fuzzy matching), and enforcing referential integrity with a golden ID.
Learn to build a Semarchy xDM data model in application builder by creating complex types like effective dates and a gender list, and defining customer and country entities.
Create and connect entities using reference relationships and diagrams to build a customer data model, including marital status and country reference data, with manual primary keys and complex attributes.
Semarchy xdm explains enrichers and validations, using pre-consolidation and post-consolidation rules, sql and java plugins, and practical examples like standardizing names and validating emails.
Explore how Semarchy xDM matches and merges records using exact and fuzzy matching, binning, match rules and scores, and defines merge policies to create golden records.
Define a matcher and merge policies in Semarchy xDM, create and tune match rules using normalize functions and edit distance similarity, set thresholds, and enable auto-confirm and merging.
Modify the match and merge configuration in the customer data model by setting post code to exact match, adjusting fuzzy match similarity threshold, and enabling auto confirm for golden records.
Explore survivorship rules that govern how fuzzy or id-matched data consolidate into a golden record, defining consolidation and override strategies, with publishers and per-attribute rules.
Discover how semarchy uses data sources to connect to databases via JDBC, configure and test sources for dashboards, data locations, and discovery, and tailor privileges per use case.
explore data locations in Semarchy xDM, including development and production locations, and how database schemas deploy physical tables, keys, and views to cleanse, enrich, and validate data into golden records.
Learn how to deploy and validate a Semarchy xDM data model, manage data locations, apply versioned changes, set maintenance mode, and export backups for a ready production deployment.
Design an application in Semarchy xDM that provides customizable access to master data via a web UI, enabling data authoring, collaboration, workflows, and multiple views from one data model.
Learn how display cards present data with primary, secondary, and supporting text, plus optional images or avatars, demonstrated by concatenating first and last names and displaying occupation.
Explore forms in Semarchy xDM by configuring tabs, containers, and sections to organize customer attributes; learn to add derived fields, adjust layouts, and set form properties.
Create and customize a collection by selecting a display card and choosing list, grid, or table views, arranging attributes like country and marital status with metadata and custom columns.
Explore the remaining components for application design, including stepper-driven workflows, duplicate manager interfaces with graph or table views, business views, action sets, application folders, and global search in Semarchy xDM.
Explore how the application wizard in Semarchy xDM (MDM) creates all application design components for entities in one go, including forms, collections, display cards, action sets, and business views.
Set up the default application in Semarchy xDM by configuring documentation, mapping the data model, and creating folders, views, and actions for live updates without deployment.
Explore how Semarchy integrates data from publishers to consumers using REST API or ETL, with MDM enrichment, validation, and match and merge to produce golden records.
Explore how continuous loads streamline publishing data to the Semarchy xDM hub by using a static load ID, automatic external loads, and interval-based data processing with integration jobs.
Learn how to load countries as a reference entity before loading customers, handling start and end dates, ISO codes, and data import workflows in semarchy xdm.
Create and manage marital status records in Semarchy xDM, importing codes from Excel or CSV, and define start and end dates while ensuring unique primary keys.
Create and customize customer records in Semarchy xDM by configuring forms to include country, marital status, and gender, setting up display cards, and concatenating full names for a golden record.
Explore the physical data hub structure in Semarchy, showing how source data is loaded, enriched, cleansed, and validated to form the golden version of truth.
Load customers via continuous loads in Semarchy xDM, populating load ID, publisher ID, source ID, class name. Explore survivorship and matcher rules merging CRM and MKTG records into golden data.
Explore Semarchy xDM rest api basics: query records from a data location, count golden and master data, publish data via rest api, and configure authentication and payloads with Postman.
Monitor Semarchy through the management tab, tracking data locations, continuous loads, integration batches, rest calls, and UI activity to be sure of reliable data governance.
Profile data sources in Semarchy discovery by configuring JDBC connections, applying profiling metrics, and viewing per-column indicators for duplicates, nulls, and pattern frequencies in MDM.
Create Semarchy dashboards by connecting a data source, crafting standard SQL queries, and designing charts to display in widgets across dashboard tabs. Configure navigation to open dashboards for end users.
Create users and roles in Semarchy xDM, configure authentication via internal providers or single sign-on, assign privileges for application design, management, and dashboards, and control data model access.
Explore Semarchy xDM's auditing and history features, including field-level details, value timelines, source contributions, and survivorship rules, plus golden-to-master record transitions and discovery dashboards.
This course is for anyone who wants to learn Semarchy xDM. Semarchy Master Data Management and Data Governance, is recognised for the third consecutive year in the Gartner Magic Quadrant for Master Data Management Solutions. This year, Gartner has positioned the Semarchy in the leaders’ quadrant. Semarchy provides features like data quality, data validation, data matching, de-duplication, data authoring, workflows, and more in one single platform.
We will achieve the below in this course:
Installation of Semarchy
Understanding Data Model components and building it step by step
Deploying our data model to Oracle database
Designing our Application which will be used by End Users/Data Stewards
Understanding Semarchy discovery to profile data sources
Creating our first Dashboard with Metrics and charts
Setting up integration with Semarchy
Understanding Security (users and roles)
Workflows for collaboration between different teams
If you have experience in other MDM products and you want to add Semarchy to your profile or you have some knowledge of Semarchy but wants to learn more or you want to create a Semarchy proof of concept(POC) within few hours for a sales pitch, this is the course for you.
We will use all free available resources in this course so you can also have hands on experience with myself during this course. By the end of this course you should be confident to work in any Semarchy implementation.