Reltio Merge

 On this Page

Snap Type:Transform
Description:

 This Snap merges the Reltio Objects (Entities or Categories) data for a given Winner and Loser entity or for category IDs as mentioned on the Tenant. It provides a potential match between the two entities.  

Winner ID describes the Entity ID as a resulting 'survivor' and combines all attributes, crosswalks, roles and tags from the 'losing' entity into it.

Loser ID describes the Entity ID to be merged into the Winner (survivor) object, where an entity corresponds to one of the Reltio Objects.

ETL Transformations & Data Flow

The Snap transforms the existing entities provided as an input into a merged entity.

Input & Output

  • Input: The Input view is optional and is required only to pass the Winner/Loser ID from the upstream Snap or value in that field. Only the fields marked with an asterisk ( * ) are the required inputs; all other fields are optional.
  • OutputResponse for this Snap differs based on the operation selected. For potential matches, the Snap provides a 'success' or 'failure' message accordingly. For merging entities or categories, the Snap provides the attributes of the merged entity in the output.

Modes

Prerequisites:

A valid Reltio account with the tenant ID for the Tenant URL, or an  API key for the Account Settings to be generated.

The Reltio account must have sufficient access to merge the objects or entities from the Tenant.

Limitations and Known Issues:

You cannot roll back the productized Reltio Snap Pack in 4.20 to a prior version.

Configurations:

Account & Access

This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Reltio Account for information on setting up this type of account.

InputThis Snap has exactly one document input view.
OutputThis Snap has exactly one document output view.
ErrorThis Snap has at most one document error view and produces zero or more documents in the view.
Troubleshooting:None at this time.

Settings

Label


Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Tenant URL

Required. This determines the Reltio host with tenant ID. Use this format:
https://<your_reltio_host>/reltio/api/<tenant_id>

The value can be passed directly or through the pipeline parameters, but not through the upstream.

Example: https://test.reltio.com/reltiotest/api/XKiqdracb178fmuXYr3U7ZrG6/

Default value: https://<your_reltio_host>/reltio/api/<tenant_id>

Operations

Specifies the merge operation to be performed. The available options are:

  • Merge Entities: Merges two entities.
  • Merge Categories: Merges two categories.
  • Potential Match For Entities: Provides a potential match for the entities.

Default valueMerge Entities

Winner Id

Required. Specifies the Winner entity or category identifier.

This field describes the entity ID as a resulting 'survivor' and combines all the attributes, crosswalks, roles and tags from the 'losing' entity into it.

The value can be passed using the upstream Snap or through the pipeline parameters.

Default value: $winnerId

Loser Id

Required. Specifies the loser entity or the category identifier. This field describes the Entity ID to be merged in the survivor object.

The value can be passed using the upstream Snap or through the pipeline parameters.

Default value: $loserId

Retry limit

Determines the maximum number of attempts to get the response. 

Default value: 5

Minimum value: 1

Maximum value: 10

This value can be provided dynamically as a pipeline parameter or directly in the Snap but not as an upstream parameter. 

Snap Execution

Select one of the three modes in which the Snap executes. Available options are:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.
  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.
  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Basic Use Case

The following pipeline describes how the Snap functions as a standalone Snap in a pipeline:



Typical Snap Configurations

The key Snap configurations for the Snap are:

  • With Expressions
    The values are passes directly into the Snap:

  • Without Expressions
    • Using the Upstream Query: The values (Queue name and Queue URL) are passed using the upstream Snap:


  • Using the Pipeline Parameters: The values (Winner Id and Loser Id) are passed using the pipeline parameters:


The values set as the pipeline parameters:

Advanced Use Case


The following describes a pipeline, with a broader business logic involving multiple ETL transformations, that shows how typically in an enterprise environment, the Reltio functionality is used. The pipeline download is available in the Downloads section.

This pipeline retrieves the data from the Oracle Database and loads into the Reltio instance.


The key ETL transformations: 

Extract: The Oracle Select Snap retrieves the data from Oracle database.

Transform: The Head and the Mapper Snaps maps the specific data to be moved into the Reltio instance.

Load: The Reltio Create Snap creates the entities from the documents received from the upstream.

The pipeline further uses the Reltio Merge, Unmerge  and the Delete Snaps to perform the respective functions while transforming ( the JSON Splitter, Mapper and the Head Snaps) the data to serve the various business purposes.


Downloads

  File Modified

File Reltio Merge_2018_01_29.slp

Jan 29, 2018 by Aparna Tayi

File Reltio Adv Use case.slp

Feb 17, 2018 by Aparna Tayi

Snap Pack History

 Click to view/expand
Release Snap Pack VersionDateType  Updates
4.26main11181 StableUpgraded with the latest SnapLogic Platform release.
4.25 Patch425patches10410 LatestFixed an issue with the Reltio Create Snap where the Snap processes a lesser number of documents while loading data into Reltio.
4.25main9554
 
StableUpgraded with the latest SnapLogic Platform release.
4.24main8556
StableUpgraded with the latest SnapLogic Platform release.
4.23main7430
 
StableUpgraded with the latest SnapLogic Platform release.
4.22main6403
 
StableUpgraded with the latest SnapLogic Platform release.
4.21snapsmrc542

 

StableUpgraded with the latest SnapLogic Platform release.
4.20snapsmrc535
 
StableUpgraded with the latest SnapLogic Platform release.
4.19snaprsmrc528
 
StableUpgraded with the latest SnapLogic Platform release.
4.18snapsmrc523
 
StableUpgraded with the latest SnapLogic Platform release.
4.17ALL7402
 
Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17snapsmrc515
 
Latest

Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16 Patch reltiosnapconnector6773 Latest

Fixed an issue with the Reltio Generic Execute Snap wherein response codes were handled incorrectly.

4.16snapsmrc508
 
StableUpgraded with the latest SnapLogic Platform release.
4.15snapsmrc500
 
StableUpgraded with the latest SnapLogic Platform release.
4.14snapsmrc490
 
Stable

New Snap added: Reltio Generic Execute.

4.13 Patch reltiosnapconnector5200 Latest
  • Fixed the Reltio Read (Object) Snap to fetch all the records from Reltio objects (entities, categories, and relations, except interactions).
  • Added two new properties -- "Page Size" and "Records to Read" in the Read (Object) Snap.
4.13

snapsmrc486

 
Stable
  • Added a new property, S3 File, to the Reltio Bulk Export Snap to support exporting data to the specified S3 location.
  • Added new properties Batch size, and Thread limit to the Reltio Delete (URI) and Reltio Delete (Object) Snaps to enhance the performance.
4.12

snapsmrc480

 
Stable

Introduced the Snap Pack this release. The Snap Pack includes: Reltio Bulk Export, Reltio Create, Reltio Delete (Object), Reltio Delete (URI), Reltio Merge, Reltio Read (CrossWalk), Reltio Read (Object), Reltio Unmerge and Reltio Update.