Reltio Beta

Reltio is a cloud-native master data management (MDM) platform.

Features

Supported deployment models

We support the SaaS Deployment model for the connector.

Setup guide

Follow our step-by-step Reltio setup guide to connect Reltio with your destination using Fivetran connectors.

Sync overview

To capture new records and updates, we incrementally sync the following tables and their child tables:

• ENTITY
• INTERACTION
• MATCH
• RELATION

We also re-import the following tables during every sync:

• ENTITY_ANALYTICS_ATTRIBUTE_TYPE
• ENTITY_ATTRIBUTE_TYPE
• ENTITY_TYPE
• INTERACTION_ATTRIBUTE_TYPE
• INTERACTION_MEMBER_TYPE
• INTERACTION_TYPE
• MATCH_GROUP
• RELATION_ATTRIBUTE_TYPE
• RELATION_TYPE
• SOURCE

Export limit

To avoid disrupting other Reltio processes, we reschedule the sync if more than 10 export tasks are already running (not including the connection sync).

We run up to 4 export tasks at the same time.

Syncing attributes

We sync the nested sub-attributes as individual rows in the attribute tables (ENTITY_ATTRIBUTE, ENTITY_ANALYTICS_ATTRIBUTE, INTERACTION_ATTRIBUTE, RELATION_ANALYTICS_ATTRIBUTE, and RELATION_ATTRIBUTE).

Example

In the following example, Country and Zip are two attributes of the Location type entity. Country is a simple attribute, whereas Zip is a nested attribute.

{
    "attributes": {
        "Country": [
            {
                "type": "configuration/entityTypes/Location/attributes/Country",
                "ov": true,
                "value": "United States of America",
            },
            {
                "type": "configuration/entityTypes/Location/attributes/Country",
                "ov": false,
                "value": "USA",
            }
        ], 
        "Zip": [
            {
                "value": {
                    "PostalCode": [
                        {
                            "type": "configuration/entityTypes/Location/attributes/Zip/attributes/PostalCode",
                            "ov": true,
                            "value": "12345",
                            "uri": "entities/fivetran_entity/attributes/Zip/ccc/PostalCode/dddd"
                        }
                    ],
                },
                "ov": true,
            }
        ]
    }
}

The rows corresponding to these attributes in the ENTITY_ATTRIBUTE table are as follows:

Syncing entity merges and unmerges

When an entity is merged in Reltio, we do the following in your destination:

• Soft delete the merged entity in the ENTITY table (set the _fivetran_deleted column to TRUE).
• Update the winner of the merge in the winner_id column of the merged entity.
• Sync the merge operation details into the ENTITY_MERGE table.

When an entity is unmerged in Reltio, we do the following in your destination:

• Mark the unmerged entity as active (set the _fivetran_deleted column to FALSE).
• Clear the winner_id column of the unmerged entity.
• Delete the information of the previously merged entity from the ENTITY_MERGE table.

Schema information

This schema applies to all Reltio connections created on or after June 19, 2024.

Explore Reltio schema ERD

Explore the interactive ERD

Limitations

We perform only incremental syncs for the NOT_MATCH table because the Activity Log API that we use to sync this table has a limited retention.