Advanced Use Case (Reltio Unmerge)

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.



  1. This pipeline retrieves the data from the Oracle Database and loads into the Reltio instance.
  2. The key ETL transformations:
  3. Extract: The Oracle - Select Snap retrieves the data from Oracle database.
  4. Transform: The Head and the Mapper Snaps map the specific data to be moved into the Reltio instance.
  5. Load: The Reltio Create Snap creates the entities from the documents received from the upstream.
  6. The pipeline further uses the Reltio Merge, Reltio Unmerge, and Reltio Delete (Object) Snaps to perform the respective functions while transforming (the JSON Splitter, Mapper, and Head Snaps) the data to serve the various business purposes.
To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.