Features

On this page

Sync business domains to Dataverse tables

This feature allows you to sync CluedIn business domains, vocabularies, and vocabulary keys with Dataverse table and columns.

To sync CluedIn business domains with Dataverse table

  1. On the navigation pane, go to Administration > Settings, and then find the PowerApps section.

  2. In Sync CluedIn Business Domains to Dataverse Table, turn on the toggle, and then enter the business domain that you want to sync. If you want to sync multiple business domains, separate them with a comma (for example, /_Type1,/Type2,/Type3).

    Sync Entity Types to Dataverse Tables

    Another way to enable this feature is to navigate to Management > Business Domains and select the business domain you want to sync. Then, select Edit and turn on the toggle for Sync CluedIn Business Domains to Dataverse Table. Finally, save changes.

    Sync Entity Types to Dataverse Tables

    All the vocabulary keys below will be created as columns in the Dataverse table.

    Sync Entity Types to Dataverse Tables

    Once the synchronization has been completed, you’ll receive two notifications: Dataverse Table Created and Dataverse Column Created/Updated.

    Sync Entity Types to Dataverse Tables Notification

  3. Verify the table and columns created in Dataverse.

    Sync Entity Types to Dataverse Tables

Sync Dataverse table to Cluedin business domains/vocabularies

This feature allows you to sync Dataverse table and columns into CluedIn business domains, vocabulary, and vocabulary keys.

Prerequisites

You’ll need to provide the logical name of the Dataverse table. There are the following ways to identify or get the logical name of the table:

  1. Go to table Properties, and then copy the value from the Logical name field.

  2. Go to Tools, and then select Copy logical name.

  3. In the table list view, the logical name is right after the table name.

    Identifying Logical Name

To sync Dataverse table and columns into CluedIn business domains and vocabulary

  1. On the navigation pane, go to Administration > Settings, and then find the PowerApps section.

  2. In Sync Dataverse Table/Columns to CluedIn Business Domains and Vocabulary, turn on the toggle, and then enter the Dataverse table name. The value should be the logical name of the table. If you want to sync multiple tables, separate them with a comma (for example, logical_name1,logical_name2,logical_name3_).

    sync-dataverse-table.png

    Once the synchronization has been successfully completed, you’ll receive three notifications: Entity Type Created, Vocabulary Created, and Vocabulary Keys Created.

    Sync Dataverse Table Notification

  3. Verify the business domain, vocabulary, and vocabulary keys created in CluedIn.

    Create New EntityType and Vocab

Create ingestion endpoint workflow

This feature allows you to automate the creation of workflow that will send the data from Dataverse to CluedIn via ingestion endpoint.

Prerequisites

  • Dataverse connection.

To automate the workflow creation

  1. In CluedIn, on the navigation pane, go to Administration > Settings, and then find the PowerApps section.

  2. In Create workflow to Ingest Data to CluedIn, turn on the toggle.

    Create workflow to Ingest Data to CluedIn

Ingestion endpoint

As part of workflow automation, the ingestion endpoint will be created as well. From our sample above, you can expect two ingestion endpoints to be created, one for each of the cluedin_dog and crc12_customer tables.

Power Automate Workflow Ingestion Endpoint

Workflow

The creation of workflow will depend on the values of Sync Business Domains and Sync Dataverse Tables. Once the execution of the job is done, from the sample values above, you can expect two workflows to be created, one for each of the cluedin_dog and crc12_customer tables.

Power Automate Workflows

You can expect to see a notification when the creation is successful.

Power Automate Workflow Notification

The content of the workflow will be composed of a Dataverse event named When a row is added, modified or delete (but mainly focused on Added and Modified) and an HTTP event that pushes the data into CluedIn ingestion endpoint. On the following screenshot, the token has been edited to show the full content of HTTP event.

Power Automate Workflow Content

Auto mapping and processing

As we already know the structure of the table/vocabulary that we are working on, the system will automate the data mapping and processing. By navigating to the data set page, you can notice that the Map, Prepare, and Process tabs are now available as we already automated the creation of the data mapping into our vocabularies.

Auto Mapping

On the Map tab, you can find the the full view of all columns mapped to our vocabulary, including edges (relationships) and identifiers, if there are any.

Auto Mapping

On the Preview tab, you can find the data received from Dataverse.

Ingestion Endpoint Preview

Once the data is received, you can expect to see it processed because we have also enabled the Auto submission property of the ingestion endpoint.

Auto Processing

Create a batch approval workflow process

This feature enables you to automate the creation of the workflow for the batch approval process. If you process the data (regardless of the source) and the system identifies that the business domain used has been tagged for the approval process, the data will be halted, and the approval process will start and wait for the user’s approval to continue the data processing.

Prerequisites

  • Dataverse connection
  • Approval connection

To enable the batch approval workflow

  1. In CluedIn, on the navigation pane, go to Management > Business Domains, and then select the business domain that you want to sync.

  2. Select Edit and then turn on the toggle for Enable for Batch Approval Workflow.

  3. Select Save.

    Create workflow for Batch Approval

    After enabling this feature, a new table (Approval Queue Table) will be created in Dataverse.

Approval Queue table in Dataverse

This table will serve as a storage of the CluedIn data or information on the data waiting for approval.

The CluedIn Approval Queue ID is the ID of the data that we are trying to approve in this process.

Approval Queue Table

Workflow

The content of the approval workflow will be composed of events such as condition, approval, variables, and HTTP. A 60-second cycle will occur to check if there is data in the Approval Queue table. Once we receive a response in the Approval Process, we send the Approval details together with the CluedIn Approval Queue IDs to the CluedIn API via an HTTP event.

Batch Approval Workflow

Notifications

Once the automation has been done, you can expect a notification for creating the Approval Queue Table/Columns and the creation of the Batch Approval Workflow.

Batch Approval Workflow notification

Create streams

This feature allows you to automate the creation of export targets and streams.

To automate the creation of export targets and streams

  1. On the navigation pane, go to Administration > Settings, and then find the PowerApps section.

  2. In Create CluedIn Stream, turn on the toggle.

    Create CluedIn Streams

Export targets

Export target will be created automatically using the same credentials from Organization Settings.

CluedIn Export Target

Streams

The creation of a stream will depend on the values of Sync Business Domains and Sync Dataverse Tables.

Once the execution of the job is done, from the sample values above, two streams should have been created, one for each of the cluedin_dog and crc12_customer tables.

CluedIn Streams

Each stream will have a certain configuration filtered by business domain.

CluedIn Stream Configuration

It will automatically assign the same export target that was created from the Dataverse connector. Incoming and outgoing edges are set to be exported. All the properties associated with it have been automatically added too.

CluedIn Stream Export Target Configuration

Notifications

Two notifications can be expected in this job: Stream created and Stream mapping updated.

CluedIn Streams Notifications