Synchronize data between Reltio and the GBQ Connector

Learn how to synchronize your entities, relations, matches, interactions, and merges data from Reltio to the GBQ connector.

Note: Before you synchronize date, perform the steps in Validate event transfer in GBQ with the Reltio UI and Validate event transfer in GBQ with the Reltio API.

After all configurations are completed, the next step is to synchronize data between the Reltio platform to the GBQ connector. This ensures that you always have the latest event data in your BigQuery dataset. You can view data being transmitted in your BigQuery dataset in the Dataset info section once you log in to the Google Cloud console. For more information, see topic Create a custom IAM role at the dataset level.

Note: If you choose the column-based schema in Submit a provisioning request to Reltio Support - SUPERSEDED and there is a data schema change, for example, you add a new attribute to a profile in the Reltio UI, you need to run this command again.

To synchronize data, execute:

POST http(s)://{{environment}}.reltio.com/reltio/api/{{tenantId}}/syncToDataPipeline

After the request is completed, run the following periodic tasks to check if the task is successfully completed:

Run GET {ApplicationURL}/tasks to check the current task status.
Run GET {ApplicationURL}/{Tenant}/tasks/history to check the task history.
Run GET {ApplicationURL}/{Tenant}/tasks/{taskId} to check the status of a specific task.
Run GET {{hub-url}}/status/tenant/{{tenantID}}/details to check the number of messages that are currently in the tenant queue to be processed. The queue count must be 0 once the processing is completed, that is, the data load is complete.

Once the task is completed successfully, view the latest data in your tenant’s Profile view. For more information, see topic Profile view.

Here are some helpful tips when it comes to troubleshooting issues that may occur after you synchronize Reltio with GBQ:

After the syncToDataPipeline API has run successfully, check the queue status API to see if the event count is 0.
Check if the event count in the Reltio platform is in sync with the event count in GBQ.
If there appears to be a discrepancy in the count of events in the Reltio platform and in GBQ, check to see if the events are being loaded to your cloud storage storage using the event monitoring API.
If there is an entity update that was made in the Reltio platform but did not appear in your GBQ, use the entity monitoring API to determine if the issue is with the Reltio platform or your GBQ account by checking the event status history for any incomplete events for a particular entity.

For any other issues, contact support.

Accelerate the Value of Data

Synchronize data between Reltio and the GBQ Connector

Footer