Reltio Connect

Hi There,

We would like to get a detailed report of all the potential matches existing in our tenant which provides both source entity and the matched entity and here are couple of questions we do have,

1. Is there an API call to do so. When asked in RIA, it did update with following information,

To export data for all potential matches in the tenant, you can use the /export/potential-matches endpoint. This endpoint provides functionality which allows you to export merge tree data for all entities in a tenant. This is an asynchronous request which returns IDs of tasks which will perform exporting data. Using these IDs, you have an ability to track statuses of these tasks.

Here are the steps on how to use the /export/potential-matches endpoint:

1. Make a POST request to the /export/potential-matches endpoint.
2. In the request body, specify the following parameters:
   • tenantId: The ID of the tenant from which you want to export data.
   • format: The format of the exported data. Supported formats are CSV, JSON, and XML.
   • filter: A filter expression that specifies which entities to export. For more information on filter expressions, see the Reltio documentation.

The link is broken and unable to view further information.

2. Can we use the ROCS utility for Potential Matches export to push a file to S3 bucket. We would like to automate this like a daily job.

Please provide your inputs.

Thanks,

Vish

Hi Vishvesh,

The ROCS utility here does not seem to directly support S3 destinations.  https://bitbucket.org/reltio-ondemand/pot-mat-data-extract/src/master/. However, you can copy to S3 once you have the file.

Hi There,

We would like to get a detailed report of all the potential matches existing in our tenant which provides both source entity and the matched entity and here are couple of questions we do have,

1. Is there an API call to do so. When asked in RIA, it did update with following information,

To export data for all potential matches in the tenant, you can use the /export/potential-matches endpoint. This endpoint provides functionality which allows you to export merge tree data for all entities in a tenant. This is an asynchronous request which returns IDs of tasks which will perform exporting data. Using these IDs, you have an ability to track statuses of these tasks.

Here are the steps on how to use the /export/potential-matches endpoint:

1. Make a POST request to the /export/potential-matches endpoint.
2. In the request body, specify the following parameters:
   • tenantId: The ID of the tenant from which you want to export data.
   • format: The format of the exported data. Supported formats are CSV, JSON, and XML.
   • filter: A filter expression that specifies which entities to export. For more information on filter expressions, see the Reltio documentation.

The link is broken and unable to view further information.

2. Can we use the ROCS utility for Potential Matches export to push a file to S3 bucket. We would like to automate this like a daily job.

Please provide your inputs.

Thanks,

Vish

BTW, what do you want to do with the extract once you have it in S3?

Hi Vishvesh,

The ROCS utility here does not seem to directly support S3 destinations.  https://bitbucket.org/reltio-ondemand/pot-mat-data-extract/src/master/. However, you can copy to S3 once you have the file.

Hi There,

We would like to get a detailed report of all the potential matches existing in our tenant which provides both source entity and the matched entity and here are couple of questions we do have,

1. Is there an API call to do so. When asked in RIA, it did update with following information,

To export data for all potential matches in the tenant, you can use the /export/potential-matches endpoint. This endpoint provides functionality which allows you to export merge tree data for all entities in a tenant. This is an asynchronous request which returns IDs of tasks which will perform exporting data. Using these IDs, you have an ability to track statuses of these tasks.

Here are the steps on how to use the /export/potential-matches endpoint:

1. Make a POST request to the /export/potential-matches endpoint.
2. In the request body, specify the following parameters:
   • tenantId: The ID of the tenant from which you want to export data.
   • format: The format of the exported data. Supported formats are CSV, JSON, and XML.
   • filter: A filter expression that specifies which entities to export. For more information on filter expressions, see the Reltio documentation.

The link is broken and unable to view further information.

2. Can we use the ROCS utility for Potential Matches export to push a file to S3 bucket. We would like to automate this like a daily job.

Please provide your inputs.

Thanks,

Vish

Hi Gino,

We are trying to build a BI dashboard to get the potential duplicates so that our BDR can view this information and do data corrections.

This is a requirement from business to have a visibility of Potential duplicates

Thanks,

Vish

BTW, what do you want to do with the extract once you have it in S3?

Hi Vishvesh,

The ROCS utility here does not seem to directly support S3 destinations.  https://bitbucket.org/reltio-ondemand/pot-mat-data-extract/src/master/. However, you can copy to S3 once you have the file.

Hi There,

We would like to get a detailed report of all the potential matches existing in our tenant which provides both source entity and the matched entity and here are couple of questions we do have,

1. Is there an API call to do so. When asked in RIA, it did update with following information,

To export data for all potential matches in the tenant, you can use the /export/potential-matches endpoint. This endpoint provides functionality which allows you to export merge tree data for all entities in a tenant. This is an asynchronous request which returns IDs of tasks which will perform exporting data. Using these IDs, you have an ability to track statuses of these tasks.

Here are the steps on how to use the /export/potential-matches endpoint:

1. Make a POST request to the /export/potential-matches endpoint.
2. In the request body, specify the following parameters:
   • tenantId: The ID of the tenant from which you want to export data.
   • format: The format of the exported data. Supported formats are CSV, JSON, and XML.
   • filter: A filter expression that specifies which entities to export. For more information on filter expressions, see the Reltio documentation.

The link is broken and unable to view further information.

2. Can we use the ROCS utility for Potential Matches export to push a file to S3 bucket. We would like to automate this like a daily job.

Please provide your inputs.

Thanks,

Vish

The alternate way to do this would be to use the Snowflake/BigQuery/Databricks data pipeline.  But unless you have one of those I think your best bet is to use the ROCS utility.

Hi Gino,

We are trying to build a BI dashboard to get the potential duplicates so that our BDR can view this information and do data corrections.

This is a requirement from business to have a visibility of Potential duplicates

Thanks,

Vish

BTW, what do you want to do with the extract once you have it in S3?

Hi Vishvesh,

The ROCS utility here does not seem to directly support S3 destinations.  https://bitbucket.org/reltio-ondemand/pot-mat-data-extract/src/master/. However, you can copy to S3 once you have the file.

Hi There,

We would like to get a detailed report of all the potential matches existing in our tenant which provides both source entity and the matched entity and here are couple of questions we do have,

1. Is there an API call to do so. When asked in RIA, it did update with following information,

To export data for all potential matches in the tenant, you can use the /export/potential-matches endpoint. This endpoint provides functionality which allows you to export merge tree data for all entities in a tenant. This is an asynchronous request which returns IDs of tasks which will perform exporting data. Using these IDs, you have an ability to track statuses of these tasks.

Here are the steps on how to use the /export/potential-matches endpoint:

1. Make a POST request to the /export/potential-matches endpoint.
2. In the request body, specify the following parameters:
   • tenantId: The ID of the tenant from which you want to export data.
   • format: The format of the exported data. Supported formats are CSV, JSON, and XML.
   • filter: A filter expression that specifies which entities to export. For more information on filter expressions, see the Reltio documentation.

The link is broken and unable to view further information.

2. Can we use the ROCS utility for Potential Matches export to push a file to S3 bucket. We would like to automate this like a daily job.

Please provide your inputs.

Thanks,

Vish

Hi Gino,

Please guide us on how we can get the potential matches which includes the entity, matched entity and match rule(if possible) using snowflake. Is there a design document handy.

Thanks,

Vish

The alternate way to do this would be to use the Snowflake/BigQuery/Databricks data pipeline.  But unless you have one of those I think your best bet is to use the ROCS utility.

Hi Gino,

We are trying to build a BI dashboard to get the potential duplicates so that our BDR can view this information and do data corrections.

This is a requirement from business to have a visibility of Potential duplicates

Thanks,

Vish

BTW, what do you want to do with the extract once you have it in S3?

Hi Vishvesh,

The ROCS utility here does not seem to directly support S3 destinations.  https://bitbucket.org/reltio-ondemand/pot-mat-data-extract/src/master/. However, you can copy to S3 once you have the file.

Hi There,

We would like to get a detailed report of all the potential matches existing in our tenant which provides both source entity and the matched entity and here are couple of questions we do have,

1. Is there an API call to do so. When asked in RIA, it did update with following information,

To export data for all potential matches in the tenant, you can use the /export/potential-matches endpoint. This endpoint provides functionality which allows you to export merge tree data for all entities in a tenant. This is an asynchronous request which returns IDs of tasks which will perform exporting data. Using these IDs, you have an ability to track statuses of these tasks.

Here are the steps on how to use the /export/potential-matches endpoint:

1. Make a POST request to the /export/potential-matches endpoint.
2. In the request body, specify the following parameters:
   • tenantId: The ID of the tenant from which you want to export data.
   • format: The format of the exported data. Supported formats are CSV, JSON, and XML.
   • filter: A filter expression that specifies which entities to export. For more information on filter expressions, see the Reltio documentation.

The link is broken and unable to view further information.

2. Can we use the ROCS utility for Potential Matches export to push a file to S3 bucket. We would like to automate this like a daily job.

Please provide your inputs.

Thanks,

Vish

Hi Gino,

Please guide us on how we can get the potential matches which includes the entity, matched entity and match rule(if possible) using snowflake. Is there a design document handy.

Thanks,

Vish

The alternate way to do this would be to use the Snowflake/BigQuery/Databricks data pipeline.  But unless you have one of those I think your best bet is to use the ROCS utility.

Hi Gino,

We are trying to build a BI dashboard to get the potential duplicates so that our BDR can view this information and do data corrections.

This is a requirement from business to have a visibility of Potential duplicates

Thanks,

Vish

BTW, what do you want to do with the extract once you have it in S3?

Hi Vishvesh,

The ROCS utility here does not seem to directly support S3 destinations.  https://bitbucket.org/reltio-ondemand/pot-mat-data-extract/src/master/. However, you can copy to S3 once you have the file.

Hi There,

We would like to get a detailed report of all the potential matches existing in our tenant which provides both source entity and the matched entity and here are couple of questions we do have,

1. Is there an API call to do so. When asked in RIA, it did update with following information,

To export data for all potential matches in the tenant, you can use the /export/potential-matches endpoint. This endpoint provides functionality which allows you to export merge tree data for all entities in a tenant. This is an asynchronous request which returns IDs of tasks which will perform exporting data. Using these IDs, you have an ability to track statuses of these tasks.

Here are the steps on how to use the /export/potential-matches endpoint:

1. Make a POST request to the /export/potential-matches endpoint.
2. In the request body, specify the following parameters:
   • tenantId: The ID of the tenant from which you want to export data.
   • format: The format of the exported data. Supported formats are CSV, JSON, and XML.
   • filter: A filter expression that specifies which entities to export. For more information on filter expressions, see the Reltio documentation.

The link is broken and unable to view further information.

2. Can we use the ROCS utility for Potential Matches export to push a file to S3 bucket. We would like to automate this like a daily job.

Please provide your inputs.

Thanks,

Vish