Use Azure Data Factory to ingest data into an Azure Operator Insights Data Product

This article covers how to set up Azure Data Factory to write data into an Azure Operator Insights Data Product. For more information on Azure Data Factory, see What is Azure Data Factory.

Prerequisites

• A deployed Data Product: see Create an Azure Operator Insights Data Product.
• Permission to add role assignments to the Azure Key Vault instance for the Data Product.
  • To find the key vault, search for a resource group with a name starting with <data-product-name>-HostedResources-; the key vault is in this resource group.
• A deployed Azure Data Factory instance.
• The Data Factory Contributor role on the Data Factory instance.

Create a Key Vault linked service

To connect Azure Data Factory to another Azure service, you must create a linked service. First, create a linked service to connect Azure Data Factory to the Data Product's key vault.

1. In the Azure portal, find the Azure Data Factory resource.
2. From the Overview pane, launch the Azure Data Factory studio.
3. Go to the Manage view, then find Connections and select Linked Services.
4. Create a new linked service using the New button.
   1. Select the Azure Key Vault type.
   2. Set the target to the Data Product's key vault (the key vault is in the resource group with name starting with <data-product-name>-HostedResources- and is named aoi-<uid>-kv).
   3. Set the authentication method to System Assigned Managed Identity.
5. Grant Azure Data Factory permissions on the Key Vault resource.
   1. Go to the Data Product's key vault in the Azure portal.
   2. In the Access Control (IAM) pane, add a new role assignment.
   3. Give the Data Factory managed identity (this has the same name as the Data Factory resource) the 'Key Vault Secrets User' role.

Create a Blob Storage linked service

Data Products expose a Blob Storage endpoint for ingesting data. Use the newly created Key Vault linked service to connect Azure Data Factory to the Data Product ingestion endpoint.

1. In the Azure portal, find the Azure Data Factory resource.
2. From the Overview pane, launch the Azure Data Factory studio.
3. Go to the Manage view, then find Connections and select Linked Services.
4. Create a new linked service using the New button.
   1. Select the Azure Blob Storage type.
   2. Set the authentication type to SAS URI.
   3. Choose Azure Key Vault as the source.
   4. Select the Key Vault linked service that you created in Create a key vault linked service.
   5. Set the secret name to input-storage-sas.
   6. Leave the secret version as the default value ('Latest version').

Now the Data Factory is connected to the Data Product ingestion endpoint.

Create Blob Storage datasets

To use the Data Product as the sink for a Data Factory pipeline, you must create a sink dataset.

1. In the Azure portal, find the Azure Data Factory resource.
2. From the Overview pane, launch the Azure Data Factory studio.
3. Go to the Author view -> Add resource -> Dataset.
4. Create a new Azure Blob Storage dataset.
   1. Select your output type.
   2. Set the linked service to the Data Product ingestion linked service that you created in Create a blob storage linked service.
   3. Set the container name to the name of the data type that the dataset is associated with.
      • This information can be found in the Required ingestion configuration section of the documentation for your Data Product.
      • For example, see Required ingestion configuration for the Monitoring - MCC Data Product.
   4. Ensure the folder path includes at least one directory; files copied into the root of the container won't be correctly ingested.
   5. Set the other fields as appropriate for your data.
5. Follow the Azure Data Factory documentation (for example Creating a pipeline with the UI) to create a pipeline with this new dataset as the sink.

Repeat this step for all required datasets.

Create Data Pipelines

Your Azure Data Factory is now configured to connect to your Data Product. To ingest data using this configuration, you must follow the Data Factory documentation.

1. Set up a connection in Azure Data Factory to the service containing the source data.
2. Set up pipelines in Azure Data Factory to copy data from the source into your Data Product, using the datasets created in the last step.

Related content

Learn how to:

• View data in dashboards.
• Query data.