Developer’s Guide

Overview

Using this guide, you will learn how to:

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

Contents

  1. Developer's Guide
    1. Overview
    2. Contents
  2. Preface
    1. Audience
    2. Document Conventions
    3. Other Semarchy Resources
    4. Obtaining Help
    5. Feedback
  3. Introduction to Semarchy Convergence for DI
    1. High-Performance ELT Architecture
    2. Powerful User Experience
    3. Rationalized Production
    4. Enterprise Data Integration
  4. Introduction to the Semarchy DI Designer
    1. Opening the Semarchy DI Designer
    2. Semarchy DI Designer Overview
    3. Design-Time Views
      1. The Project Explorer
      2. The Properties View
      3. The Expression Editor
      4. The Outline View
      5. The Impact View
    4. The Run-Time Views
      1. The Runtime View
      2. The Sessions View
      3. The Session Detail View
      4. The Statistics View
      5. The Step Detail View
      6. The Variable View
  5. Working with Projects
    1. Creating Projects
    2. Creating Folders
    3. Importing Templates
    4. Version Control
  6. Working with Metadata
    1. Defining a Database Model
      1. Creating and Reversing a Database Model
      2. Adding a New Schema
      3. Reverse-engineering an Existing Schema
      4. Table Name Masks
      5. Work and Reject Schemas Selection
    2. Defining a File Model
      1. Creating a File Model
      2. Reverse-Engineering a Delimited File
      3. Reverse-Engineering a Fixed-Width File
    3. Defining an XML Model
    4. Defining a Generic Model
    5. Working with Configurations
      1. Creating a Configuration
      2. Using Configurations
        1. Using Configuration for Databases
        2. Using Configuration for Files
        3. Using Configuration for XML
  7. Working with Mappings
    1. Designing a Mapping: Overall Process
    2. Creating a New Mapping
    3. Adding the Target and Sources
    4. Joining the Sources
    5. Filtering the Sources
    6. Mapping the Target Columns
      1. Understanding Column Icons
    7. Mapping, Filter and Join Expressions
  8. Working with Processes
    1. Creating a Process
      1. Creating a new Process
      2. Adding a Mapping
      3. Adding an Action
      4. Adding a Sub-Process
      5. Referencing Another Process
    2. Execution Flow
      1. Steps Features
        1. Conditional Generation
        2. Step Repetition
        3. Startup Steps
      2. Links
    3. Advanced Process Development
      1. Process Parameters
      2. Bind Links
      3. Scripting
        1. Scripting Language
        2. Using Session Variables
        3. Using Scripts in Conditions
        4. Using the Scripting Context
          1. retValue Variable
          2. publishVariable Method
          3. getCurrentBindIteration Method
          4. sumVariable, averageVariable, countVariable, minVariable and maxVariable Methods
          5. getVariableCumulativeValue Method
          6. getVariableTreeByName Method
          7. getLstVariablesByName Method
          8. executeCommand and executeRemoteCommand Methods
      4. Link Metadata To Actions
        1. Linking Metadata to a Process/Action
        2. Using the Metadata Connection
        3. Using Metadata Specific Information
      5. Working with *Restart Points*
  9. Working with Variables
    1. Creating Variables in the metadata
      1. Creating the Metadata file
      2. Creating the Variables
      3. Variables properties
      4. Associating connections to variables
      5. Associating connections to Variables
        1. Defining a connection
        2. Saving and Refreshing connections
      6. Using the metadata to generate proper SQL Orders
    2. Using Variables in the Mappings
    3. Using variables in processes
    4. Syntax to use variables in expressions
    5. Using variables in other variables
    6. Using variables in other metadata
  10. Going to Production
    1. Running Processes
    2. Working with Deliveries
      1. Generating Deliveries
      2. Deploying Deliveries
    3. Working with Packages
      1. Generating a Package
      2. Generating a Delivery From a Package
      3. Extracting a Configuration File