Integration Guide

Overview

Using this guide, you will:

Tip: If you want to try Semarchy Convergence for MDM, you can use our demonstration environment and getting started guide: Getting Started with Semarchy.

Contents

  1. Integration Guide
    1. Overview
    2. Contents
  2. Preface
    1. Audience
    2. Document Conventions
    3. Other Semarchy Resources
    4. Obtaining Help
    5. Feedback
  3. Introduction to Integration
    1. What is Semarchy Convergence for MDM?
    2. Overview of the Integration Methods
    3. Publishers and Consumers
      1. Publishers
      2. Consumers
    4. Integration Components
      1. External Load Management Interfaces
      2. Data Location Schema
      3. Integration Job
      4. Data Services
  4. External Load
    1. External Load Overview
    2. Submitting a Load
      1. Loads and Batches
      2. Process after a Submit
  5. Integration Job
    1. Certification Process Overview
    2. Tables Structures
      1. Tables
      2. Columns
        1. Attribute Columns
        2. Built-in Columns
        3. Primary Keys Columns
          1. ID Matching
          2. Fuzzy Matching
        4. Reference Columns
          1. Reference to an ID Matching Entity
          2. Reference to a Fuzzy Matching Entity
      3. Class Name and Inheritance
      4. Constraints
  6. Publishing Data into the Hub
    1. Methods for Publishing Data
      1. External Loads using PL/SQL and SQL
      2. External Loads using Web Services and SQL
        1. Accessing the Integration Load Web Service
    2. Initializing the External Load
      1. Initializing a Load (PL/SQL): INTEGRATION_LOAD.GET_NEW_LOADID
      2. Initializing a Load (Web Service): getNewLoadID
    3. Loading Data
      1. SD Tables to Load
      2. Referential Integrity and Load Order
      3. Using Transactions
      4. SD Columns to Load
        1. System Columns (Mandatory)
        2. Primary Keys (Mandatory)
          1. ID Matching Entity
          2. Fuzzy Matching Entity
        3. References (Mandatory)
          1. Reference to an ID Matching Entity
          2. Reference to a Fuzzy Matching Entity
        4. Attribute Columns
        5. Other SD Columns (Optional)
    4. Submitting the External Load
      1. Submitting an External Load (PL/SQL): INTEGRATION_LOAD.SUBMIT_LOAD
      2. Submitting an External Load (Web Service): submitLoad
    5. Canceling the Load
      1. Canceling a Load (PL/SQL): INTEGRATION_LOAD.CANCEL_LOAD
      2. Canceling a Load (Web Service): cancelLoad
  7. Consuming Data from the Hub
    1. SQL Consumption - Overview
    2. Golden Data
      1. Golden Data Table Structure
      2. Accessing Golden Data Using SQL
      3. Golden Data Primary Key
    3. Master Data
      1. Accessing Master Data Using SQL (ID Matching)
      2. Accessing Master Data Using SQL (Fuzzy Matching)
    4. Errors
      1. Accessing Pre-Consolidation Errors Using SQL
    5. Accessing Post-Consolidation Errors Using SQL
  8. Web Services
    1. Platform Services
      1. Platform Web Service
      2. Administrative Service
      3. Metadata Web Service
      4. Integration Load Web Service
    2. Data Services
      1. Data Services URL
      2. Data Access Service
        1. Data Access Web Services Structure
        2. Requests Examples
        3. Responses Examples:
      3. Generic Data Service
        1. Generic Data Service Bindings
        2. Querying Rows
        3. Checking Out Rows
        4. Inserting and Updating Records
        5. Removing Rows from a Transaction
      4. Activity Service
        1. Activity Service Bindings
        2. Starting an Activity
        3. Listing Tasks
        4. Managing Tasks