Reltio Unmerge

In this article

Snap Type:Write
Description:

This Snap is used to un-merge the merged Reltio Objects (only Entities) on the mentioned Tenant. Based on Snap's configuration it is also possible to unmerge composite Entities. 

ETL Transformations & Data Flow

The Reltio Unmerge Snap transforms the merged Reltio Objects into separate un-merged entities.

Input & Output

  • InputInput view is optional and is required only to pass the Origin Entity Id/ Spawn Entity Id from upstream Snaps or as a value in their corresponding properties.
  • Output: Response for the snap contains every field of each unmerged Entity.

Modes

Prerequisites:Reltio account with a valid Tenant Id so that Tenant URL can be formed/API for Account Settings. Also, the Reltio account must have write access in order to be able to create Objects in 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.

Views

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 the moment.

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. The format to be used is https://<reltio_host>/reltio/api/<tenant_id>

Examplehttps://sndbx.reltio.com/reltio/api/XK178mXYr3UZrG6/

Default valuehttps://test.reltio.com/reltiotest/api/XKiqdracb178fmuXYr3U7ZrG6/


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

Operations

This specifies the type of unmerge operation. Possible allowed values are Unmerge Entities and Not a potential match.

  • Unmerge Entities - This option performs unmerge of the provided Enitity object
  • Not a Potential Match - This option removes the “Potential Matches” option from those two entities. <need more info>

Default value: Unmerge Entities

Origin Entity Id

RequiredThis parameter describes the composite Entity Id which is the parent Entity ID (similar to Winner Id in Reltio Merge Snap) formed during the merge operation.

Default value[None]


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

Spawn Entity Id

RequiredThis parameter describes the Entity Id which is the child of the merged Entity (similar to Loser Id in Reltio Merge Snap) formed during the merge operation.

Default value[None]


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

Unmerge entity tree

This option can be used for a composite Entity, an Entity that is the result of several merge operations. If enabled, every component (contributor) can be unmerged to be a standalone entity again. If not selected, only the initial state of spawn without any merges would be unmerged.

Default value: Not selected

Retry limit

Specify the maximum number of attempts to get the response. 

Minimum value: 1
Maximum value: 10

Default Value: 5

You can provide this value dynamically as a Pipeline parameter or directly in the Snap, but not as an upstream value. 

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.

Examples


Basic Use Case

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

The Snap is configured with the following parameters:

An example of the output from executing this pipeline:

Typical Snap Configurations

Key configuration of the Snap lies in how the values are passed. The values can be passed:

  • Without Expression:

Values are passed directly into the Snap:

  • With Expression:
    • Using upstream parameters:

Values are passed as upstream 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 

Important steps to successfully reuse Pipelines

  1. Download and import the pipeline into the SnapLogic application.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.

  File Modified

File Basic Use Case_Reltio_Unmerge.slp

Jan 17, 2018 by Mohammed Iqbal

File Reltio Adv Use case.slp

Feb 17, 2018 by Aparna Tayi

Snap Pack History

 Click to view/expand
Release Snap Pack VersionDateType  Updates
August 2024438patches28852 

Latest

Fixed an issue with the Reltio OAuth2 Account that caused multiple refresh token calls. Now, the account refreshes the token based on its expiration time.

August 2024438patches28012 Latest

Added the Reltio OAuth2 Account that authenticates the user via the Client credentials Grant type.

August 2024main27765 StableUpdated and certified against the current SnapLogic Platform release.

May 2024

main26341

 

Stable

Updated and certified against the current SnapLogic Platform release.

February 2024main25112 StableUpdated and certified against the current SnapLogic Platform release.
November 2023main23721 StableUpdated and certified against the current SnapLogic Platform release.

August 2023

main22460

 

Stable

Updated and certified against the current SnapLogic Platform release.

May 2023

main21015 

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023main19844 StableUpgraded with the latest SnapLogic Platform release.
November 2022main18944 StableUpgraded with the latest SnapLogic Platform release.
October 2022430patches18173 Latest

The Reltio Snaps which previously hung when there was no data or while processing the data will now time out when there is a slow server response.

August 2022main17386 StableUpgraded with the latest SnapLogic Platform release.
4.29main15993 StableUpgraded with the latest SnapLogic Platform release.
4.28main14627 StableUpgraded with the latest SnapLogic Platform release.
4.27 Patch427patches12999 Latest

Enhanced the Reltio Generic Execute with a new field Empty Responses as Separate Documents, that enables the Snap to write empty responses as separate documents.

4.27main12833StableUpgraded with the latest SnapLogic Platform release.
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.