Table of Contents

Search

  1. Preface
  2. Part 1: Concepts and Models
  3. Part 2: Custom XConnect Created with a Load Template
  4. Appendix A: Resource Configuration File

Metadata Manager Custom Metadata Integration Guide

Metadata Manager Custom Metadata Integration Guide

Sample Rule Set Definition Files to Link Endpoints

Sample Rule Set Definition Files to Link Endpoints

The following code shows a sample rule set definition file that defines linking rules between a PowerCenter model and a Microsoft SQL Server model:
<?xml version="1.0" encoding="UTF-8"?> <ruleSetDefinition name="test_ep_to_nep_def" description="Link on ref table name"> <sourceModel name="PowerCenter"/> <targetModel name="SQLServer"/> <param name="connection" description="PowerCenter connection name" type="connection" /> <param name="ref.name" description="Source qualifier reference table name" /> <param name="table.name" description="Table name" /> <rule name="source target"> <sourceFilter> <endPoint connection="${connection}" class="Source Qualifier Instance"/> </sourceFilter> <targetFilter> <element class="Sqlserver Table" condition="Name=${table.name}"> <element class="Sqlserver Column"/> </element> </targetFilter> <link condition="source.structName=${ref.name} AND target.parent.Name = source.structName AND target.Name = source.featureName" /> </rule> </ruleSetDefinition>
The following code shows a sample of a rule set parameter file that defines the source and target resources and the parameter values for the rule set definition file:
<?xml version="1.0" encoding="UTF-8"?> <ruleSetParams definition="test_ep_to_nep_def" name="INFA27003" description="Link rbl_pc to RBLSchema"> <sourceResource name="rbl_pc" /> <targetResource name="RBLSchema" /> <param name="connection" value="rbltest" /> <param name="ref.name" value="CUSTOMER" /> <param name="table.name" value="CUSTOMER" /> </ruleSetParams>

0 COMMENTS

We’d like to hear from you!